PHP Fatal error: 'Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND pd.language_id='2' ORDER BY p.product_id ASC' at line 8
Error No: 1064
SELECT p.product_id,pd.name,pc.product_id, pc.category_id, cd.name
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id=pd.product_id)
LEFT JOIN oc_product_to_category pc ON (p.product_id=pc.product_id)
LEFT JOIN oc_category_description cd ON (cd.category_id=pc.category_id)
WHERE p.status='1' AND
pc.category_id =
AND pd.language_id='2' ORDER BY p.product_id ASC
'
in /home/robertohr/public_html/system/database/mysqli.php:41
Stack trace:
#0 vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('SELECT p.produc...')
#1 catalog/model/module/proizvodi_navigacija.php(12): DB->query('SELECT p.produc...')
#2 catalog/controller/module/proizvodi_navigacija.php(43): ModelModuleproizvodinavigacija->totalproduct(NULL)
#3 vqmod/vqcache/vq2-system_engine_controller.php(75): ControllerModuleproizvodinavigacija->index(Array)
#4 catalog/controller/common/content_top.php(72): Controller->getChild('module/proizvod...', Array)
#5 vqmod/vqcache/vq2-system_engine_controller.php(75): ControllerCommonContentTop->index(Array)
#6 vqmod/vqcache/vq2-system_engine_controller.php(107): Controller->getChild('common/content_...')
#7 vqmod/vqcache/vq2-catalog_controller_product_product.php(495): Controller->render()
#8 [internal function]: ControllerProductProduct->index()
#9 vqmod/vqcache/vq2-system_engine_front.php(42): call_user_func_array(Array, Array)
#10 vqmod/vqcache/vq2-system_engine_front.php(29): Front->execute(Object(Action))
#11 index.php(244): Front->dispatch(Object(Action), Object(Action))
#12 {main}