vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Is this a highjack attempt? (https://vborg.vbsupport.ru/showthread.php?t=240906)

Nintendo-Daily 04-20-2010 11:17 PM

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 :

-----------------------------------

ForumsMods 04-20-2010 11:40 PM

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

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

Quote:

Originally Posted by Nintendo-Daily (Post 2024604)
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:

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.


All times are GMT. The time now is 11:44 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.01076 seconds
  • Memory Usage 1,746KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete