asky
Пользователь
Здравствуйте, собственно проблема в фильтре, при выборе параметра выдает такую ошибку:
Поможет кто разобраться как можно решить данную проблему и куда копать?
Fatal error: Uncaught exception 'Exception' with message '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 'INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = ' at line 2<br />Error No: 1064<br />SELECT COUNT(DISTINCT `product_id`) AS `total` FROM( INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `oc_category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` SELECT COUNT(*) as total FROM (SELECT p.product_id, p.price, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) in ...\db\mysqli.php on line 47