Notice: Error: Error writing file '/tmp/#sql1864_28b78_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, p.weight AS weight, p.viewed AS viewed, p.date_available AS date_available, count(op.product_id) AS sold, (COALESCE(p.price - (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),0)) AS saving FROM ( SELECT p.* FROM `oc_product` AS p INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) WHERE p2c.category_id = '97') 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) LEFT JOIN `oc_order_product` AS op ON (p.product_id = op.product_id) WHERE p2s.store_id = '0' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id in /home/www/neatie.com/system/database/mysql.php on line 50
Fatal error: Call to a member function get() on a non-object in /home/www/neatie.com/index.php on line 105