Announcement

Collapse
No announcement yet.

Lots of database errors

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

  • Lots of database errors

    Since I've upgraded my forum to the latest vBulletin version, I'm having a lot of database and php errors. Most of the time it's just a connection error (even though I can connect to the database through phpMyAdmin).
    Today my site is down with the following error:

    Database error in vBulletin :

    Invalid SQL:

    SELECT *
    FROM vb3_datastore
    WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','userstats','birthdaycache','ma xloggedin','iconcache','eventcache','mailqueue');

    MySQL Error : Got error 12 from storage engine
    Error Number : 1030
    Date : Tuesday, January 2nd 2007 @ 01:55:35 AM
    Script : http://www.renderglobal.org/forum_closed/
    Referrer :
    IP Address : xx.xx.xx.xx
    Username :
    Classname : vb_database

    I had to rename my forum path due to the massive e-mails I'm getting.

    If you go to renderglobal.org/forum_closed you get the following:

    Warning: mysql_query() [function.mysql-query]: Unable to save result set in /includes/class_core.php on line 363

    Any idea?

    Thanks,
    Alex
    Last edited by alexongaro; Tue 2 Jan '07, 1:39am.

  • #2
    Since I can connect to the CP, I analyzed the database through phpMyAdmin and found a lot of corrupted tables. I was able to repair all of them but the following:

    renderglobal_org_-_vB_2004.vb3_customprofilepic ¦ repair ¦error 12 ¦when fixing table

    Comment


    • #3
      Still me. After fixing those tables (except the customprofilepic that I think I need to recreate but I don't know how) I was finally able to connect to the adminCP, but I'm still getting mySql errors, at least 1 time out of 3.

      Invalid SQL:

      SELECT setting.*, settinggroup.grouptitle
      FROM vb3_settinggroup AS settinggroup
      LEFT JOIN vb3_setting AS setting USING(grouptitle)
      WHERE settinggroup.displayorder <> 0
      ORDER BY settinggroup.displayorder, setting.displayorder;

      MySQL Error : Got error 12 from storage engine
      Error Number : 1030
      Date : Tuesday, January 2nd 2007 @ 02:34:57 AM
      Script : http://www.renderglobal.org/forum_cl...ons.php?null=0
      Referrer : http://www.renderglobal.org/forum_cl...dex.php?do=nav
      IP Address : xx.xx.xx.xx
      Username : *****************
      Classname : vb_database

      I asked support to my host, but they believe (as always) the problem is on the vBulletin software but I doubt it.

      Comment


      • #4
        This is a server issue:

        System error: 12 = Cannot allocate memory

        You need to contact your host about this. They will probably need to reboot the server to fix this.

        Comment


        • #5
          That's what I thought and I told them, but they keep on saying they don't see any error. I'm really thinking about changing server..

          Comment


          • #6
            You dont by anychance use mediatemple for your hosting do you?

            I'm having this exact same problem

            Comment


            • #7
              Yes I do!!

              Comment

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