I get this mail, can you help me with it?

Database error in vBulletin 3.7.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','me','announcement','pm','slap')
AND (touid='0' OR fromuid='2369'
OR touid='2369')
AND iswarning='0'
)
ORDER BY sticky DESC,c.dateline DESC
LIMIT 15
)
UNION ALL
(
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
ORDER BY sticky DESC,c.dateline DESC
LIMIT 20
);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY sticky DESC,c.dateline DESC
LIMIT 20
)' at line 39

I confirm that.

Same here.

The code I see is:

mgc_cb_evo.php?do=search&what=userchats&u=1

VBDev,

I'm hoping you can help me on this matter but since installing the latest version of your chatbox I've been notice people have been having to following error on while i'm watching the whois online page..

Unknown Location:

/forum/config.txt

can you please confirm this has nothing to do with your application so I can help narrow down what it could be?

Thanks

I would like to have the chat box display on my arcade pages...

Also the chat box displays on my zoints pages, but always says loading. I think this is because the zoints pages are in a "z" subdir.

Can you help please.

VBDev where can i change the sound file extension? Is it possible?

Nevermind i have found it: mgc_cb_evo_functions.js file in clientscript folder. Maybe an option to change the sound file in next version would be a good choice :D

nice work,very impressive/is there a way that user can set their default font n color?thnx

:D Couldn't read so many pages. Hmm, so there is no response for this. Ok. I'll live with this. The Mod is good. So not much to shout about.

Thanks for the input.
Shishir

it just says loading for me then if i type something it gives me an error:

Your submission could not be processed because a security token was missing.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.

I couldn't find the mgc_cb_evo.js file anywhere either. Is that what I needed to change?

EDIT: Tried the security thing. That didn't work

EDIT: AHA! I did waht you suggested: Check that you haven't any non reverted chatbox templates (one that you might have modified) Thanks