[peterpigman]

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

Ok I got a reply from my host about this, they replied with this.

We would like to inform you that the error you have received cannot be avoided by modifying SQL_BIG_SELECTS or SQL_MAX_JOIN_SIZE since that has been disabled due to rampant abuse. We would like to advise you that in almost all cases this issue can be resolved by adding an "index" to the columns that are referenced in the SQL statement. We suggest using phpMyAdmin to add an index to the fields referenced in the ON or WHERE clauses of the statement.

How the hell do I do that?