Error MYI'. (errno: 145)

abirhasan — Mon, 10 Sep 2012 17:27:30 GMT

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

topic Error MYI'. (errno: 145) in Archive

Error MYI'. (errno: 145)