Перейти до вмісту
Пошук в
  • Детальніше...
Шукати результати, які ...
Шукати результати в ...

filter Pro [Поддержка]


freelancer

Recommended Posts

  • 2 months later...

Опишу свою проблему здесь, может кроме разработчика кто поможет.

 

ocStore-1.5.5.1.2. Установлен модуль "FilterPro v2.4.4 (seo)". 

Модуль работает отлично, но заметил одну проблему в фильтрации атрибутов.

Например, страница категории стальных радиаторов: https://teplopl.com.ua/otoplenie/radiatory/stalnye-radiatory

Фильтр зависает, если одновременно выбрать три атрибута. Например: 1. Панельный (22) (102)   2. Нижний / боковой (95)  3. Высота, мм

 

264012082__.thumb.jpg.b062e114d4a4ca697201fd85ae1ae017.jpg

 

Настройки фильтра:

 

1830946347_1.thumb.jpg.b469298c5b1a7b7423ae3e2bef14a1f3.jpg

147880023_2.thumb.jpg.a9fa27a179297da43b71211f64956636.jpg

1832715638_3.jpg.493ff0c514402113c6018cee7d77b0e1.jpg

 

Может кто знает, как справиться с данной проблемой?

Надіслати
Поділитися на інших сайтах


Лог ошибок:

 

Спойлер

