The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
![]()
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...p?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 : ----------------------------------- |
#2
|
|||
|
|||
![]()
This is a server issue.
See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway and this: http://www.vbulletin.com/forum/showt...265#post310265 |
#3
|
||||
|
||||
![]()
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. |
#4
|
|||
|
|||
![]()
I registered fine.
|
#5
|
||||
|
||||
![]()
Interesting...thanks vB Style.
What do you think caused the error above? |
#6
|
||||
|
||||
![]()
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.
|
#7
|
||||
|
||||
![]()
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... |
#8
|
||||
|
||||
![]()
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 |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|