Posting issues (MariaDB server error)

[DonnieD]

Hi team,

getting this message when users try to post something:

1064 - 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.newPublished' at line 6

Any idea what the issue might be?

Thanks for checking!

Cheers,

Donnie

Sys Info:

Database Type mysql
Database Version 5.5.5-10.1.30-MariaDB-1~xenial
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.2.15
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.9.3 Stable [ Amani ] 12-February-2019 15:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

[Jan]

Hi, can you paste here whole database query?

Jan

[DonnieD]

Hi Jan, not quite sure how to capture that SQL query.

[Jan]

Hi, if you enable debug mode in Joomla! Global configuration, you should get the whole query when rendering the problem part.

Jan

[DonnieD]

Sorry for the late response...

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.newPublished' at line 6
httpd.www/libraries/joomla/database/driver/mysqli.php:665

Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:665
2 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Nested.php:1779
3 Joomla\CMS\Table\Nested->_runQuery() JROOT/libraries/src/Table/Nested.php:1567
4 Joomla\CMS\Table\Nested->recursiveUpdatePublishedColumn() JROOT/libraries/src/Table/Nested.php:880
5 Joomla\CMS\Table\Nested->store() JROOT/components/com_phocaguestbook/models/guestbook.php:114
6 PhocaguestbookModelGuestbook->store() JROOT/components/com_phocaguestbook/controllers/phocaguestbook.php:424
7 PhocaguestbookControllerPhocaguestbook->submit() JROOT/libraries/src/MVC/Controller/BaseController.php:710
8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocaguestbook/phocaguestbook.php:18
9 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
10 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
11 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
12 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
13 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
14 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

[Jan]

What is the Phoca Guestbook version?

Jan

[DonnieD]

Hi Jan,

It was 3.0.8, so just updated to version 3.0.9.

Still had the same issue, but after testing a few things I found out that the table xxx_phocaguestbook_items somehow was corrupted.

The first entry (ROOT) had a lower RGT value than the last post. When I changed the RGT value of the first entry to "last post RGT field +1" the issue was gone.

Sorry to have wasted your time. :-)

Cheers,

Donnie

[Jan]

Ok, thank you for the info.

Jan