Thread: Chat Modifications - [AJAX] cChatBox
View Single Post
  #56  
Old 02-21-2008, 05:31 AM
inteller2k7's Avatar
inteller2k7 inteller2k7 is offline
 
Join Date: Jun 2007
Location: NYC
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm getting this, and the forum colors changing to red, any ideas?



Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:

(SELECT DISTINCT user.username AS username,user.userid AS userid,user.pmtotal,usergroup.pmquota,user.options AS options,cchatbox.username AS cchatusername
FROM hackercchatbox_message AS cchatbox
LEFT JOIN hackeruser AS user USING (userid)
LEFT JOIN hackersession AS session USING (userid)
LEFT JOIN hackerusergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203577110 AND cchatbox.userid = user.userid AND usergroup.usergroupid = user.usergroupid AND cchatbox.time > 1203578910 - (1*3600)
ORDER BY cchatusername ASC)
UNION DISTINCT
(SELECT DISTINCT user.username AS username,user.userid AS userid,user.pmtotal,usergroup.pmquota,user.options AS options,cchatbox.username AS cchatusername
FROM hackersession AS session
LEFT JOIN hackeruser AS user USING (userid)
LEFT JOIN hackercchatbox_message AS cchatbox USING (userid)
LEFT JOIN hackerusergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203577110 AND user.userid = session.userid AND usergroup.usergroupid = user.usergroupid
ORDER BY username ASC);;

MySQL Error : Unknown column 'aioforum_hacker.session.usergroupid' in 'on clause'
Error Number : 1054
Date : Thursday, February 21st 2008 @ 02:28:30 AM
Script : http://aioforums.com/cchatbox.php?do=userlist
Referrer : http://aioforums.com/aioforums.php?styleid=19
Classname : vB_Database
MySQL Version : 4.1.22-standard
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01381 seconds
  • Memory Usage 1,766KB
  • 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)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