dodgeboard.com
Fri 2nd May '08, 6:15pm
Okay...
I upgrade the software from 3.7.0 RC 1 to 3.7.0 Gold the other night. I noticed that Hostgator upgraded the SQL and PHP on my server about an hour later, so I am unsure which has caused this new error.
These are my current versions:
vBulletin 3.7.0 Gold
vB Blog 1.0.5
PHP: 5.2.5
MySQL 5.0.45-community
PERL 5.8.8
vBSEO 3.1.0
HOST: Hostgator (Swampcroc pkg)
The error I get is: "SQL Server has gone away"
Sample:
Database error in vBulletin 3.7.0:
Invalid SQL:
(SELECT permissions, permissions2, FIND_IN_SET(forumid, '1,-1') AS pos, forumid
FROM moderator
WHERE userid = 15 AND forumid IN (1,-1)
ORDER BY pos ASC
LIMIT 1)
UNION
(SELECT permissions, permissions2, 0, forumid
FROM moderator
WHERE userid = 15 AND forumid = -1
);
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 2nd 2008 @ 11:21:05 AM
Error Date : Friday, May 2nd 2008 @ 11:21:05 AM
Script : http://www.dodgeboard.com/forums/forumdisplay.php (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000056/!x-usc:http://www.dodgeboard.com/forums/forumdisplay.php)
Referrer : http://www.dodgeboard.com/forums/members/wordsmythe.html (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000056/!x-usc:http://www.dodgeboard.com/forums/members/wordsmythe.html)
IP Address : 165.201.X.X
Username : wordXXXXX
Classname : vB_Database
MySQL Version :
Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.iconid, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.visible!=0 AND thread.forumid NOT IN (0,14,29)
ORDER BY views DESC LIMIT 0, 10;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 2nd 2008 @ 12:35:58 PM
Error Date : Friday, May 2nd 2008 @ 12:35:58 PM
Script : http://www.dodgeboard.com/forums/city-county-politics/6059-county-attorney.html (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000060/!x-usc:http://www.dodgeboard.com/forums/city-county-politics/6059-county-attorney.html)
Referrer : http://www.dodgeboard.com/ (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000060/!x-usc:http://www.dodgeboard.com/)
IP Address : 24.255.X.X
Username : Unregistered
Classname : vB_Database
MySQL Version :
I submitted a ticket to Hostgator support to ask if their upgrade on SQL or PHP could have caused this. Their answer?
I don't see any issues with the sql service at those times. Your query returns almost 70,000 rows. Please refer to the following:
http://www.vbulletin.com/forum/showthread.php?t=43505 (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000032/!x-usc:http://www.vbulletin.com/forum/showthread.php?t=43505)
The timestamps you displayed below make 1 invalid, and we can not increase the limits as suggested in 3. Check with the vbulletin community to see if there may be a patch for this to make sure a close statement is not being issued, or to reduce the result size.
Thank you,
Michael S
Server Administrator
HostGator LLC.
http://support.hostgator.com (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000032/!x-usc:http://support.hostgator.com/)
Didn't do it before the upgrades. Don't know if this new error is as a result of the vBulletin upgrade or the Hosts upgrades.
One user compained today of a new issue:
Every time I try and do a search I get the error
Your submission could not be processed because a security token was missing or mismatched.
If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.
--------------------------------
Referring Page: http://www.vbulletin.com/forum/search.php (http://www.vbulletin.com/forum/search.php?do=process)
I called the user and he gets this message everytime he searches. But I don't get it. I had him search for "weather" while on the phone...and he got the error everytime. I did and and never got the error.
The "Who's Online" not showing everyone that's on either. Seems like it comes and goes- I minute all the spiders fall off and the next minute, they are back.
Also, getting a bunch of these errors:
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/tee17/public_html/forums/includes/class_core.php on line 311
MySQL Error :
Error Number :
Request Date : Friday, May 2nd 2008 @ 04:24:03 PM
Error Date : Friday, May 2nd 2008 @ 04:24:03 PM
Script : http://www.dodgeboard.com/forums/newreply.php?do=newreply&noquote=1&p=43339 (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000096/!x-usc:http://www.dodgeboard.com/forums/newreply.php?do=newreply&noquote=1&p=43339)
Referrer : http://www.dodgeboard.com/forums/newreply.php?do=newreply&noquote=1&p=43339 (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000096/!x-usc:http://www.dodgeboard.com/forums/newreply.php?do=newreply&noquote=1&p=43339)
IP Address : 206.51.229.102
Username :
Classname : vB_Database
MySQL Version :
I've had this domain with this host for three years and have only started having problems since this upgrade.
...worried the 3.7.0 Gold upgrade may have been a mistake...
I upgrade the software from 3.7.0 RC 1 to 3.7.0 Gold the other night. I noticed that Hostgator upgraded the SQL and PHP on my server about an hour later, so I am unsure which has caused this new error.
These are my current versions:
vBulletin 3.7.0 Gold
vB Blog 1.0.5
PHP: 5.2.5
MySQL 5.0.45-community
PERL 5.8.8
vBSEO 3.1.0
HOST: Hostgator (Swampcroc pkg)
The error I get is: "SQL Server has gone away"
Sample:
Database error in vBulletin 3.7.0:
Invalid SQL:
(SELECT permissions, permissions2, FIND_IN_SET(forumid, '1,-1') AS pos, forumid
FROM moderator
WHERE userid = 15 AND forumid IN (1,-1)
ORDER BY pos ASC
LIMIT 1)
UNION
(SELECT permissions, permissions2, 0, forumid
FROM moderator
WHERE userid = 15 AND forumid = -1
);
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 2nd 2008 @ 11:21:05 AM
Error Date : Friday, May 2nd 2008 @ 11:21:05 AM
Script : http://www.dodgeboard.com/forums/forumdisplay.php (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000056/!x-usc:http://www.dodgeboard.com/forums/forumdisplay.php)
Referrer : http://www.dodgeboard.com/forums/members/wordsmythe.html (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000056/!x-usc:http://www.dodgeboard.com/forums/members/wordsmythe.html)
IP Address : 165.201.X.X
Username : wordXXXXX
Classname : vB_Database
MySQL Version :
Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.iconid, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.visible!=0 AND thread.forumid NOT IN (0,14,29)
ORDER BY views DESC LIMIT 0, 10;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 2nd 2008 @ 12:35:58 PM
Error Date : Friday, May 2nd 2008 @ 12:35:58 PM
Script : http://www.dodgeboard.com/forums/city-county-politics/6059-county-attorney.html (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000060/!x-usc:http://www.dodgeboard.com/forums/city-county-politics/6059-county-attorney.html)
Referrer : http://www.dodgeboard.com/ (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000060/!x-usc:http://www.dodgeboard.com/)
IP Address : 24.255.X.X
Username : Unregistered
Classname : vB_Database
MySQL Version :
I submitted a ticket to Hostgator support to ask if their upgrade on SQL or PHP could have caused this. Their answer?
I don't see any issues with the sql service at those times. Your query returns almost 70,000 rows. Please refer to the following:
http://www.vbulletin.com/forum/showthread.php?t=43505 (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000032/!x-usc:http://www.vbulletin.com/forum/showthread.php?t=43505)
The timestamps you displayed below make 1 invalid, and we can not increase the limits as suggested in 3. Check with the vbulletin community to see if there may be a patch for this to make sure a close statement is not being issued, or to reduce the result size.
Thank you,
Michael S
Server Administrator
HostGator LLC.
http://support.hostgator.com (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000032/!x-usc:http://support.hostgator.com/)
Didn't do it before the upgrades. Don't know if this new error is as a result of the vBulletin upgrade or the Hosts upgrades.
One user compained today of a new issue:
Every time I try and do a search I get the error
Your submission could not be processed because a security token was missing or mismatched.
If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.
--------------------------------
Referring Page: http://www.vbulletin.com/forum/search.php (http://www.vbulletin.com/forum/search.php?do=process)
I called the user and he gets this message everytime he searches. But I don't get it. I had him search for "weather" while on the phone...and he got the error everytime. I did and and never got the error.
The "Who's Online" not showing everyone that's on either. Seems like it comes and goes- I minute all the spiders fall off and the next minute, they are back.
Also, getting a bunch of these errors:
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/tee17/public_html/forums/includes/class_core.php on line 311
MySQL Error :
Error Number :
Request Date : Friday, May 2nd 2008 @ 04:24:03 PM
Error Date : Friday, May 2nd 2008 @ 04:24:03 PM
Script : http://www.dodgeboard.com/forums/newreply.php?do=newreply&noquote=1&p=43339 (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000096/!x-usc:http://www.dodgeboard.com/forums/newreply.php?do=newreply&noquote=1&p=43339)
Referrer : http://www.dodgeboard.com/forums/newreply.php?do=newreply&noquote=1&p=43339 (wlmailhtml:{9E661007-52F1-4FD6-B004-4B4632DED43F}mid://00000096/!x-usc:http://www.dodgeboard.com/forums/newreply.php?do=newreply&noquote=1&p=43339)
IP Address : 206.51.229.102
Username :
Classname : vB_Database
MySQL Version :
I've had this domain with this host for three years and have only started having problems since this upgrade.
...worried the 3.7.0 Gold upgrade may have been a mistake...