[K!nG]

Tried To recalculate & got this.

Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT COUNT(c.champ_gid) as countchampionships FROM `games_champs` as c, `games_list` as g
WHERE c.champ_mid = '1' AND g.gid = c.champ_gid
AND c.dateline > 315532800
GROUP BY c.champ_mid;

MySQL Error : Unknown column 'c.dateline' in 'where clause'
Error Number : 1054
Request Date : Sunday, October 30th 2011 @ 12:15:04 AM
Error Date : Sunday, October 30th 2011 @ 12:15:12 AM
Script : http://www.xxxxxxxxxx.com/admincp/xp...min_recount_xp
Referrer : http://www.xxxxxxxxxxx.com/admincp/x...php?do=recount
IP Address : xxx.xxx.xxx.xxx
Username : XYZ
Classname : vB_Database
MySQL Version : 5.0.92-community


Any help will be appreciated. Thanks