[CampusCrawler]

Originally Posted by CampusCrawler

Heya, I am having this error emailed to me. But everything seems to work fine on the front end.

Invalid SQL:
SELECT user.userid AS userid, gamesessions.score AS score, games.shortname AS shortname FROM vb3_gamesessions
LEFT JOIN vb3_user AS user ON user.userid = gamesessions.userid
LEFT JOIN vb3_games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='breakout' AND score='9750') OR (gamename='chopper' AND score='444') OR (gamename='simon' AND score='8') OR (gamename='snake' AND score='160') OR (gamename='spaceinvaders' AND score='6830') OR (gamename='target' AND score='390') OR (gamename='tetris' AND score='2055') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

mysql error: Unknown table 'gamesessions' in field list

mysql error number: 1109


Any Ideas



-ADistantBox

I dont think there is an error similar on this thread. Everything seems to work fine though. This error is verry confusing.

ADistantBox