Announcement

Collapse
No announcement yet.

Big Problem

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

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

    Leave a comment:


  • RichM
    replied
    It is ok now. Thanks for giving me the idea.

    Leave a comment:


  • Cary
    replied
    Is the problem fixed now? I just ran repair.php for you...

    Leave a comment:


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

    Leave a comment:


  • RichM
    replied
    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

    Leave a comment:


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

    Leave a comment:


  • RichM
    started a topic Big Problem

    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?
    Last edited by RichM; Sun 16 Jul '06, 5:04pm.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X