PHP Code:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT sum(bet) AS bet, sum(won) AS won, cs1.switch2
FROM casino_settings AS cs1
LEFT JOIN casino_settings AS cs2 ON cs1.switch1 = cs2.switch1
LEFT JOIN casino_bet_stats ON cs1.switch1 = gameid
WHERE cs1.settingname = 'gamename'
AND cs2.settingname = 'gameactive'
AND cs2.switch2 = '1'
GROUP BY gameid;
MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Saturday, November 24th 2007 @ 07:21:18 PM
Script : forums/casino.php?do=stats
Referrer : /forums/casino.php?
IP Address :
Username : Rob
Classname : vB_Database
Get this when clicking more stats