[yabba]

Originally Posted by John

Updated zip, should have fixed all the problems with table prefixes.

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL:
SELECT gamechallenges.*, user.username, user.userid, games.title, user2.username AS username2, user2.userid AS userid2 FROM vb3_gamechallenges
LEFT JOIN vb3_user AS user ON gamechallenges.challengerid = user.userid
LEFT JOIN vb3_user AS user2 ON gamechallenges.challengedid = user2.userid
LEFT JOIN vb3_games AS games ON gamechallenges.game = games.shortname
WHERE (challengedid=1
AND gamechallenges.status=0) OR (challengerid=1
AND gamechallenges.status=2)

mysql error: Unknown table 'gamechallenges'

mysql error number: 1051

Date: Sunday 18th of January 2004 11:04:33 PM

it don't work with tableprefixes
:-(