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

GaryYumul · 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,

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?

GaryYumul · 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

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.

GaryYumul · 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

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

viewtopic.php?f=714&t=793531 please

The Joomla! Forum™

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

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

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

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

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

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

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