[Andrew Green]

Originally Posted by jay007

im getting a database error after an install, any suggestions/Help greatfully appreciated.
THX

Database error in vBulletin 3.6.8:

Invalid SQL:

							SELECT cs1.switch2 AS gamefile, cs2.switch2 AS gamename, cs3.switch2 AS gamedesc, cs4.switch2 AS active
							FROM casino_settings AS cs1, casino_settings AS cs2, casino_settings AS cs3, casino_settings AS cs4    
							WHERE cs1.switch1=cs2.switch1 
							AND cs1.switch1= cs3.switch1 
							AND cs1.switch1= cs4.switch1 
							AND cs1.settingname='gamefile' 
							AND cs2.settingname='gamename' 
							AND cs3.settingname='gamedesc'
							AND cs4.settingname='gameactive'
							AND cs4.switch2='1';

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

This is a difference in your mysql settings not liking that query, I'll rework it into something simpler with the next update.