Phoca Forum

On the first page I use the "Phoca Cart Product Scroller Module", which produces after update to beta25 a blank screen.

Twig\Error\RuntimeError thrown with message "An exception has been thrown during the rendering of a template ("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 'AVG(r.rating) AS rating, at.required AS attribute_required FROM _xxx_phoca...' at line 1")."

Stacktrace:
#175 Twig\Error\RuntimeError in /home/users/_xxx_/www/_xxx_/media/gantry5/engines/nucleus/particles/position.html.twig:4
#174 Twig\Template:displayBlock in /home/users/_xxx_/www/_xxx_/cache/gantry5/phoca_nature/twig/21/212663357d2ad43e20200439b41f468f3eb205c97cbd45b2d8b6435954b3293e.php:73
#173 __TwigTemplate_462a5ebf29065ecfb209221052257748aabdefdca5d8e69166fe5d724ba248aa:doDisplay in /home/users/_xxx_/www/_xxx_/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
#172 Twig\Template:displayWithErrorHandling in /home/users/_xxx_/www/_xxx_/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
#171 Twig\Template:display in /home/users/_xxx_/www/_xxx_/cache/gantry5/phoca_nature/twig/f2/f2e774c3ec8512230ec61d216289dbc754534b95db3c60811ca6b0e9edeebc9d.php:35
#170 __TwigTemplate_12093e65234fadc9c44c774644bd4f15d3223d1177f195a053d510cc46803847:doDisplay in /home/users/_xxx_/www/_xxx_/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
...

Hi, are you able to list here full SQL query which is problematic, I am testing now and get no such problem. Or are you able to switch to Cassiopeia (for test only) to get right trace (without cached Gantry files)?

Jan

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 'AVG(r.rating) AS rating, at.required AS attribute_required FROM xxx_phoca...' at line 1

Call Stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1020
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1785
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_phocacart/libraries/phocacart/product/product.php:758
6 PhocacartProduct::getProducts() JROOT/modules/mod_phocacart_product_scroller/mod_phocacart_product_scroller.php:176
7 include() JROOT/libraries/src/Dispatcher/ModuleDispatcher.php:52
8 Joomla\CMS\Dispatcher\ModuleDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/ModuleDispatcher.php:55
9 Joomla\CMS\Dispatcher\ModuleDispatcher->dispatch() JROOT/libraries/src/Helper/ModuleHelper.php:291
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/libraries/src/Helper/ModuleHelper.php:162
11 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:99
12 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:681
13 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/cassiopeia/index.php:227
14 require() JROOT/libraries/src/Document/HtmlDocument.php:731
15 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:785
16 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:622
17 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1057
18 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:732
19 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:311
20 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:58
21 require_once() JROOT/index.php:32

ERROR 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 'AVG(r.rating) AS rating, at.required AS attribute_required FROM xxx_phoca...' at line 1 :
SELECT a.id,a.image,a.video,a.sku,a.ean,a.stockstatus_a_id,a.stockstatus_n_id,a.min_quantity,a.min_multiple_quantity,a.stock,a.unit_amount,a.unit_unit,a.price,a.price_original,a.date,a.date_update,a.sales,a.featured,a.external_id,a.condition,a.points_received,a.points_needed,a.delivery_date,a.type,a.type_feed,a.type_category_feed,a.params_feed,a.gift_types,a.alias,a.title,a.title_long,a.description,a.description_long,a.features,a.metatitle,a.metadesc,a.metakey, c.id AS catid, c.title AS cattitle, c.alias AS catalias, c.title_feed AS cattitlefeed, c.type_feed AS cattypefeed, c.params_feed AS params_feed_category, MIN(ppg.price) as group_price, MAX(pptg.points_received) as group_points_received, t.id as taxid

Hi, do you get the same problem with Beta 28:

https://github.com/PhocaCz/PhocaCart/re ... Beta28.zip

(BTW if you update between Beta version, there is no update or alter of database tables, so this needs to be done manually in case, some table or new column is missing, the list of newly added tables or columns can be found here: administrator/components/com_phocacart/update/sql/mysql/5.0.0.sql )

Jan

Today Update to Beta29. No Error - it works!

Great to hear it.

Jan