Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_pay_after, thread.threadid, thread.forumid, thread.postuserid
FROM vbookie_items AS item
LEFT JOIN vbookie_groups AS grp ON grp.group_id = item.group_id
LEFT JOIN thread AS thread ON thread.vbookie_item_id = item.item_id
WHERE item.item_status='OPEN'
ORDER BY item.item_open_until, item.item_pay_after, item.item_id DESC
LIMIT 0, 20;
MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Request Date : Tuesday, February 12th 2013 @ 07:37:00 AM
Error Date : Tuesday, February 12th 2013 @ 07:37:00 AM
Script : http://www.planetcricket.org/forums/vbookie.php
Referrer : http://www.planetcricket.org/forums/vbookie.php
IP Address : xxx.xxx.x.xx
Username : Abhas
Classname : vB_Database
MySQL Version : 5.1.61