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
Posting issues (MariaDB server error)
- Jan
- Phoca Hero
- Posts: 47912
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Posting issues (MariaDB server error)
Hi, can you paste here whole database query?
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 4
- Joined: 24 Feb 2019, 08:07
Re: Posting issues (MariaDB server error)
Hi Jan, not quite sure how to capture that SQL query.
- Jan
- Phoca Hero
- Posts: 47912
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Posting issues (MariaDB server error)
Hi, if you enable debug mode in Joomla! Global configuration, you should get the whole query when rendering the problem part.
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 4
- Joined: 24 Feb 2019, 08:07
Re: Posting issues (MariaDB server error)
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
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
- Phoca Hero
- Posts: 47912
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Posting issues (MariaDB server error)
What is the Phoca Guestbook version?
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 4
- Joined: 24 Feb 2019, 08:07
Re: Posting issues (MariaDB server error)
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
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
- Phoca Hero
- Posts: 47912
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Posting issues (MariaDB server error)
Ok, thank you for the info.
Jan
Jan
If you find Phoca extensions useful, please support the project