Database error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo

General questions regarding the use of languages in Joomla! 3.x.

Moderators: infograf768, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
GaryYumul
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Aug 02, 2018 7:43 am

Database error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo

Post by GaryYumul » Thu Aug 02, 2018 8:16 am

Hi

Im having an error "Database error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3" when updating the language extensions Dutch and Spanish. Please refer to the attached files.
Capture2.PNG
Capture.PNG


Thanks in advance.

Regards,
You do not have the required permissions to view the files attached to this post.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 26866
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Database error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio

Post by imanickam » Thu Aug 02, 2018 12:41 pm

I have tested these languages update (as listed in the image attached) in both Joomla! v.3.8.10 and v3.8.11. The updates were done without any error message.

What version of Joomla! is being used?

Also, could you please confirm whether it happens only with language packs or with any extension?

What happens if you download the new language files from http://joomlacode.org/gf/project/jtrans ... tion=index and install them?
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Translations Coordination Team | Tamil (தமிழ்) Translation Team

Eegan - Support the poor and underprivileged

GaryYumul
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Aug 02, 2018 7:43 am

Re: Database error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio

Post by GaryYumul » Mon Dec 17, 2018 3:57 am

Hi,

Sorry for the late response, but now we are encountering the same problem when installing plugins, updating core files and plugins. I can give you the login details to see the error. Please see below error. Thanks
Capture.JPG

Thanks in advance.

Regards,
Gary
You do not have the required permissions to view the files attached to this post.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 26866
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Database error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio

Post by imanickam » Mon Dec 17, 2018 5:02 am

What version of Joomla! is being used?

Whether Joomla! was upgraded from an earlier version? If the answer is "Yes", how was it upgraded?

In the screen "Extensions: Database" (Extension => Manage -> Database), if the database schema version is different than that of your Joomla! version, click on the button titled "Fix" and see what happens.

Note:
Make sure to take a back-up of your entire site files and the database content before attempting this.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Translations Coordination Team | Tamil (தமிழ்) Translation Team

Eegan - Support the poor and underprivileged

GaryYumul
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Aug 02, 2018 7:43 am

Re: Database error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio

Post by GaryYumul » Wed Dec 19, 2018 9:27 am

Hi,

Joomla version, 3.9.1 updated thru Joomla Update on the back end.

In the screen "Extensions: Database" (Extension => Manage -> Database), if the database schema version is different than that of your Joomla! version, click on the button titled "Fix" and see what happens.


DId the above suggestion and tried to install the plugin again and still showing the same error.

0 Database error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

I can give you back end access if needed. Thanks

Please help. Thanks

Regards,
Gary

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 36424
Joined: Sat Apr 05, 2008 9:58 pm

Re: Database error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio

Post by Webdongle » Wed Dec 19, 2018 10:16 am

http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein


Post Reply

Return to “Language - Joomla! 3.x”