Warning: mysqli::query(): (HY000/1206): The total number of locks exceeds the lock table size in /home/glemis/public_html/system/library/db/mysqli.php on line 19
Fatal error: Uncaught exception 'Exception' with message 'Error: The total number of locks exceeds the lock table size<br />Error No: 1206<br />SELECT *, r.product_id, r.date_added, r.order_id, r.review_id, r.status FROM oc_review r LEFT JOIN oc_review_image ri ON (r.review_id = ri.review_id) WHERE r.status = '1' AND r.product_id IN (6140,6097,6098,6095,6075,6085,6076,6087,6077,6078,6139,6144,6151,6114,6080,6082,6099,6172,6170,6120,6156,6138,6133,6135,6130,6145,6189,6143,6150,6104,6109,6100,6492,6124,6119,6183,6137,6132,6155,6141,6134,6129,6146,6149,6142,6105,6110,6101,6173,6175,6493,6123,6118,6159,6127,6162,6163,6131,6154,6128,6188,6190,6148,6115,6234,6106,6111,6102,6494,6122,6117,6158,6126,6184,6161,6136,6153,6164,6147,6107,6112,6103,6174,6176,6186,6116,6157,6187,6125,6160,6235,6108,6113,6079,6083,6084,6086,6081,6088,6094,6089,6090,6091,6092,6093,6096,6152) AND r.language_id = '2' GROUP BY r.review_id ORDER BY r.like DESC, r.rating DESC, (CASE WHEN ri.review_id IS NOT NULL THEN ri.review_id ELSE LENGTH(r.text) END) DESC in /home/glemis/public_html/system/library/db/mysqli.php on line 49