Notice: Error: Deadlock found when trying to get lock; try restarting transaction
Error No: 1213
CREATE TEMPORARY TABLE ti9jo39em_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.sort_order, if (SUM(if((f.filter_group = "m0" AND filter_id IN (33)), 1, 0)) > 0, 1, 0) AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), p.price))) AS actual_price FROM `ti9jo39em_product` AS p INNER JOIN `ti9jo39em_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `ti9jo39em_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `ti9jo39em_product_to_category` AS p2c ON (p.product_id = p2c.product_id) INNER JOIN `ti9jo39em_category_path` AS cp ON (cp.category_id = p2c.category_id) LEFT JOIN `ti9jo39em_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 `ti9jo39em_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') WHERE p2s.store_id = '0' AND (p.quantity > 0 OR (p.quantity = 0 AND p.restock_in_future = 1)) AND cp.path_id = '337' AND p.manufacturer_id = '33' GROUP BY p.product_id in /home/citycent/public_html/system/library/db/mysqli.php on line 44Notice: Error: Table 'citycent_newsite.ti9jo39em_bf_tmp_product' doesn't exist
Error No: 1146
SELECT COUNT(*) AS total FROM ( SELECT p.* FROM `ti9jo39em_bf_tmp_product` AS p WHERE match_filters = 1) AS t in /home/citycent/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'row' of non-object in /home/citycent/public_html/system/storage/modification/catalog/model/catalog/product.php on line 530Notice: Trying to access array offset on value of type null in /home/citycent/public_html/system/storage/modification/catalog/model/catalog/product.php on line 530Notice: Error: Table 'citycent_newsite.ti9jo39em_bf_tmp_product' doesn't exist
Error No: 1146
SELECT p.*, pp.quantity, pp.stock_status_id, pp.date_added FROM `ti9jo39em_bf_tmp_product` AS p INNER JOIN `ti9jo39em_product_description` AS pd ON (pd.product_id = p.product_id) INNER JOIN `ti9jo39em_product` AS pp ON (pp.product_id = p.product_id) WHERE match_filters = 1 AND pd.language_id = '1' ORDER BY CASE WHEN pp.quantity > 0 THEN 10 WHEN pp.quantity = 0 AND pp.stock_status_id = 8 THEN 9 WHEN pp.quantity = 0 AND pp.stock_status_id = 9 THEN 8 WHEN pp.quantity = 0 AND pp.stock_status_id = 10 THEN 7 WHEN pp.quantity = 0 AND pp.stock_status_id = 5 THEN 5 END DESC, pp.date_added DESC LIMIT 0, 20 in /home/citycent/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/citycent/public_html/system/storage/modification/catalog/model/catalog/product.php on line 84Warning: Invalid argument supplied for foreach() in /home/citycent/public_html/system/storage/modification/catalog/model/catalog/product.php on line 84 Office Solutions | City Center For Computers | Amman Jordan