2020-02-12 12:58:23 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 12:59:48 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:00:02 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (22)' OR p2a0.text like 'Панельний (22):%' OR p2a0.text like '%:Панельний (22)' OR p2a0.text like '%:Панельний (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижнє / бокове' OR p2a1.text like 'Нижнє / бокове:%' OR p2a1.text like '%:Нижнє / бокове' OR p2a1.text like '%:Нижнє / бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:00:37 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (22)' OR p2a0.text like 'Панельний (22):%' OR p2a0.text like '%:Панельний (22)' OR p2a0.text like '%:Панельний (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижнє / бокове' OR p2a1.text like 'Нижнє / бокове:%' OR p2a1.text like '%:Нижнє / бокове' OR p2a1.text like '%:Нижнє / бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:02:07 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (33)' OR p2a0.text like 'Панельний (33):%' OR p2a0.text like '%:Панельний (33)' OR p2a0.text like '%:Панельний (33):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижнє / бокове' OR p2a1.text like 'Нижнє / бокове:%' OR p2a1.text like '%:Нижнє / бокове' OR p2a1.text like '%:Нижнє / бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:03:17 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (22)' OR p2a0.text like 'Панельний (22):%' OR p2a0.text like '%:Панельний (22)' OR p2a0.text like '%:Панельний (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Бокове' OR p2a1.text like 'Бокове:%' OR p2a1.text like '%:Бокове' OR p2a1.text like '%:Бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '400' OR p2a2.text like '400:%' OR p2a2.text like '%:400' OR p2a2.text like '%:400:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:04:36 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (22)' OR p2a0.text like 'Панельний (22):%' OR p2a0.text like '%:Панельний (22)' OR p2a0.text like '%:Панельний (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Бокове' OR p2a1.text like 'Бокове:%' OR p2a1.text like '%:Бокове' OR p2a1.text like '%:Бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 300))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:06:42 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 400))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:25:04 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 500))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:25:18 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 500))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 13:50:38 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 300))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 17:40:01 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 900))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 17:40:28 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 300 AND 500))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 17:43:07 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT CONCAT(`name`, ' (', count(*), ')') as 'name', `category_id` FROM (SELECT DISTINCT p.product_id, cd.name, cd.category_id, c.sort_order, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN `oc_category` c ON(p2c.category_id=c.category_id)  LEFT JOIN oc_category_description cd ON(cd.category_id=c.category_id)  LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 81 AND (p2a0.text = 'Водяной' OR p2a0.text like 'Водяной:%' OR p2a0.text like '%:Водяной' OR p2a0.text like '%:Водяной:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 121 AND (p2a1.text = '5' OR p2a1.text like '5:%' OR p2a1.text like '%:5' OR p2a1.text like '%:5:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id = p2a.product_id AND p2a0.attribute_id = 27 AND (p2a0.text * 1 BETWEEN 70 AND 810))  AND p.price >=1066 AND c.status=1 AND c.parent_id = '201' AND cd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=1066 AND realprice <=13787 GROUP BY category_id ORDER BY sort_order, name in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:14:58 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=2197 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:15:30 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (11)' OR p2a0.text like 'Панельный (11):%' OR p2a0.text like '%:Панельный (11)' OR p2a0.text like '%:Панельный (11):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=4442 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:16:29 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельний (33)' OR p2a0.text like 'Панельний (33):%' OR p2a0.text like '%:Панельний (33)' OR p2a0.text like '%:Панельний (33):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижнє / бокове' OR p2a1.text like 'Нижнє / бокове:%' OR p2a1.text like '%:Нижнє / бокове' OR p2a1.text like '%:Нижнє / бокове:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '500' OR p2a2.text like '500:%' OR p2a2.text like '%:500' OR p2a2.text like '%:500:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:18:19 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (11)' OR p2a0.text like 'Панельный (11):%' OR p2a0.text like '%:Панельный (11)' OR p2a0.text like '%:Панельный (11):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=2237 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:24:00 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '900' OR p2a2.text like '900:%' OR p2a2.text like '%:900' OR p2a2.text like '%:900:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:35:27 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (11)' OR p2a0.text like 'Панельный (11):%' OR p2a0.text like '%:Панельный (11)' OR p2a0.text like '%:Панельный (11):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Боковой' OR p2a1.text like 'Боковой:%' OR p2a1.text like '%:Боковой' OR p2a1.text like '%:Боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
2020-02-12 20:36:12 - PHP Notice:  Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT count(*) as total, manufacturer_id FROM (SELECT DISTINCT p.product_id, m.manufacturer_id, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (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), p.price) as realprice  FROM oc_product p LEFT JOIN oc_manufacturer m ON(m.manufacturer_id=p.manufacturer_id)  LEFT JOIN oc_product_option_value pov ON (pov.product_id=p.product_id) LEFT JOIN oc_product_to_store p2s ON (p2s.product_id=p.product_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id=p.product_id) LEFT JOIN oc_product_attribute p2a ON (p2a.product_id=p.product_id) WHERE 1 AND p2c.category_id IN (222) AND EXISTS (select 1 FROM oc_product_attribute p2a0 WHERE p2a0.product_id=p2a.product_id AND p2a0.attribute_id = 62 AND (p2a0.text = 'Панельный (22)' OR p2a0.text like 'Панельный (22):%' OR p2a0.text like '%:Панельный (22)' OR p2a0.text like '%:Панельный (22):%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a1 WHERE p2a1.product_id=p2a.product_id AND p2a1.attribute_id = 63 AND (p2a1.text = 'Нижний / боковой' OR p2a1.text like 'Нижний / боковой:%' OR p2a1.text like '%:Нижний / боковой' OR p2a1.text like '%:Нижний / боковой:%'))  AND EXISTS (select 1 FROM oc_product_attribute p2a2 WHERE p2a2.product_id=p2a.product_id AND p2a2.attribute_id = 27 AND (p2a2.text = '300' OR p2a2.text like '300:%' OR p2a2.text like '%:300' OR p2a2.text like '%:300:%'))  AND p.price >=814 AND p.status = '1' AND p.date_available <= NOW( ) AND p2s.store_id = 0) as innertable WHERE 1  AND realprice >=814 AND realprice <=9471 GROUP BY manufacturer_id in /home/teploplc/public_html/system/database/mysql.php on line 50
 

 

Лог ошибок.txt

Змінено користувачем Zapuzin
Надіслати
Поділитися на інших сайтах


  • 2 weeks later...

Проблема уже не актуальна.

Сайт переходит с ocStore 1.5.5.1.2 на ocStore 2.3.0.2.3.

Куплен другой фильтр с нормальной тех. поддержкой.

Змінено користувачем Zapuzin
Надіслати
Поділитися на інших сайтах


Купил модуль.

Установил на OpenCart 1.5.5.1

При попытке зайти в настройки ошибка: 

"Fatal error: Call to undefined method ModelModuleFilterpro::getLicense() "

Помогите, пожалуйста, решить проблему.

Надіслати
Поділитися на інших сайтах


  • 1 month later...

Добрый день, очень нужна помощь. Покупала у вас  фильтр  для сайта pech-center.ru.  

все нормально но не хватает сортировки по значениям,

 

можно ли атрибуты отбирать из базы по нарастающей, от меньшего к большему значению?

спасибо

Снимок.PNG

Надіслати
Поділитися на інших сайтах


В 24.02.2020 в 16:42, Zapuzin сказал:

Проблема уже не актуальна.

Сайт переходит с ocStore 1.5.5.1.2 на ocStore 2.3.0.2.3.

Куплен другой фильтр с нормальной тех. поддержкой.

Скажите пожалуйста, что выбрали  в итоге. Не могу достучаться до этого "мастера" ...

Надіслати
Поділитися на інших сайтах


42 минуты назад, pustota666 сказал:

Скажите пожалуйста, что выбрали  в итоге. Не могу достучаться до этого "мастера" ...

OCFilter - Модуль фильтра товаров

Тех. поддержка отличная. Иногда нужно немного подождать, так как обращений к автору может быть много.

Уже трудится на обновлённом сайте teplopl.com.ua. Проблема, которая была с "FilterPro v2.4.4 (seo)", и не решалась, в этом фильтре отсутствует.

Заменой доволен на все 100%

 

Змінено користувачем Zapuzin
  • +1 1
Надіслати
Поділитися на інших сайтах


  • 4 weeks later...
  • 4 weeks later...

Купил модуль, установил, но он не работает. Писал разработчику в лс ещё 21 мая, но сообщение до сих пор не прочитано... (( Хотелось бы получить какую-то реакцию. 

Надіслати
Поділитися на інших сайтах


  • 1 month later...

Фильтр сдох!!!!

 

Когда нажимаю "Настройки модуля" он долга грузит грузит  и не открывается.

 

а когда удаляю модуль и тыкаю установить от тоже долго грузит и после погрузки выскакивает кнопка активировать вручную нажимаю кнопку и он перекидывает меня на сайт http://orcart.ru/license/ который сдох 

я смотрел копию страницу в яндексе этот сайт еще работал 30 June 2020 
 

Автор тупа всех к и н у л у кого была лицензия.



 

Змінено користувачем pav12398
Надіслати
Поділитися на інших сайтах


16 часов назад, freelancer сказал:

@pav12398 скачайте фильтр на форуме

 

Это что получается опять платить деньги чтобы скачать? 

Надіслати
Поділитися на інших сайтах


В 17.07.2020 в 16:05, freelancer сказал:

@pav12398 зачем еще раз... вы же покупали фильтр. просто скачайте новую версию

 

покупал не я, у этого фильтра была лицензия на домен zscom.ru а теперь она не работает . версии opencart 1.5 FilterPro v2.5.17.6_beta (speed)

Змінено користувачем pav12398
Надіслати
Поділитися на інших сайтах


  • 2 weeks later...
В 13.06.2020 в 15:40, Nubilus сказал:

Купил модуль, установил, но он не работает. Писал разработчику в лс ещё 21 мая, но сообщение до сих пор не прочитано... (( Хотелось бы получить какую-то реакцию. 

Разработчик, ответьте на моё сообщение.

Надіслати
Поділитися на інших сайтах


В 21.07.2020 в 18:35, freelancer сказал:

@pav12398 напишите в личку, я вам скину файл

Вы в лс ответите или нет?

Надіслати
Поділитися на інших сайтах


  • 2 weeks later...
В 21.07.2020 в 18:35, freelancer сказал:

@pav12398 напишите в личку, я вам скину файл

 

Вы ответите в лс или нет?

Надіслати
Поділитися на інших сайтах


  • 3 weeks later...
  • 2 weeks later...
  • 3 weeks later...

Добрый день, при переходе в модуль появляется сообщение

Неверная лицензия! Ваш домен не активирован. Обратитесь к разработчику

Домен https://mob.com.ua/

Куда обращаться?

Надіслати
Поділитися на інших сайтах


  • 1 month later...

я убрал лицензии и куб из фильтра и других своих модулей, домен orcart.ru мне не принадлежит

на форуме сейчас все мои дополнения работают без лицензий

Надіслати
Поділитися на інших сайтах

32 минуты назад, freelancer сказал:

я убрал лицензии и куб из фильтра и других своих модулей, домен orcart.ru мне не принадлежит

на форуме сейчас все мои дополнения работают без лицензий

@freelancer обратились бы сразу в поддержку с описанием проблемы мы бы оперативно разослали всем клиентам соообщение о необхомости срочного обновления с ссылками на скачивание версий. А так получается часть клиентов может даже не догадыватся о том что у Вас утрачен доступ к домену лицензий. Это плохая ситуация это можно решать более оперативно при своевременном обращении к нам в техническую поддержку. Мы готовим рассылку для оповещения покупателей, о необходимости оперативного обновления в связи с проблемами с лицензированием. Это еще раз показывает что лицензирование с запросом на сервер не такое уж безопасное и может остановить даже продажи клиентов в предверьи таких дней как черная пятница....

  • +1 2
Надіслати
Поділитися на інших сайтах


Створіть аккаунт або увійдіть для коментування

Ви повинні бути користувачем, щоб залишити коментар

Створити обліковий запис

Зареєструйтеся для отримання облікового запису. Це просто!

Зареєструвати аккаунт

Вхід

Уже зареєстровані? Увійдіть тут.

Вхід зараз
×
×
  • Створити...

Important Information

На нашому сайті використовуються файли cookie і відбувається обробка деяких персональних даних користувачів, щоб поліпшити користувальницький інтерфейс. Щоб дізнатися для чого і які персональні дані ми обробляємо перейдіть за посиланням . Якщо Ви натиснете «Я даю згоду», це означає, що Ви розумієте і приймаєте всі умови, зазначені в цьому Повідомленні про конфіденційність.