No announcement yet.

'forum.MYI' Can't Open

  • Filter
  • Time
  • Show
Clear All
new posts

  • 'forum.MYI' Can't Open

    I keep on getting this error message:

    Invalid SQL: SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
    mysql error: Can't open file: 'forum.MYI'. (errno: 145)

    Its because my thread table is corrupted, I repair it, but only to find it gets corrupted again. I think its because i have mods on my site and they are causing it to get corrupted.

    Are there any programs which can clean the database table or return the database to its original tables?
    My Football Forum

  • #2
    1. check to see if any disk partitions are full
    2. close your forum and run repair.php

    do you have a dedicated server ?

    what version of php and mysql are you using ?
    :: 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 [ blog summary ]


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