Announcement

Collapse
No announcement yet.

my board stopped working this morning with this database error:

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

  • my board stopped working this morning with this database error:

    There seems to have been a slight problem with the (board name) database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.



    ---------

    Can anyone tell me what I should do first to troubleshoot this problem? I have connected to the mySQL database using a mySQL interface program and I can see the tables and information and so forth, and everything appears OK... what do i do? I am not a PHP or SQL expert. Thanks!!

  • #2
    right click and view the source code on the error page and find the mysql error message between the comments i.e.

    <!-- mysql error message -->

    and paste it here
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      <!-- Database error in vBulletin 2.2.6:

      Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='8462'
      mysql error: Can't open file: 'user.MYD'. (errno: 145)

      mysql error number: 1016

      Date: Wednesday 02nd of October 2002 11:15:02 AM
      Script: http://bbs.buccaneers.com/index.php
      Referer:
      -->




      Originally posted by eva2000
      right click and view the source code on the error page and find the mysql error message between the comments i.e.

      <!-- mysql error message -->

      and paste it here

      Comment


      • #4
        Try running this query:
        Code:
        REPAIR TABLE user;
        --filburt1, vBulletin.org/vBulletinTemplates.com moderator
        Web Design Forums.net: vB Board of the Month
        vBulletin Mail System (vBMS): webmail for your forum users

        Comment


        • #5
          Wow, how absolutely simple! That did it!!! Thanks so much!

          Originally posted by filburt1
          Try running this query:
          Code:
          REPAIR TABLE user;

          Comment


          • #6
            OMG devs, I just had an awesome idea!

            Picture this: the board gets an mysql errno of 145. It notices that's a corruption error and automatically tries to run REPAIR TABLE tablename to fix it!

            Self-repairing forum!
            --filburt1, vBulletin.org/vBulletinTemplates.com moderator
            Web Design Forums.net: vB Board of the Month
            vBulletin Mail System (vBMS): webmail for your forum users

            Comment


            • #7
              Originally posted by filburt1
              OMG devs, I just had an awesome idea!

              Picture this: the board gets an mysql errno of 145. It notices that's a corruption error and automatically tries to run REPAIR TABLE tablename to fix it!

              Self-repairing forum!
              well sometimes repair chops off too many corrupted entries and some admins like to backup their database before running repair procedures
              :: Always Back Up Forum Database + Attachments BEFORE upgrading !
              :: Nginx SPDY SSL - World Flags Demo [video results]
              :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

              Comment

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