Fatal error: Uncaught Exception: Error: Deadlock found when trying to get lock; try restarting transaction<br />Error No: 1213<br />CREATE TEMPORARY TABLE tf_temp_common_product SELECT p.product_id, p.manufacturer_id, p.price, (SELECT price FROM oc9u_product_discount WHERE product_id = p.product_id AND customer_group_id = '1' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1) AS discount, (SELECT price FROM oc9u_product_special WHERE product_id = p.product_id AND customer_group_id = '1' AND ((date_start = '0000-00-00 00:00:00' OR date_start < NOW()) AND (date_end = '0000-00-00 00:00:00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1) AS special FROM oc9u_category_path cp LEFT JOIN oc9u_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc9u_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc9u_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc9u_pr in /home/biggerbg/public_html/shop.4fitness.bg/system/library/db/mysqli.php on line 40