Announcement

Collapse
No announcement yet.

Big Problem

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

  • Big Problem

    It says:
    Database error in vBulletin 2.3.0:

    Invalid SQL: SELECT COUNT(*) AS threads FROM thread
    mysql error: Can't open file: 'thread.MYI'. (errno: 145)

    mysql error number: 1016

    Date: Sunday 18th of May 2003 08:06:16 PM
    Script:
    Referer:

    Why is this?
    RichM
    Senior Member
    Last edited by RichM; Sun 16 Jul '06, 6:04pm.

  • #2
    You've got a corrupted table. Run the following query in phpMyAdmin:

    REPAIR TABLE thread;

    If you don't have phpMyAdmin upload repair.php from your 'extras' folder in the vBulletin zip file then run it.

    Comment


    • #3
      This is what it says when i try to do that in phpmyadmin, i do not understand repair.php either.

      Can't open file: 'thread.MYI'. (errno: 145)

      Error

      SQL-query :

      SHOW FIELDS FROM `thread` FROM `hf_habboforum`

      MySQL said:


      Can't open file: 'thread.MYI'. (errno: 145)
      Back

      Comment


      • #4
        http://www.habboforum.com/repair.php Makes no sense at all, i have restarted MySQL on the server, still no luck.

        Comment


        • #5
          Is the problem fixed now? I just ran repair.php for you...

          Comment


          • #6
            It is ok now. Thanks for giving me the idea.

            Comment


            • #7
              In phpmyadmin, you can check the checkbox in front of the corrupt table, below all the tables is a drop down box, select optimize there and then repair when it is done.
              Make sure you have first closed your forum down when you play with optimize and repair.

              Comment

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