[VBDev]

Originally Posted by adnedarn

I am getting loading... and this error by email:

Database error in vBulletin 3.6.4:

Invalid SQL:

             SELECT c.*,fromu.userid AS fromuserid,fromu.username AS fromusername,fromu.usergroupid AS fromusergroupid,fromu.displaygroupid AS fromdisplaygroupid,
             tou.userid AS touserid,tou.username AS tousername,tou.usergroupid AS tousergroupid,tou.displaygroupid AS todisplaygroupid,
             avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb,fromu.avatarid,fromu.avatarrevision
             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)
             LEFT JOIN avatar AS avatar ON (avatar.avatarid = fromu.avatarid)
             LEFT JOIN customavatar AS customavatar ON (customavatar.userid = fromu.userid)
             WHERE chanid='0' AND coidentifier IN ('0') AND (touid='0' OR fromuid='5846'OR touid='5846')
             ORDER BY sticky DESC,c.dateline DESC
             LIMIT 15;

MySQL Error  : Unknown column 'customavatar.height_thumb' in 'field list'
Error Number : 1054
Date         : Tuesday, October 21st 2008 @ 02:31:11 AM
Script       : http://www.terraforums.com/forums/mgc_cb_evo_ajax.php
Referrer     : http://www.terraforums.com/forums/index.php
IP Address   : 69.137.186.99
Username     : adnedarn
Classname    : vb_database

I've gone back through the whole install and can't find anything I've missed. I have put var SECURITYTOKEN = "0"; in the top of mgc_cb)evo.js since I have an older version...
Thanks!
Andrew

Oh ! Can you go in your database and tell me if in the customavatar table you have an "height_tumb" field ?