View Full Version : Is this a highjack attempt?
Nintendo-Daily
04-20-2010, 11:17 PM
I received a database error email a little bit ago. Would someone mind enlightening me as to what this means. Is this malicious and would someone be able to add themselves without registering some how?
-----------------------------------
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT userid, username, email
FROM user
WHERE email = 'razorxr1@googlemails.net';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, April 20th 2010 @ 07:02:39 PM
Error Date : Tuesday, April 20th 2010 @ 07:03:21 PM
Script : http://www.nintendo-daily.com/forums/register.php?do=addmember
Referrer : http://www.nintendo-daily.com/forums/register.php?
IP Address : 204.45.58.186
Username : neodssobamors
- Hide quoted text -
Classname : vB_Database
MySQL Version :
-----------------------------------
ForumsMods
04-20-2010, 11:40 PM
This is a server issue.
See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway (http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway) and this: http://www.vbulletin.com/forum/showt...265#post310265 (http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265)
Nintendo-Daily
04-20-2010, 11:46 PM
Hmm...I'll get with my host I suppose. Thanks for being so prompt.
Would you mind doing me a huge favor?
Would you mind trying to register to see if it works? I haven't received any new members in quite some time.
Something is just strange about this to me.
Thanks for your promptness, vB Style.
ForumsMods
04-21-2010, 12:22 AM
I registered fine.
Nintendo-Daily
04-21-2010, 12:34 AM
Interesting...thanks vB Style.
What do you think caused the error above?
TheLastSuperman
04-21-2010, 12:40 AM
Interesting...thanks vB Style.
What do you think caused the error above?
Could be a number of things.. have them check the settings in php.ini for max users and there's more, if they are a half-arsed decent host they will know what to look for otherwise there is recommended server settings at vb.com.
Naan-Kadavul
04-25-2010, 06:40 AM
its a database error.. you can fix it easily..see whats wrong actually...
and if u can't replace it with a recent backup that you have taken...
wish you the best...
Nintendo-Daily
07-16-2010, 03:49 PM
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:
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
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
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
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.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.