when i try to view any user chat i get this
Code:
Database error in vBulletin 3.7.5:
Invalid SQL:
SELECT COUNT(chatid) AS nbchats
FROM mgc_cb_evo_chat AS c
LEFT JOIN user AS fromu ON (c.fromuid=fromu.userid)
LEFT JOIN user AS tou ON (c.touid=tou.userid)
WHERE coidentifier IN ('0','me','announcement','ban','del','ignore','pm','slap') AND fromuid='3' AND isthreadwarning='0' AND ispostwarning='0'
ORDER BY c.dateline DESC;
MySQL Error : Unknown column 'isthreadwarning' in 'where clause'
Error Number : 1054
Request Date : Wednesday, February 18th 2009 @ 11:35:04 PM
Error Date : Wednesday, February 18th 2009 @ 11:35:04 PM
Script : http://my site.com/forum/mgc_cb_evo.php?do=search&what=userchats&u=3
Referrer : http://my site.com/forum/forum.php
IP Address : xxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-community
how can i fix this?
thank you..