#37866 Update error

Posted in ‘Pre-sales and Account Questions’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by nicholas on Tuesday, 11 October 2022 12:40 CDT


I got this error after updating your latest version of Akeeba for joomla 3


You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY c2.`id`) AS c2 ON c2.newId = c.`id` SET `published` = c2.newPublis...' at line 6
Package Update: There was an error installing an extension:
Before updating ensure that the update is compatible with your Joomla! installation.
You are strongly advised to make a backup of your site's files and database before you start updating.

Akeeba Staff

Please keep in mind that it is Joomla itself installing extensions (both for the first time and when upgrading). Our code does not run at this point.

The SQL query referenced in the error message does not come from our software. It actually comes from Joomla itself. Namely, lines 1551 to 1567 of the file libraries/src/Table/Nested.php which contains the \Joomla\CMS\Table\Nested class which is extended by \Joomla\CMS\Table\Menu. During the installation or update of a component Joomla uses the aforementioned Menu class to manage the items published in the the Components administrator menu.

Therefore it looks like there is a problem with Joomla running on your version of MariaDB (the database server your host uses instead of MySQL).

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!