[Twilkey]

Originally Posted by peterpigman

getting this error when you bring up stats, I'm guessing it is a server prob and have contacted my host, am I correct?

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         : Sunday, October 28th 2007 @ 03:57:29 AM
Script       : http://forum.uncoverreality.com/casino.php?do=stats
Referrer     : http://forum.uncoverreality.com/casino.php
IP Address   : xxxxxxx
Username     : Peterpigman
Classname    : vB_Database

Contacting your host is what you needed to do.

Originally Posted by HO3R

Same error here with me!
I keep on looking!

Anyway great work

Greetz

Andrew is making an update so that this will not happen. Just keep looking back here for an update.