Web Hosting Forum | Lunarpages

Author Topic: Error MYI'. (errno: 145)  (Read 35562 times)

Offline StephanieŽ

  • Master Jedi
  • *****
  • Posts: 1094
Error MYI'. (errno: 145)
« on: September 12, 2003, 10:11:27 AM »
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 :P

Offline MishaPappa

  • Jabba the Hutt
  • *****
  • Posts: 587
Error MYI'. (errno: 145)
« Reply #1 on: September 12, 2003, 10:20:52 AM »
This thread may prove insightful into the problem as well http://www.lunarforums.com/forum/viewtopic.php?t=7362 (specifically the related cPanel info)

There may also be a problem if a table is defined as HEAP instead of MyISAM that leads to issues -- many forum products that initially used HEAP type tables in their architecture have recommended altering the table types to MyISAM -- though performance may suffer if a very busy site/database...
"I know that you understood what you think I said but I'm not sure you realize that what you heard is not what I meant..."

Andromeda, April 2003 - Sept 2004
Lyra, since Sept 2004

Misha

Offline TWebMan

  • Quantum Encyclopedia Writer
  • *****
  • Posts: 3054
    • Take charge of your site
Error MYI'. (errno: 145)
« Reply #2 on: April 29, 2004, 11:16:12 AM »
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.
"Computers cause people to make more mistakes than any other invention in history, with the possible exception of handguns and tequila."  - Unknown
"Liberty of any kind is seldom lost all at once." - D. Hume
Every day is an Ode to Joy
The planet will be fine... and so will your site

Offline clever_clown

  • Galactic Royalty
  • *****
  • Posts: 251
Re: Error MYI'. (errno: 145)
« Reply #3 on: October 08, 2008, 11:38:53 AM »
Hello StephanieŽ,

I thing there is a bug with the repair option (not sure) when I select the table and choose repair it reset the rows to 0,
let's take the users table is the crashed one, it will remove all the records...

Any ideas?? don't hesitate to share your info....

Cordially,

Offline Lunartique

  • Intergalactic Cowboy
  • *****
  • Posts: 51
  • LUNAFIL
    • LUNAR BONUS
Re: Error MYI'. (errno: 145)
« Reply #4 on: February 01, 2011, 10:40:08 AM »
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

Offline sannyfairy

  • Newbie
  • *
  • Posts: 1
Re: Error MYI'. (errno: 145)
« Reply #5 on: August 18, 2011, 03:41:22 AM »
Error 145 in MS sql indicates the database corruptiondu due to which you are unable to access database objects and tables. To fix this error, repair sql database with the help of msql repair tool which is highly enough to repair as well as recover all the sql database items completely.
 

Offline pavel

  • Spacescooter Operator
  • *****
  • Posts: 30
Re: Error MYI'. (errno: 145)
« Reply #6 on: September 10, 2012, 09:33:57 AM »
Please have a look followings link...

http://drupal.org/node/60693

Thanks

 

Share |