PDA

View Full Version : SQL Error (Modification?)


Nintendo-Daily
04-14-2010, 09:51 AM
I was wondering if anyone here has ever come across something like this. I get the error sporadically. Sometimes, my forums will function completely normal and other times, I get about 180+ email alerts with errors like:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,mgcugp.mgc_cb_evo_default_color,mgcugp.mgc_cb_evo _chanid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid)
WHERE user.userid = 175;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, April 14th 2010 @ 05:44:41 AM
Error Date : Wednesday, April 14th 2010 @ 05:45:23 AM
Script : http://www.nintendo-daily.com/forums/showthread.php?t=2866

-----------------------------------------------------------------------------------------------

Whenever I do get the error, they all seem to have the "MGC" in there somewhere. I'm not sure if this is related to a certain modification that I have installed but I believe it might be.

Any help would in determining where this problem is stemming from would be greatly appreciated.

Thanks.

Marco van Herwaarden
04-14-2010, 10:08 AM
See the manual on this error: Lost connection to MySQL server during query (http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway)

PS Most likely your chatbox is 1 of the causes for this.

NoKSouLz
04-14-2010, 10:23 AM
Like marco said..

The error seems to be around your MGCChatbox..

I suggest checking into that. Maybe your mqsql database cant handle the amount of connections required.

Do the errors happen when your forum has a lot of members online?