For about the past 3 weeks, my server has been plagued with MySQL errors. The server seemingly crashes more than twice a day and it down for about 8 hours / day average. The technical support team at my webhost (forsite.com) has told me that my website is causing the errors.
Tom, of Forsite.com told me "your site IS the reason that mysql keep crashing on your server -your scripts open a session but do not close themselves causing the server to have troubles - we are asking you to move your site to another host so you can verify this as well with them"
Server Info:
PHP Version 4.0.6
URL: http://www.paintball-forum.com/forum/
Here is the most frequent error message:
Database error in vBulletin :Link-ID == false, connect failedmysql error: Too many connectionsmysql error number: 1040
I have also noted a couple other errors...
Database error in vBulletin 2.2.6:Invalid SQL: SELECT searchid,dateline FROM search WHERE userid=5208 ORDER BY dateline DESC LIMIT 1mysql error: Server shutdown in progressmysql error number: 1053Date: Thursday 02nd of January 2003 10:28:27 AMScript: http://www.paintball-forum.com/forum/forum/search.phpReferer: http://www.paintball-forum.com/forum/search.php?s=
and
Database error in vBulletin Control Panel 2.2.6:Invalid SQL: SELECT * FROM searchmysql error: Server shutdown in progressmysql error number: 1053Date: Thursday 02nd of January 2003 10:28:27 AMScript: http://www.paintball-forum.com/forum/forum/admin/backup.phpReferer: <A href="http://www.paintball-forum.com/forum/admin/backup.php">http://www.paintball-forum.com/forum/admin/backup.php
How can I fix these errors? I have just now diabled the search function, thinking it may be a part of it. Why would the forum connect but not disconnect from the mysql server as forsite.com suggests? I have persistent connections set to 1, but also got the same errors when I tried setting persistent connections to 0.
Tom, of Forsite.com told me "your site IS the reason that mysql keep crashing on your server -your scripts open a session but do not close themselves causing the server to have troubles - we are asking you to move your site to another host so you can verify this as well with them"
Server Info:
PHP Version 4.0.6
URL: http://www.paintball-forum.com/forum/
Here is the most frequent error message:
Database error in vBulletin :Link-ID == false, connect failedmysql error: Too many connectionsmysql error number: 1040
I have also noted a couple other errors...
Database error in vBulletin 2.2.6:Invalid SQL: SELECT searchid,dateline FROM search WHERE userid=5208 ORDER BY dateline DESC LIMIT 1mysql error: Server shutdown in progressmysql error number: 1053Date: Thursday 02nd of January 2003 10:28:27 AMScript: http://www.paintball-forum.com/forum/forum/search.phpReferer: http://www.paintball-forum.com/forum/search.php?s=
and
Database error in vBulletin Control Panel 2.2.6:Invalid SQL: SELECT * FROM searchmysql error: Server shutdown in progressmysql error number: 1053Date: Thursday 02nd of January 2003 10:28:27 AMScript: http://www.paintball-forum.com/forum/forum/admin/backup.phpReferer: <A href="http://www.paintball-forum.com/forum/admin/backup.php">http://www.paintball-forum.com/forum/admin/backup.php
How can I fix these errors? I have just now diabled the search function, thinking it may be a part of it. Why would the forum connect but not disconnect from the mysql server as forsite.com suggests? I have persistent connections set to 1, but also got the same errors when I tried setting persistent connections to 0.
Comment