Hey guys, its me again.
This seems to be happening more and more often as of late and its becoming quite frustrating. Last week I received a ton of database error emails and got with my host about it. They said everything looked fine on their end. A day or two after submitting my trouble ticket to the host, the problem went away and everything returned to normal. I don't believe the host did anything to fix the issue because I received an email from one of the database admins where he asked me a few questions. I didn't respond to the email because I wanted to see if the problem fixed itself, and it seems to have done just that. I really don't think the host has anything to do with the issue. Here's why...
The location of my forums is:
http://www.nintendo-daily.com/forums
The location of my website is:
http://www.nintendo-daily.com
My forums and website use two completely different databases. I can navigate anywhere within my website without going to /forums and everything works perfect.
Whenever I start to receive all the database error emails, I get strange things like this:
Code:
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity, session.badlocation,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1279296520
ORDER BY username ASC;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 16th 2010 @ 11:38:40 AM
Error Date : Friday, July 16th 2010 @ 11:39:22 AM
Script : http://www.nintendo-daily.com/forums/
Referrer : http://www.nintendo-daily.com/forums/
IP Address : 122.228.203.155
Code:
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 = 1;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 16th 2010 @ 11:35:21 AM
Error Date : Friday, July 16th 2010 @ 11:36:04 AM
Script : http://www.nintendo-daily.com/forums/showthread.php?t=574
Code:
Invalid SQL:
SELECT cron.*
FROM cron AS cron
LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1279293989 AND cron.active = 1
AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun
LIMIT 1;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 16th 2010 @ 10:26:29 AM
Error Date : Friday, July 16th 2010 @ 10:27:11 AM
Script : http://www.nintendo-daily.com/forums/cron.php?rand=1279293945
Referrer : http://www.nintendo-daily.com/forums/showthread.php?t=3096
IP Address : 74.234.84.227
Code:
Invalid SQL:
SELECT userid, username, email
FROM user
WHERE email = 'suiyrg@mail.ru';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 16th 2010 @ 09:50:45 AM
Error Date : Friday, July 16th 2010 @ 09:51:28 AM
Script : http://www.nintendo-daily.com/forums/register.php?do=addmember
Referrer : http://www.nintendo-daily.com/forums/register.php?
IP Address : 212.95.54.24
Username : Defshiste
I'm at the point now where I need some better direction because I really don't believe its a hosting issue. If anyone wants to help out with this I would really appreciate it.
More Information