I have same problem.
I did all of the steps.
I've never had a chatbox before on my forum though.
And I still have the problem.
It works fine on default skin, but not on my custom skin.

you can give me the link of your custom skin for download and try?

tnx

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

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

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

when this error appear?

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...

<a href="https://vborg.vbsupport.ru/member.php?u=205225" target="_blank">inteller2k7</a> try to download and overwrite the functions_cchatbox.php that i have attached into my previous post.

Thank you, works great....

The error on page shows up in the lower left corner of the Internet Explorer window. It doesn't seem to effect anything, and it shows only when the chat is turned on. I never noticed it since I use Firefox, but one of the forum members pointed it out last night.

Download the new functions file, in post 56 above, and replace it. I had the same problem and that fixed it.