Jump to content
Sign in to follow this  
ANiMAL

SimonFilters и ошибка MYSQL

Recommended Posts

ocStore 1.5.4.1.2
Simon Filters 2.10.0 Build 0002
 
Сначала обнаружил что перестал работать фильтр, после выбора одного из параметров товары исчезают, как будто их нет, хотя они есть. Почистил кеш системы, вкмода - не помогло. Полез в лог файл и там ошибка фильтрации по цене:
2015-05-20 16:06:17 - PHP Notice:  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 '(p.price BETWEEN 2647 AND 14929 OR ps.price BETWEEN 2647 AND 14929 ) AND  GROUP ' at line 3<br />Error No: 1064<br />SELECT p.product_id, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM product p 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) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_special ps ON (p.product_id = ps.product_id)  WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (65, 71, 74, 78, 70, 69, 76, 75, 68, 73, 67, 72, 77)

(p.price BETWEEN 2647 AND 14929 OR ps.price BETWEEN 2647 AND 14929 ) AND  GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC in /www/system/database/mysql.php on line 49

Это по тегу:

2015-05-20 16:52:08 - PHP Notice: 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 '( (pd.tag LIKE 'сапфир,%' or p' at line 3<br />Error No: 1064<br />SELECT p.product_id, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM product p 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) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_special ps ON (p.product_id = ps.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (65, 71, 74, 78, 70, 69, 76, 75, 68, 73, 67, 72, 77) ( (pd.tag LIKE 'сапфир,%' or pd.tag LIKE '%,сапфир,%' or pd.tag LIKE '%,сапфир' or pd.tag = 'сапфир')) AND GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC in /home/silverr/mirsilver.ru/www/system/database/mysql.php on line 49 

Пробовал уже переставить фильтр, также не помогло. Причем есть 2 практически одинаковых магазина, с одинаковыми модулями и этим саймонфильтром. На одном все продолжает работать, а на другом вот такая беда.

На 2х сайтах настройки одинаковы, и не важно по какому признаку фильтрую (цена, опция, тег, категория), все равно ошибка.

Share this post


Link to post
Share on other sites

Почему вопрос этот  задан не автору ?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.