[evilTone]

Database error in vBulletin 3.0.3:

Invalid SQL: 
		SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
		LEFT JOIN user AS user ON user.userid = gamesessions.userid
		LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
		WHERE (gamename='asteroids' AND score='7210') AND sessiontype=1 ORDER BY gamesessions.gamename DESC
	
mysql error: Column: 'score' in where clause is ambiguous

mysql error number: 1052

any ideas ?
if i clear the table 'gamesessions', then it works for a short time, around 2-3 games then this error comes back.
error also goes away if i 'reset public scores'

i tried the "repair table" option mentioned above also :/