[VBDev]

Originally Posted by Abu2

One mysql error in the latest version:

Database error in vBulletin 3.7.3:

Invalid SQL:

         SELECT DISTINCT u.username,u.displaygroupid,u.userid,s.userid AS suserid,u.usergroupid
                        (u.options & 512) AS invisible
         FROM mgc_cb_evo_session AS cbs
         LEFT JOIN user AS u ON (cbs.userid=u.userid)
         LEFT JOIN session AS s ON (cbs.userid=s.userid)
         WHERE cbs.dateline>='1224535366' AND cbs.userid!=0;

MySQL Error   : FUNCTION u.usergroupid does not exist
Error Number  : 1305
Request Date  : Tuesday, October 21st 2008 @ 01:07:46 AM
Error Date    : Tuesday, October 21st 2008 @ 01:07:46 AM
Script        : http://***/forum/mgc_cb_evo_ajax.php
Referrer      : http://***/forum/mgc_cb_evo.php?
IP Address    : ***
Username      : Ram
Classname     : vb_database
MySQL Version : 5.0.26-lk-log

Ok indeed there is a bug.

Open mgc_cb_evo_ajax.php and search for :

PHP Code:

$getusers = $vbulletin->db->query_read("
         SELECT DISTINCT u.username,u.displaygroupid,u.userid,s.userid AS suserid,u.usergroupid
                        (u.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible
         FROM " . TABLE_PREFIX . "mgc_cb_evo_session AS cbs
         LEFT JOIN " . TABLE_PREFIX . "user AS u ON (cbs.userid=u.userid)
         LEFT JOIN " . TABLE_PREFIX . "session AS s ON (cbs.userid=s.userid)
         WHERE cbs.dateline>='$dateline' AND cbs.userid!=0      
      "); 


In this query after u.usergroupid, just add a coma.