Maikl911
Житель
- Автор темы
- #1
MegaFilterPRO 2.0.5.2
ocStore 2.3.0.2
Вот такие ошибки вылазят при работе фильтра, при попытке отфильтровать товар - нужно поправить, и рассказать как исправили:
[HIDE]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 `product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`' at line 2<br />Error No: 1064<br />SELECT COUNT(DISTINCT `product_id`) AS `total` FROM( INNER JOIN `product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) `p`.`manufacturer_id` IN(620) AND `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` IN(1351) AND pd.lan in /var/www/users/wizard/domains/DOMEN/system/library/db/mysqli.php on line 40[/HIDE]
ocStore 2.3.0.2
Вот такие ошибки вылазят при работе фильтра, при попытке отфильтровать товар - нужно поправить, и рассказать как исправили:
[HIDE]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 `product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`' at line 2<br />Error No: 1064<br />SELECT COUNT(DISTINCT `product_id`) AS `total` FROM( INNER JOIN `product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) `p`.`manufacturer_id` IN(620) AND `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` IN(1351) AND pd.lan in /var/www/users/wizard/domains/DOMEN/system/library/db/mysqli.php on line 40[/HIDE]
![[sletat.academy] Юридические вопросы при работе с туристами (2024)](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAQAAAC1HAwCAAAAC0lEQVR42mP8Xw8AAoMBgDTD2qgAAAAASUVORK5CYII=)
