Jump to content


Photo

Cant open a table


  • Please log in to reply
2 replies to this topic

#1 dane08

dane08
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 06 December 2005 - 06:01 AM

Hi!

My problem is about a table that keeps on giving me an error 145 even if i drop it and remake it again and again. The actual error that is receive is: "Can't open file: 'searchindex.MYD'. (errno: 145)".

What i mean by again and again is i after I remade the table and them make some inserts into it, then after several days i *again* get the same error. I have encountered this so many times and only in this particular table. i even rebuild the whole database before but untill now i get that error.

What should i do?

#2 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 06 December 2005 - 04:24 PM

the table is currupted. try
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]REPAIR TABLE searchindex [!--sql2--][/div][!--sql3--]
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...

#3 dane08

dane08
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 07 December 2005 - 10:32 AM

[!--quoteo(post=325086:date=Dec 6 2005, 11:24 AM:name=ryanlwh)--][div class=\'quotetop\']QUOTE(ryanlwh @ Dec 6 2005, 11:24 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
the table is currupted. try
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]REPAIR TABLE searchindex [!--sql2--][/div][!--sql3--]
[/quote]

i just did that and it worked. I hope it wont get corrupted again. tnx :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users