Notice: Error: Error writing file '/tmp/#sql6b2_20ee8_0.frm' (Errcode: 28) Error No: 3 CREATE TEMPORARY TABLE oc_bf_found_results (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.price, MIN(pd2.price) AS discount, MIN(ps.price) AS special, AVG(rating) AS total, 0 AS fixed_tax, 0 AS percent_tax FROM ( SELECT p.* FROM `oc_product` AS p INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) INNER JOIN `oc_category_path` AS cp ON (cp.category_id = p2c.category_id) WHERE cp.path_id = '57') AS p INNER JOIN `oc_product_to_store` AS p2s ON (p.product_id = p2s.product_id) LEFT JOIN `oc_product_discount` AS 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` AS 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` AS r1 ON (r1.product_id = p.product_id AND r1.status = 1) WHERE p2s.store_id = '0' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id in /var/www/pcshop/data/www/www.pcshop.su/system/library/db/mysqli.php on line 41Notice: Error: Table 'pcshop20.01.oc_bf_found_results' doesn't exist Error No: 1146 SELECT COUNT(*) AS total FROM `oc_bf_found_results` AS p INNER JOIN `oc_product` AS pp ON (p.product_id = pp.product_id) INNER JOIN `oc_product_description` AS pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' ORDER BY pp.sort_order ASC, LCASE(pd.name) ASC in /var/www/pcshop/data/www/www.pcshop.su/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/pcshop/data/www/www.pcshop.su/system/storage/modification/catalog/model/catalog/product.php on line 507Notice: Error: Table 'pcshop20.01.oc_bf_found_results' doesn't exist Error No: 1146 SELECT p.* FROM `oc_bf_found_results` AS p INNER JOIN `oc_product` AS pp ON (p.product_id = pp.product_id) INNER JOIN `oc_product_description` AS pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' ORDER BY pp.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 100 in /var/www/pcshop/data/www/www.pcshop.su/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/pcshop/data/www/www.pcshop.su/system/storage/modification/catalog/model/catalog/product.php on line 200Warning: Invalid argument supplied for foreach() in /var/www/pcshop/data/www/www.pcshop.su/system/storage/modification/catalog/model/catalog/product.php on line 200Warning: fread(): Length parameter must be greater than 0 in /var/www/pcshop/data/www/www.pcshop.su/system/library/cache/file.php on line 32Warning: fread(): Length parameter must be greater than 0 in /var/www/pcshop/data/www/www.pcshop.su/system/library/cache/file.php on line 32
