Facebook Twitter Pinterest Share

vBulletin 3.X Add-ons & Template Modifications All the latest vBulletin 3.X Add-ons & Template Modifications.


New Thread  Post Reply
Fanshop's Avatar
Fanshop : Newbie +
Fanshop is on a distinguished road
offline Joined: Dec 2007 Posts: 10 Thanked: 0
  #11  
Unread 02-24-08
database error when i active the user list, only with user list enable:

(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 > 1203879501 AND cchatbox.userid = user.userid AND usergroup.usergroupid = user.usergroupid AND cchatbox.time > 1203881701 - (2*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 > 1203879501 AND user.userid = session.userid AND usergroup.usergroupid = user.usergroupid
            ORDER BY username ASC);;

MySQL Error  : Unknown column 'my_database.session.usergroupid' in 'on clause'
Error Number : 1054
Date         : Sunday, February 24th 2008 @ 01:35:01 PM
Script       : http://myweb.org/2008/cchatbox.php?do=userlist
Referrer     : http://myweb.org/2008/
IP Address   : xxxxxxxx
what can i do i installed v1.31
ravenfaust's Avatar
ravenfaust : Member
ravenfaust is on a distinguished road
offline Joined: Feb 2008 Posts: 42 Thanked: 4
  #12  
Unread 03-04-08
getting this error atabase 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 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 > 1204615083 AND cchatbox.userid = user.userid AND usergroup.usergroupid = user.usergroupid AND cchatbox.time > 1204615983 - (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 > 1204615083 AND user.userid = session.userid AND usergroup.usergroupid = user.usergroupid
ORDER BY username ASC);;

MySQL Error : Unknown column 'zgdziay_Forums.session.usergroupid' in 'on clause'
Error Number : 1054
Date : Tuesday, March 4th 2008 @ 02:32:40 AM
Script : http://gamerzcentral.com/forums/ccha...hp?do=userlist
Referrer : http://gamerzcentral.com/forums/index.php
IP Address : 75.67.176.221
Username : ravenfaust
Classname : vb_database
MySQL Version : 4.1.22-standard
hugos's Avatar
hugos : Newbie +
hugos is on a distinguished road
offline Joined: Oct 2007 Posts: 5 Thanked: 2
  #13  
Unread 03-06-08
Enter Bottun not come back
HawK's Avatar
HawK : Member
HawK will become famous soon enough
offline Joined: Nov 2007 Posts: 25 Thanked: 25
  #14  
Thread Starter Unread 03-13-08
updated cchatbox 1.4, links for download plz?

http://www.vbulletin.org/forum/showthread.php?t=169725

italian and english version tnx!
Spinifex's Avatar
Spinifex : 50+
Spinifex will become famous soon enough
offline Joined: Jan 2008 Location: Use the Thanks Button! Posts: 84 Thanked: 86
  #15  
Unread 03-13-08
you guys really need to read threads properly!

if you get a db error when using user list just set it to only do peeps that shout on the chatbox and its ok.. cheers.. keep us updated with this please

EDIT: Also its not /statistics like it says it is /stats
HawK's Avatar
HawK : Member
HawK will become famous soon enough
offline Joined: Nov 2007 Posts: 25 Thanked: 25
  #16  
Thread Starter Unread 03-13-08
updated version 1.4
Spinifex's Avatar
Spinifex : 50+
Spinifex will become famous soon enough
offline Joined: Jan 2008 Location: Use the Thanks Button! Posts: 84 Thanked: 86
  #17  
Unread 03-13-08
cheers hawk
---------------------

v1.3.1 - (02/18/08)
Add: 5 and 15 minutes for expire time of actions
Fix: Now can see the Toolbar for FORUMDISPLAY and SHOWTHREAD templates

v1.4 - (03/12/08)
Fix: Problem with users list when use the action "/say".
Fix: Query for show users list.
Mod: Modified the principal template "cchatbox".
Add: Hook system.
Add: Javascript engine.
Brainspawn's Avatar
Brainspawn : Super Mod
Brainspawn is a splendid one to beholdBrainspawn is a splendid one to beholdBrainspawn is a splendid one to beholdBrainspawn is a splendid one to beholdBrainspawn is a splendid one to beholdBrainspawn is a splendid one to beholdBrainspawn is a splendid one to beholdBrainspawn is a splendid one to behold
offline Joined: Dec 2007 Location: Sumwhere You Aint Posts: 1,240 Thanked: 6,887
  #18  
Unread 03-14-08
thanks Hawk apprciated! n Spin lol
Gantz's Avatar
Gantz : 50+
Gantz is on a distinguished road
offline Joined: Dec 2007 Location: Canada! Posts: 132 Thanked: 6
  #19  
Unread 04-09-08
I'm getting the following error when I try to upload the plugin. what should I do to resolve this?



A conflict was detected in the bitfields. You cannot continue with the installation of this product until this has been fixed. The conflicts found were:

* Bitfield Collision: credits_cantearn = prefixrequired
jouf's Avatar
jouf : Newbie
jouf is on a distinguished road
offline Joined: Apr 2008 Posts: 1 Thanked: 0
  #20  
Unread 04-11-08
every thing ,,,,,,,,,,,,,
New Thread  Post Reply

Thread Tools

Bookmarks
  • Submit Thread to Facebook
  • Submit Thread to Twitter
  • Submit Thread to Pinterest
  • Submit Thread to LinkedIn
  • Submit Thread to Reddit
Tags
37x, ajaxbased, vbulletin, 3.7.x, chatbox, ajax-based, cchatbox, [new]
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Powered by GYSN Underground 2021