MySQL Problem: #1030 - Got error 127 from table handler

[Bigzed]

Hi,
I have a Mysql Database with 287,283 entries, 16,6 MB and the type ist MyISAM (no clue what that means).

I dont really know a lot about the whole mysql system, I can just make entries, get them back into my script etc..

Ok in PHPMyAdmin I can click on browse, and it shows me the first 30 rows. But when I'm searching for an entry or try to sort the result this error comes up:

SELECT *
FROM `keyword1`
ORDER BY `number` ASC
LIMIT 0 , 30
MySQL said:

#1030 - Got error 127 from table handler

PhpMyAdmin also says "Overhead:" 60 Bytes. Does that has anything to do with the problem?

I hope you can help me.

Thank you,
Bigzed.

[ergophobe]

The overhead is no issue.

As for the rest, sorry, I didn't have time to sort it out, but this Google Search [google.com] brings up lots of mentions on the MySQL Bug tracker and bug lists.

[Bigzed]

Hi,
thanks for your answer.

Of course I've searched google too but on that sites people are talking about running a debugger or creating a dummy row and then deleting it, but I have no clue what that stuff means, thats the Problem. I'm a total beginner in mysql and phpmyadmin...

[Bigzed]

Hi,
a little update.
I just saw in the Cronjob-Result-Mail, that its not possible to make new entries anymore.
Instead thats the result:

Warning: mysql_query(): Unable to save result set in
/home/trinity/public_html/getdata.php on line 63

Bigzed.

[coopster]

Have you tried myisamchk [dev.mysql.com]?

[Bigzed]

woow I just had to klick on "Repair" on menue under the Table in PHPMySQL.
I works now.

Sorry I should have tried that earlier.

Thanks for your help guys :).