Thread: Chat Modifications - MGC Chatbox Evo
View Single Post
  #2774  
Old 10-21-2008, 05:41 AM
adnedarn adnedarn is offline
 
Join Date: Jan 2007
Location: Tucson, Arizona
Posts: 192
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Code:
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.13
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
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01170 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete