Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-20-2010, 11:17 PM
Nintendo-Daily's Avatar
Nintendo-Daily Nintendo-Daily is offline
 
Join Date: Nov 2008
Posts: 311
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Is this a highjack attempt?

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 :

-----------------------------------
Reply With Quote
  #2  
Old 04-20-2010, 11:40 PM
ForumsMods ForumsMods is offline
 
Join Date: Aug 2007
Location: Argentina
Posts: 667
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #3  
Old 04-20-2010, 11:46 PM
Nintendo-Daily's Avatar
Nintendo-Daily Nintendo-Daily is offline
 
Join Date: Nov 2008
Posts: 311
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 04-21-2010, 12:22 AM
ForumsMods ForumsMods is offline
 
Join Date: Aug 2007
Location: Argentina
Posts: 667
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I registered fine.
Reply With Quote
  #5  
Old 04-21-2010, 12:34 AM
Nintendo-Daily's Avatar
Nintendo-Daily Nintendo-Daily is offline
 
Join Date: Nov 2008
Posts: 311
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Interesting...thanks vB Style.

What do you think caused the error above?
Reply With Quote
  #6  
Old 04-21-2010, 12:40 AM
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
Senior Member
 
Join Date: Sep 2008
Location: North Carolina
Posts: 5,844
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Nintendo-Daily View Post
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.
Reply With Quote
  #7  
Old 04-25-2010, 06:40 AM
Naan-Kadavul's Avatar
Naan-Kadavul Naan-Kadavul is offline
 
Join Date: Sep 2009
Location: Singpore
Posts: 249
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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...
Reply With Quote
  #8  
Old 07-16-2010, 03:49 PM
Nintendo-Daily's Avatar
Nintendo-Daily Nintendo-Daily is offline
 
Join Date: Nov 2008
Posts: 311
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:12 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04144 seconds
  • Memory Usage 2,233KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete