Announcement

Collapse
No announcement yet.

Database error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error

    I had so many problems with streamline.net hosting firm with VB so I moved to Justhost, I still have the same problems, within one day I have a DB overload and now the new hosting firm have suspended my database?

    Yesterday they suspended my account for using to much CPU usage and move me to a new server overload sever.

    They want me to sort it out, I have no idea where to start or what I am looking for.

    I used to have so many database errors with Streamline but they are less now that I am with Justhost and even yahoo mail members recive conformation to activate there accounts now after the move to Justhost.

    I need some help from anyone who could guide me. I have no access to my forum now.

    website address
    www.wearetherangersboys.com

    Link to forum is:
    www.wearetherangersboys.com/forum

    This is the email set to me from my hosting firm.

    Hi Mayur

    We have to suspend you DB weareth1_wearethera1.
    Because it is the cause of server's overload.
    Your account wasn't suspended.
    Can you fix the problem with DB?
    --
    Kind regards,
    Oliver Garner
    Justhost.com

  • #2
    It's kind of hard without seeing the databse error # do you have the actaul db error page?
    vBulletin.com great hosting guide made by me. 2,000+ Views
    Hosting Guide.

    Proud vBulletin License Owner!
    Did I help you out? Please give me a cookie then!
    http://cookyx.com/new/158.png
    Edlinpugs | Clan WrT

    Comment


    • #3
      Here's the database error I just got:
      Code:
      Invalid SQL:
      
                  SELECT *
                  FROM datastore
                  WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');
      
      MySQL Error   : Can't find file: './weareth1_wearethera1/datastore.frm' (errno: 13)
      Error Number  : 1017
      Request Date  : Thursday, June 18th 2009 @ 10:25:55 AM
      Error Date    : Thursday, June 18th 2009 @ 10:25:55 AM
      Script        : http://www.wearetherangersboys.com/forum/
      Referrer      : http://www.wearetherangersboys.com/
      IP Address    : xxxx
      Username      : 
      Classname     : vB_Database
      MySQL Version :
      I believe errno 13 is permission denied. Are you sure you have your config.php file set up correctly?

      edit: Whoops, since it's suspended, I guess that makes sense. We need to see what the database errors were before you got suspended.

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to vbulletin.org
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools <- awesome site for html/css help

      Comment


      • #4
        Thank you for your help, I deleted about 20 emails this moring before the site went dead.

        I just checked the email and found this last one, hope that helps.

        Database error in vBulletin 3.8.2:

        Invalid SQL:

        SELECT languageid,
        phrasegroup_global AS phrasegroup_global,
        options AS lang_options,
        languagecode AS lang_code,
        charset AS lang_charset,
        locale AS lang_locale,
        imagesoverride AS lang_imagesoverride,
        dateoverride AS lang_dateoverride,
        timeoverride AS lang_timeoverride,
        registereddateoverride AS lang_registereddateoverride,
        calformat1override AS lang_calformat1override,
        calformat2override AS lang_calformat2override,
        logdateoverride AS lang_logdateoverride,
        decimalsep AS lang_decimalsep,
        thousandsep AS lang_thousandsep
        FROM language
        WHERE languageid = 1;

        MySQL Error : MySQL server has gone away
        Error Number : 2006
        Request Date : Thursday, June 18th 2009 @ 08:51:54 AM
        Error Date : Thursday, June 18th 2009 @ 08:52:07 AM
        Script : http://www.wearetherangersboys.com/forum/cron.php?rand=1245333082
        Referrer : http://www.wearetherangersboys.com/forum/showthread.php?t=19765&page=2
        IP Address : 79.73.182.233
        Username :
        Classname : vB_Database
        MySQL Version :

        Comment


        • #5
          I now have 870 error messages in my junk folder that I found, they are the first two that from there.

          Database error in vBulletin :

          mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
          /home/weareth1/public_html/forum/includes/class_core.php on line 311

          MySQL Error :
          Error Number :
          Request Date : Wednesday, June 17th 2009 @ 07:49:06 PM
          Error Date : Wednesday, June 17th 2009 @ 07:49:06 PM
          Script : http://www.wearetherangersboys.com/forum/index.php
          Referrer : http://www.wearetherangersboys.com/forum/showthread.php?t=19577&page=2
          IP Address : 92.24.106.81
          Username :
          Classname : vB_Database
          MySQL Version :
          Database error in vBulletin 3.8.2:

          Invalid SQL:

          SELECT threadid, postid
          FROM post
          WHERE postid IN (0,72904);

          MySQL Error : MySQL server has gone away
          Error Number : 2006
          Request Date : Thursday, June 18th 2009 @ 04:36:02 AM
          Error Date : Thursday, June 18th 2009 @ 04:36:46 AM
          Script : http://www.wearetherangersboys.com/forum/online.php
          Referrer : http://www.wearetherangersboys.com/forum/index.php
          IP Address : 81.145.108.44
          Username : ScottJones
          Classname : vB_Database
          MySQL Version :

          Comment


          • #6
            1. This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

            http://www.vbulletin.com/forum/showt...265#post310265

            Also from the MySQL site:

            http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

            2. Assuming the db info in your config.php file is correct, this is a server issue. Please see this page for the causes of this error:

            http://www.vbulletin.com/docs/html/cantconnect
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X