cancel
Showing results for 
Search instead for 
Did you mean: 

Error MYI'. (errno: 145)

abirhasan
Master User

Hi,

Were getting a few tickets from people with forum boards with regards to the 
MYI'. (errno: 145) 

Error 145 = Table was marked as crashed and should be repaired

This mainly happens with the "sessions" table.

This is the table responsible for storing who is logged in.
It's called by the script in order to display the username.

This is not a bug in the SQL.

In order to repair this:

  • Go into php myadmin.
  • Backup your Database.
  • Select the database in question.
  • check the box next to your sessions table.

(if you unsure which one this is, select them all)

  • Scroll down to the box that says "With selected"
  • Select "Repair"


This will then repair the table and you script should function again.

Please Remember to backup your database before attempting any of this.

More information on SQL table errors and how to repair them can be found at:

http://www.mysql.com/doc/en/Repair.html

Thanks

 

abirhasan
0 REPLIES 0