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

If anyone has anything interesting to add to this, I'd love to hear it.

Thanks

Performance on MYISAM tables is greatly affected by the state of the table.  Putting optimization commands in your scripts will keep them running as smoothly and quickly as possible, particularly after inserts and updates.

Try using this :
Code: Select all
    TRUNCATE phpBB_sessions;
Code: Select all
    REPAIR TABLE phpBB_sessions;

and the scripts as seen in http://www.phpbb.com/phpBB/viewtopic.php?t=259967
http://dev.mysql.com/doc/refman/5.5/en/crashing.html and
http://search.mysql.com/search/query/search?q=repair.html
may also fix the problem