Phoca Forum

Code: Select all

2014 Commands out of sync; you can't run this command now 

Call stack
# 	Function 	Location
1 	() 	JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:525
2 	Joomla\Database\Mysqli\MysqliStatement->fetch() 	JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:760
3 	Joomla\Database\DatabaseDriver->fetchObject() 	JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1378
4 	Joomla\Database\DatabaseDriver->loadObjectList() 	JROOT/administrator/components/com_phocacart/libraries/phocacart/related/related.php:163
5 	PhocacartRelated::getRelatedItemsById() 	JROOT/components/com_phocacart/views/item/view.html.php:131
6 	PhocaCartViewItem->display() 	JROOT/libraries/src/MVC/Controller/BaseController.php:697
7 	Joomla\CMS\MVC\Controller\BaseController->display() 	JROOT/components/com_phocacart/controller.php:53
8 	PhocaCartController->display() 	JROOT/libraries/src/MVC/Controller/BaseController.php:735
9 	Joomla\CMS\MVC\Controller\BaseController->execute() 	JROOT/components/com_phocacart/phocacart.php:16
10 	require_once() 	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:69
11 	Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() 	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
12 	Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() 	JROOT/libraries/src/Component/ComponentHelper.php:389
13 	Joomla\CMS\Component\ComponentHelper::renderComponent() 	JROOT/libraries/src/Application/SiteApplication.php:204
14 	Joomla\CMS\Application\SiteApplication->dispatch() 	JROOT/libraries/src/Application/SiteApplication.php:243
15 	Joomla\CMS\Application\SiteApplication->doExecute() 	JROOT/libraries/src/Application/CMSApplication.php:278
16 	Joomla\CMS\Application\CMSApplication->execute() 	JROOT/includes/app.php:63
17 	require_once() 	JROOT/index.php:32

Code: Select all

Datenbanktyp 	mysql
Datenbankversion 	5.7.38-log
Datenbankzeichensatz 	utf8_general_ci
Datenbankverbindungszeichensatz 	utf8mb4_general_ci
PHP-Version 	7.4.30

Code: Select all

SELECT DISTINCT a.id as id, a.title as title, a.image as image, a.alias as alias, a.description, a.description_long, SUBSTRING_INDEX(GROUP_CONCAT(c.id ORDER BY c.parent_id), ',', 1) as catid, SUBSTRING_INDEX(GROUP_CONCAT(c.title ORDER BY c.parent_id), ',', 1) as cattitle, SUBSTRING_INDEX(GROUP_CONCAT(c.alias ORDER BY c.parent_id), ',', 1) as catalias, GROUP_CONCAT(c.title SEPARATOR " ") AS categories_title FROM jos_phocacart_products AS a LEFT JOIN jos_phocacart_product_related AS t ON a.id = t.product_b LEFT JOIN jos_phocacart_product_categories AS pc ON pc.product_id = a.id LEFT JOIN jos_phocacart_categories AS c ON c.id = pc.category_id WHERE t.product_a = 1 GROUP BY a.id, a.title, a.alias, a.image, a.description, a.description_long;