| SessizDunya |
01-23-2009 11:52 AM |
Quote:
Originally Posted by hornstar1337
(Post 1722068)
Just wondering since it appears there are lots of reported bugs and lots of little fixes here and there. When are you planning on updating and putting up the update here?
you dont need to do anything extra. that is just saying that it will add a little extra load on your server by enabling that option :)
|
I can see that but I got an error when I activate the notification system and the chatbox stays on loading like forever.. :confused:
This is the error:
Quote:
Database error in vBulletin 3.7.0:
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','del','ignore','pm','slap ')
AND (touid='0' OR fromuid='1'
OR touid='1')
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
Error Number : 1064
Request Date : Friday, January 23rd 2009 @ 03:48:53 PM
Error Date : Friday, January 23rd 2009 @ 03:48:53 PM
Script : http://siteaddress/forum/mgc_cb_evo_ajax.php
Referrer : http://siteaddress/forum/
IP Address : ipaddress
Username : REVOLUTION
Classname : vb_database
MySQL Version : 5.0.51a-19-log
|
|
More Information