Notice: Error: Can't create/write to file '/tmp/#sql_7e75_0.MYI' (Errcode: 28)
Error No: 1
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "jzbkdemauf" AND TABLE_NAME = "oc_journal2_newsletter" AND LCASE(DATA_TYPE) NOT IN ("blob", "text") in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/db/mysqli.php on line 66Notice: Trying to get property of non-object in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/journal2/classes/journal2_db_upgrade.php on line 17Notice: Error: Can't create/write to file '/tmp/#sql_7e75_1.MYI' (Errcode: 28)
Error No: 1
Select Min(r.category_id) category_id, r.name, Min(r.image) image, Min(r.total) total from (SELECT MAX(c.category_id) category_id, MAX(cd.name) name, MAX(c.image) image, COUNT(*) total FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_product_to_category`p2c ON c.category_id = p2c.category_id LEFT JOIN `oc_product` p ON p.product_id = p2c.product_id LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `oc_product_to_store` p2s ON p.product_id = p2s.product_id WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.parent_id = 664 GROUP BY c.category_id HAVING COUNT(*) > 0 ORDER BY LCASE(cd.name) ASC) r Group by LCASE(r.name) Order by LCASE(r.name) ASC in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/db/mysqli.php on line 66Notice: Trying to get property of non-object in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/catalog/model/journal2/super_filter.php on line 233Warning: Invalid argument supplied for foreach() in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/catalog/controller/module/journal2_super_filter.php on line 197Notice: Error: Can't create/write to file '/tmp/#sql_7e75_0.MYI' (Errcode: 28)
Error No: 1
Select *, round(CASE WHEN special IS NOT NULL THEN (case when price > 0 then 100 - (special * 100) / price else 0 end) WHEN discount IS NOT NULL THEN (case when price > 0 then 100 - (discount * 100) / price else 0 end) ELSE 0 END, 2) as sconto, round(CASE WHEN special IS NOT NULL THEN (case when price_listino > 0 then 100 - (special * 100) / price_listino else 0 end) WHEN discount IS NOT NULL THEN (case when price_listino > 0 then 100 - (discount * 100) / price_listino else 0 end) ELSE 0 END, 2) as sconto_listino, (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE price END) as prezzo, (CASE WHEN special IS NOT NULL THEN 1 ELSE 0 END) as is_special, coalesce(rating, 0) as ratings from (SELECT p.product_id, pd.name, p.model, p.quantity, p.price, p.sort_order, p.date_added, p.multipack_quantity, p.numero_vendite, p.price_listino, (SELECT AVG(rating) AS total FROM `oc_review` r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (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) AS discount, (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) AS special, (case when position(' - MULTIPACK' IN pd.name) > 0 then substr(pd.name, 1, position(' - MULTIPACK' IN pd.name) - 1) else pd.name end) as multipack_name, (case when position(' - MULTIPACK' IN pd.name) > 0 then 1 else 0 end) as multipack_sort FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `oc_category_path` cp ON (cp.category_id = p2c.category_id) LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `oc_product_to_store` p2s ON p.product_id = p2s.product_id WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND cp.path_id = '664' GROUP BY p.product_id) tb ORDER BY multipack_sort ASC, sort_order DESC, sort_order DESC, LCASE(multipack_name) ASC, multipack_quantity ASC LIMIT 0,9223372036854775807 in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/db/mysqli.php on line 66Notice: Trying to get property of non-object in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/catalog/model/journal2/super_filter.php on line 557Warning: Invalid argument supplied for foreach() in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/catalog/model/journal2/super_filter.php on line 557Notice: Error: Can't create/write to file '/tmp/#sql_7e75_0.MYI' (Errcode: 28)
Error No: 1
Select *, round(CASE WHEN special IS NOT NULL THEN (case when price > 0 then 100 - (special * 100) / price else 0 end) WHEN discount IS NOT NULL THEN (case when price > 0 then 100 - (discount * 100) / price else 0 end) ELSE 0 END, 2) as sconto, round(CASE WHEN special IS NOT NULL THEN (case when price_listino > 0 then 100 - (special * 100) / price_listino else 0 end) WHEN discount IS NOT NULL THEN (case when price_listino > 0 then 100 - (discount * 100) / price_listino else 0 end) ELSE 0 END, 2) as sconto_listino, (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE price END) as prezzo, (CASE WHEN special IS NOT NULL THEN 1 ELSE 0 END) as is_special, coalesce(rating, 0) as ratings from (SELECT p.product_id, pd.name, p.model, p.quantity, p.price, p.sort_order, p.date_added, p.multipack_quantity, p.numero_vendite, p.price_listino,(SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating,(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) AS discount,(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) AS special,(case when position(' - MULTIPACK' IN pd.name) > 0 then substr(pd.name, 1, position(' - MULTIPACK' IN pd.name) - 1) else pd.name end) as multipack_name,(case when position(' - MULTIPACK' IN pd.name) > 0 then 1 else 0 end) as multipack_sort FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '664' GROUP BY p.product_id) tb ORDER BY multipack_sort ASC, sort_order ASC, LCASE(multipack_name) ASC, multipack_quantity ASC LIMIT 0,32 in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/db/mysqli.php on line 66Notice: Trying to get property of non-object in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 294Warning: Invalid argument supplied for foreach() in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 294Notice: Error: Can't create/write to file '/tmp/#sql_7e75_1.MYI' (Errcode: 28)
Error No: 1
Select Min(r.category_id) category_id, r.name, Min(r.image) image, Min(r.total) total from (SELECT MAX(c.category_id) category_id, MAX(cd.name) name, MAX(c.image) image, COUNT(*) total FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_product_to_category`p2c ON c.category_id = p2c.category_id LEFT JOIN `oc_product` p ON p.product_id = p2c.product_id LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `oc_product_to_store` p2s ON p.product_id = p2s.product_id WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.parent_id = 664 GROUP BY c.category_id HAVING COUNT(*) > 0 ORDER BY LCASE(cd.name) ASC) r Group by LCASE(r.name) Order by LCASE(r.name) ASC in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/db/mysqli.php on line 66Notice: Trying to get property of non-object in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/catalog/model/journal2/super_filter.php on line 233Warning: Invalid argument supplied for foreach() in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/catalog/controller/module/journal2_super_filter.php on line 197Notice: Error: Can't create/write to file '/tmp/#sql_7e75_0.MYI' (Errcode: 28)
Error No: 1
Select *, round(CASE WHEN special IS NOT NULL THEN (case when price > 0 then 100 - (special * 100) / price else 0 end) WHEN discount IS NOT NULL THEN (case when price > 0 then 100 - (discount * 100) / price else 0 end) ELSE 0 END, 2) as sconto, round(CASE WHEN special IS NOT NULL THEN (case when price_listino > 0 then 100 - (special * 100) / price_listino else 0 end) WHEN discount IS NOT NULL THEN (case when price_listino > 0 then 100 - (discount * 100) / price_listino else 0 end) ELSE 0 END, 2) as sconto_listino, (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE price END) as prezzo, (CASE WHEN special IS NOT NULL THEN 1 ELSE 0 END) as is_special, coalesce(rating, 0) as ratings from (SELECT p.product_id, pd.name, p.model, p.quantity, p.price, p.sort_order, p.date_added, p.multipack_quantity, p.numero_vendite, p.price_listino, (SELECT AVG(rating) AS total FROM `oc_review` r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (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) AS discount, (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) AS special, (case when position(' - MULTIPACK' IN pd.name) > 0 then substr(pd.name, 1, position(' - MULTIPACK' IN pd.name) - 1) else pd.name end) as multipack_name, (case when position(' - MULTIPACK' IN pd.name) > 0 then 1 else 0 end) as multipack_sort FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `oc_category_path` cp ON (cp.category_id = p2c.category_id) LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `oc_product_to_store` p2s ON p.product_id = p2s.product_id WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND cp.path_id = '664' GROUP BY p.product_id) tb ORDER BY multipack_sort ASC, sort_order DESC, sort_order DESC, LCASE(multipack_name) ASC, multipack_quantity ASC LIMIT 0,9223372036854775807 in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/db/mysqli.php on line 66Notice: Trying to get property of non-object in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/catalog/model/journal2/super_filter.php on line 557Warning: Invalid argument supplied for foreach() in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/catalog/model/journal2/super_filter.php on line 557Warning: fopen(/home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/cache/cache.language.1558250559): failed to open stream: No space left on device in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 49Warning: flock() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 51Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 53Warning: fflush() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 55Warning: flock() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 57Warning: fclose() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 59Warning: fopen(/home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/cache/cache.language.1558250559): failed to open stream: No space left on device in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 49Warning: flock() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 51Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 53Warning: fflush() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 55Warning: flock() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 57Warning: fclose() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 59Warning: fopen(/home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/cache/cache.currency.1558250559): failed to open stream: No space left on device in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 49Warning: flock() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 51Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 53Warning: fflush() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 55Warning: flock() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 57Warning: fclose() expects parameter 1 to be resource, boolean given in /home/207009.cloudwaysapps.com/jzbkdemauf/public_html/system/library/cache/file.php on line 59 Policarbonato

POLICARBONATO

Prodotti