[ausjeepo]

Hi Andrew,

we where running version .51 and have upgraded to .71 I reverted all the templates uploaded all the files and have upgraded but we are getting random db errors especially when pressing stats which consistantly gives a db error, and texas holdem doesnt show anyone else in so if two people are playing they dont see each other. Any ideas? Thanks for all your work on this mod our members love it.

Database error in vBulletin 3.6.5:

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 : Tuesday, November 27th 2007 @ 04:29:16 AM
Script : http://www.ausjeepoffroad.com/forum/casino.php?
Referrer : http://www.ausjeepoffroad.com/forum/...=72210&page=15
IP Address : 124.169.141.225
Username : Dave
Classname : vb_database



http://www.ausjeepoffroad.com/forum/casino.php