some kind of database probem !

Anon

Since last week a table dosent work, my hosting is not giving me any answer to my emails, so maybe here someone can help.

Its in mySQL database.

When i try to Browse the table with phpMyAdmin i get this error

Warning: MySQL: Unable to save result set in /home/phpweb/www/padminp//dbadmin/sql.php3 on line 53

Warning: MySQL: Unable to save result set in /home/phpweb/www/padminp//dbadmin/sql.php3 on line 57

Database poketien - table temp
Error

MySQL said: Got error 127 from table handler

I dont know what to do....
There are some tables with the same error, and some table are without errors....

Can i mend the problem ?! or i have to make the table again (lots of work) ?!

You can see the page also with problems

http://www.poketienda.cl/tienda5/index.php3

PLEASE HELP !!!

Anon

Just how big are the tables? how much data is in them?

Anon

I repaired the tables.
One table had 5000 lines and the other about 50.

but things where solved with myisamchk..
thanks

Anon

Hi !

I'm just having the same problem that you did, Benja :
... error messages "Unable to save result set" and "Got error 127 from table handler" on some of my tables.

You fortunately repaired your tables with "myisamchk" : could you tell me how this work ?
(I support my database with PhpMyAdmin)

Thanks a lot,

benja wrote:

I repaired the tables.
One table had 5000 lines and the other about 50.

but things where solved with myisamchk..
thanks