Posting issues (MariaDB server error)

Phoca Guestbook - creating guestbooks in Joomla! CMS
DonnieD
Phoca Newbie
Phoca Newbie
Posts: 3
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: 40928
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: 3
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: 40928
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: 3
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

Post Reply