[corazorback]

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT *
			FROM tmnt_members JOIN tmnt_teams on tmnt_members.teamid = tmnt_teams.teamid WHERE tmnt_members.leader=1 AND tmnt_members.userid=3 AND tmnt_teams.noplayers >= 999 AND tmnt_teams.noplayerstmnt_teams.noplayers <= 1;

MySQL Error   : Unknown column 'tmnt_teams.noplayerstmnt_teams.noplayers' in 'where clause'
Error Number  : 1054
Request Date  : Sunday, October 12th 2008 @ 09:44:16 PM
Error Date    : Sunday, October 12th 2008 @ 09:44:16 PM
Script        : http://www.mysite.net/tournament.php?do=join&id=1
Referrer      : http://www.mysite.net/tournament.php?do=view&id=1
IP Address    : XXXXXXXXXXXXXXXXX
Username      : THEHATED
Classname     : vB_Database
MySQL Version : 5.0.45-community-log

What do I do now??? It won;t let me join in created tournaments.