Hi, I have just installed this 2.3.1 version and it seems to be working great. I really like it, except I have noticed one problem when I go to approve a guest new thread. If I have thread notification off it works fine. I also have it set to a separate column for notifications with the user name and notification on one line. If I have thread notification on (tried both SQL mode on and off) I get the following error:
Database error in vBulletin 3.8.1:
Invalid SQL:
INSERT INTO mgc_cb_evo_chat
(
dateline,fromuid,name,ctext,sticky,chanid,coidenti fier,iswarning,warningtype,tpf orumid,
hascustomavatar,avatarid,avatarrevision,usergroupi d,displaygroupid
)
VALUES
(
1236882406,,'','28558,test3 - please ignore',0,0,0,1,'thread',2,
0,,,
,
);
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 ''','28558,test3 - please ignore',0,0,0,1,'thread',2,
0,,,
' at line 9
Error Number : 1064
Request Date : Thursday, March 12th 2009 @ 01:26:46 PM
Error Date : Thursday, March 12th 2009 @ 01:26:46 PM
Classname : vB_Database
MySQL Version : 5.1.32
Otherwise, if it is a registered user it seems to work fine.
Also, is there a way to only have sound for regular chat and not the notifications? I would also like to change the swf default sound, but am not sure how to make a new swf sound.
Any advice would be appreciated.
Thanks.
|