| VBDev |
01-03-2009 08:25 AM |
Quote:
Originally Posted by adnedarn
(Post 1700084)
In firefox 3.0.5 if the chatbox is minimized I get a sql database error email... I spoke with the guy that the errors were coming from and found if I minimize it I get them for my username as well...
Code:
Database error in vBulletin 3.7.3:
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','ban','del','pm')
AND (touid='0' OR fromuid='5846'
OR touid='5846')
AND iswarning='0'
)
ORDER BY sticky DESC,c.dateline DESC
LIMIT 2
)
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 li
Error Number : 1064
Request Date : Saturday, January 3rd 2009 @ 03:45:59 AM
Error Date : Saturday, January 3rd 2009 @ 03:46:00 AM
Script : http://www.terraforums.com/forums/mgc_cb_evo_ajax.php
Referrer : http://www.terraforums.com/forums/
IP Address :
Username : adnedarn
Classname : vb_database
MySQL Version : 4.0.27-standard
Thanks!
Andrew
PS- I know nothing about coding but did see something in there about mysql and limit 20.. so i will say I do have NEW Separate SQL query for the notifications enabled and 20 set for NEW Number of notifications to display in the chatbox....
|
Quote:
Originally Posted by chooky
(Post 1700085)
I have the mistake, that in my second style (no child style) no message were shown, and all message which I type are away and dont show in the message-box.
|
Oh crap...
To fix this, edit the mgc_cb_evo_ajax.php file.
Search for:
PHP Code:
/* LIMIT clause construction */
if ($status == "closed") {
$limit = $vbulletin->options['mgc_cb_evo_nbchats_closed'];
} else if ($location == "full") {
$limit = $vbulletin->options['mgc_cb_evo_nbchats_full'];
} else {
$limit = $vbulletin->options['mgc_cb_evo_nbchats_normal'];
}
/* Retrieving of the notifications is separated */
if ($vbulletin->options['mgc_cb_evo_separate_chatsnotif_sql'])
{
Replace :
PHP Code:
if ($vbulletin->options['mgc_cb_evo_separate_chatsnotif_sql'])
by :
PHP Code:
if ($vbulletin->options['mgc_cb_evo_separate_chatsnotif_sql'] && $status != "closed")
Quote:
Originally Posted by Stoebi
(Post 1700101)
Hi
Using vBulletin 3.8.0 RC 2, Opera 9.6.2 and IE7. If I collapse the shoutbox, an AJAX error occurs.
Edit:
Get a sql database error email too, with the same content like in adnedarn his post (#3671)
Workaround until final fix. Open file mgc_cb_evo_ajax.php and search for:
PHP Code:
$limit = $vbulletin->options['mgc_cb_evo_nbchats_closed'];
Replace with:
PHP Code:
$limit = 0;
$sql_where_clause_notifs = 0;
Regards, Stoebi
|
That's a bad fix use the one above :)
Quote:
Originally Posted by eurofunny
(Post 1700105)
I copy the 2.0.2 files to my Server and import the Product and then is the Shoutbox visible.
Copy the 2.1.0 files to my Server and import the Product then the Shoutbox is at the arcade not visible but at here mgc_cb_evo.php?do=view_chatbox
|
Yes that I understand but what have you done in your admincp to make the chatbox show in arcade in the previous version ? |
More Information