Announcement

Collapse
No announcement yet.

Database error

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

  • Steve Machol
    replied
    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

    Leave a comment:


  • MYU
    replied
    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 :

    Leave a comment:


  • MYU
    replied
    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 :

    Leave a comment:


  • Lynne
    replied
    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.

    Leave a comment:


  • Ray2khax
    replied
    It's kind of hard without seeing the databse error # do you have the actaul db error page?

    Leave a comment:


  • MYU
    started a topic Database error

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X