[adnedarn]

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...

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....