Notice: Undefined index: product_id in /volume1/web/catalog/controller/product/product.php on line 19 Fatal error: Uncaught exception 'Exception' with message 'Error: 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 'AND main_category = 1 LIMIT 1)' at line 1
Error No: 1064
SELECT * FROM cp_category c INNER JOIN cp_category_description cd ON c.category_id = cd.category_id WHERE cd.language_id = 2 AND c.category_id = (SELECT category_id FROM cp_product_to_category WHERE product_id = AND main_category = 1 LIMIT 1)' in /volume1/web/system/library/db/mysqli.php:40 Stack trace: #0 /volume1/web/system/library/db.php(16): DB\MySQLi->query('SELECT * FROM c...', Array) #1 /volume1/web/catalog/model/catalog/product.php(447): DB->query('SELECT * FROM c...') #2 [internal function]: ModelCatalogProduct->getMainCategory(NULL) #3 /volume1/web/system/engine/loader.php(150): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array) #5 /volume1/web/system/engine/proxy.php(13): call_user_func(Object(Closure), Array) #6 in /volume1/web/system/library/db/mysqli.php on line 40