Phoca Forum

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

Hi, can you paste here whole database query?

Jan

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

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

Jan

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

What is the Phoca Guestbook version?

Jan

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

Ok, thank you for the info.

Jan