Thread: Chat Modifications - [AJAX] cChatBox
View Single Post
  #57  
Old 02-21-2008, 05:49 AM
christrato's Avatar
christrato christrato is offline
 
Join Date: Aug 2006
Location: Italy
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Geeps View Post
Any idea why this error would be showing up in internet explorer?

error on page

Line: 668
Char: 1
Error: 'null" is null or not an object
Code: 0

Works fine in FireFox
when this error appear?

Quote:
Originally Posted by Geeps View Post
uninstalled the new version. just received emails about database errors:

Database error in vBulletin 3.6.8:

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 cchatbox_message AS cchatbox
LEFT JOIN user AS user USING (userid)
LEFT JOIN session AS session USING (userid)
LEFT JOIN usergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203569331 AND cchatbox.userid = user.userid AND usergroup.usergroupid = user.usergroupid AND cchatbox.time > 1203569931 - (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 session AS session
LEFT JOIN user AS user USING (userid)
LEFT JOIN cchatbox_message AS cchatbox USING (userid)
LEFT JOIN usergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203569331 AND user.userid = session.userid AND usergroup.usergroupid = user.usergroupid
ORDER BY username ASC);;

MySQL Error : Unknown column 'jamesp57_forum.session.usergroupid' in 'on clause'
Error Number : 1054


I'm using a modded default skin, Vb version 3.68

http://4x4sonthe.net
damn... probably is the position of LEFT JOIN... because " LEFT JOIN usergroup AS usergroup USING (usergroupid)" don't found the usergroupid column on the table "session or cchatbox".

i not receive this error and can't try if this solution work or not... i attach the file "functions_cchatbox.php" download it and upload into directory "includes".

wait for your answer...
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01422 seconds
  • Memory Usage 1,771KB
  • 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
  • (2)bbcode_quote
  • (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