Posting issues (MariaDB server error)

Phoca Guestbook - creating guestbooks in Joomla! CMS
DonnieD
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 24 Feb 2019, 08:07

Posting issues (MariaDB server error)

Post by DonnieD » 24 Feb 2019, 08:11

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

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41140
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Posting issues (MariaDB server error)

Post by Jan » 25 Feb 2019, 17:08

Hi, can you paste here whole database query?

Jan
If you find Phoca extensions useful, please support the project

DonnieD
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 24 Feb 2019, 08:07

Re: Posting issues (MariaDB server error)

Post by DonnieD » 04 Mar 2019, 12:58

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

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41140
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Posting issues (MariaDB server error)

Post by Jan » 04 Mar 2019, 17:01

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

Jan
If you find Phoca extensions useful, please support the project

DonnieD
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 24 Feb 2019, 08:07

Re: Posting issues (MariaDB server error)

Post by DonnieD » 22 Mar 2019, 13:54

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

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41140
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Posting issues (MariaDB server error)

Post by Jan » 23 Mar 2019, 15:42

What is the Phoca Guestbook version?

Jan
If you find Phoca extensions useful, please support the project

DonnieD
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 24 Feb 2019, 08:07

Re: Posting issues (MariaDB server error)

Post by DonnieD » 24 Mar 2019, 05:37

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

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41140
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Posting issues (MariaDB server error)

Post by Jan » 31 Mar 2019, 22:17

Ok, thank you for the info.

Jan
If you find Phoca extensions useful, please support the project

Post Reply