[entertain]

Originally Posted by hornstar1337

when im in the archive and i click on view all chats of a specific user I get a database error:

Database error in vBulletin 3.8.1:

Invalid SQL:

        SELECT COUNT(chatid) AS nbchats
        FROM vb3_mgc_cb_evo_chat AS c
        LEFT JOIN vb3_user AS fromu ON (c.fromuid=fromu.userid)
        LEFT JOIN vb3_user AS tou ON (c.touid=tou.userid)
        WHERE coidentifier IN ('0','me','announcement','ban','del','ignore','slap') AND fromuid='1' 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 11th 2009 @ 07:11:51 AM
Error Date    : Wednesday, February 11th 2009 @ 07:11:52 AM
Script        : http://www..net/forums/mgc_cb_evo.php?do=search&what=userchats&u=1
Referrer      : http://www..net/forums/chatbox/archive/page-1.html
IP Address    : 2
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community

Current Fix:
mgc_cb_evo.php

Search for:

PHP Code:

$where_clause .= " AND isthreadwarning='0' AND ispostwarning='0'"; 


You can find this 2 times in the php file (!)
Replace both times by:

PHP Code:

$where_clause .= " AND iswarning='0'";