Notice: Error: Error writing file '/tmp/#sql3fe6_2784c1_0.frm' (Errcode: 28)
Error No: 3
CREATE TEMPORARY TABLE IF NOT EXISTS `oc_af_tax_fixed` (PRIMARY KEY (`tax_class_id`)) AS (SELECT tr1.tax_class_id, sum(tr2.rate) as sum_rate FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr2.type='F' AND tr2cg.customer_group_id = '1' AND ( ( `tr1`.`based` = 'store' AND `z2gz`.`country_id` = 105 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 105 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 105 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) ) GROUP BY tr1.tax_class_id) in /volume1/laparigina.it/system/library/db/mysqli.php on line 41Notice: Error: Error writing file '/tmp/#sql3fe6_2784c1_1.frm' (Errcode: 28)
Error No: 3
CREATE TEMPORARY TABLE IF NOT EXISTS `oc_af_tax_percent` (PRIMARY KEY (`tax_class_id`)) AS (SELECT tr1.tax_class_id, sum(tr2.rate) as sum_rate FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr2.type='P' AND tr2cg.customer_group_id = '1' AND ( ( `tr1`.`based` = 'store' AND `z2gz`.`country_id` = 105 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 105 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 105 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) ) GROUP BY tr1.tax_class_id) in /volume1/laparigina.it/system/library/db/mysqli.php on line 41Notice: Error: Table 'laparigina.oc_af_tax_fixed' doesn't exist
Error No: 1146
CREATE TEMPORARY TABLE IF NOT EXISTS `oc_af_temporary` (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.manufacturer_id, IF(p.quantity > 0, 9, p.stock_status_id) as stock_status_id, MIN(pd2.price) as discount, MIN(ps.price) as special, tax_p.sum_rate as tax_precent, tax_f.sum_rate as tax_fixed, AVG(rating) AS rating FROM oc_product p LEFT JOIN `oc_af_tax_fixed` tax_f ON p.tax_class_id = tax_f.tax_class_id LEFT JOIN `oc_af_tax_percent` tax_p ON p.tax_class_id = tax_p.tax_class_id INNER JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_product_discount pd2 ON (pd2.product_id = p.product_id 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()) AND pd2.customer_group_id = '1') LEFT JOIN oc_product_special ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1') LEFT JOIN oc_review r1 ON (r1.product_id = p.product_id AND r1.status = 1) INNER JOIN oc_product_to_store AS p2s ON p2s.product_id = p.product_id AND p2s.store_id = '0' WHERE p.date_available <= NOW() AND p.status = 1 AND p.quantity > 0 AND p2c.category_id = '206' GROUP BY p.product_id in /volume1/laparigina.it/system/library/db/mysqli.php on line 41Notice: Error: Table 'laparigina.oc_af_temporary' doesn't exist
Error No: 1146
SELECT count(p.product_id) as total FROM (SELECT aft.* , ((IFNULL(aft.special, IFNULL(aft.discount, p2.price)))*(1+IFNULL(aft.tax_precent,0)/100)+IFNULL(aft.tax_fixed, 0)) as af_price FROM `oc_af_temporary` aft INNER JOIN `oc_product` p2 ON aft.product_id = p2.product_id GROUP BY aft.product_id ) aft INNER JOIN `oc_product` p ON aft.product_id = p.product_id AND p.quantity > 0 in /volume1/laparigina.it/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /volume1/laparigina.it/system/storage/modification/catalog/model/catalog/product.php on line 650Notice: Error: Table 'laparigina.oc_af_temporary' doesn't exist
Error No: 1146
SELECT p.product_id, aft.rating, aft.discount, aft.special FROM (SELECT aft.* , ((IFNULL(aft.special, IFNULL(aft.discount, p2.price)))*(1+IFNULL(aft.tax_precent,0)/100)+IFNULL(aft.tax_fixed, 0)) as af_price FROM `oc_af_temporary` aft INNER JOIN `oc_product` p2 ON aft.product_id = p2.product_id GROUP BY aft.product_id ) aft INNER JOIN `oc_product` p ON aft.product_id = p.product_id INNER JOIN `oc_product_description` pd ON pd.product_id = p.product_id LEFT JOIN oc_product_attribute pa ON (p.product_id = pa.product_id)WHERE pd.language_id = '4' AND p.quantity > 0 AND pa.attribute_id = 16 GROUP BY p.product_id ORDER BY FIELD(pa.text ,'AI 2018','AI 2017', 'AI 2016', 'AI 2015', 'AUTUNNO \\ INVERNO','PE 2018', 'PE 2017', 'PE 2016', 'PE 2015', 'PRIMAVERA \\ ESTATE', 'ARTICOLI SCONTO WEB', 'NOSEASON') ASC, LCASE(pd.name) ASC LIMIT 0,1500 in /volume1/laparigina.it/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /volume1/laparigina.it/system/storage/modification/catalog/model/catalog/product.php on line 271Warning: Invalid argument supplied for foreach() in /volume1/laparigina.it/system/storage/modification/catalog/model/catalog/product.php on line 271Notice: Error: Table 'laparigina.oc_af_temporary' doesn't exist
Error No: 1146
SELECT f.filter_id, fd.name as filter_name, aff.image, f.filter_group_id, fgd.name as filter_group_name FROM `oc_filter` f LEFT JOIN `oc_af_filter` aff ON aff.filter_id = f.filter_id AND aff.language_id = '4' INNER JOIN `oc_filter_description` fd ON fd.filter_id = f.filter_id AND fd.language_id = '4' INNER JOIN `oc_filter_group` fg ON fg.filter_group_id = f.filter_group_id INNER JOIN `oc_filter_group_description` fgd ON fgd.filter_group_id = f.filter_group_id AND fgd.language_id = '4' WHERE f.filter_id IN( SELECT pf.filter_id FROM `oc_product_filter` pf INNER JOIN `oc_af_temporary` aft ON aft.product_id = pf.product_id ) GROUP BY f.filter_id ORDER BY fg.sort_order, f.sort_order in /volume1/laparigina.it/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /volume1/laparigina.it/catalog/model/extension/d_ajax_filter/filter.php on line 31 Stringate | La Parigina


Non ci sono articoli da mostrare in questa categoria.