[John]

Originally Posted by idwf

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='3660') OR (gamename='chopper' AND score='316') OR (gamename='snake' AND score='53') OR (gamename='spaceinvaders' AND score='3200') OR (gamename='tetris' AND score='383') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

mysql error: Got error 28 from table handler

mysql error number: 1030



found an error! any ideas?

http://www.mysql.com/newsletter/2003...000000249.html

Error 28 isn't anything to do with the coding of the Arcade, rather the server it's running on. (And more specifically, the state of the database)