[VBDev]

Originally Posted by kronnos

Cool, thanks. Will this all be updated in the next mod update release? BTW, any plans for the next update with some error fixes?

Yes sure this will be updated.

Well I am currently updating one of my other non-free mod currently and next is the chatbox update.

I think I'll be releasing a new chatbox version in one or two weeks.

Sorry for this delay but you know I am doing vBulletin during my free time so it takes a bit more time than if I was developping during the whole day.

Originally Posted by FF|Skyrider

Sorry VBDev, I "approved" once another moderated thread, and got the database error again:

Yeah, I have added this to the bug list already.

Originally Posted by MAD--DOG

when i try to view any user chat i get this

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..

To fix this, open mgc_cb_evo.php file.

Search for the multiple occurences of :

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

Replace it by :

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