Got error 127 from table handler?

[perlone]

Why does mine saying:

MySQL said: Got error 127 from table handler.

Query: SELECT * FROM news_index ORDER BY id LIMIT 0, 20
There is no Knowledge that is not power.
Age: 16
E-mail: projectnet01@yahoo.com
School: Coral Springs High (

http://www.coralspringshigh.com)

Companynot done yet)
Status: Currently working with C++ for game developing. And making a musical band.
-Aaron

 

[rycamor]

If this is a Linux or Unix system, you can enter "perror 127" at the console, and it will tell you what that error is. On my FreeBSD machine the answer is "127 = Record-file is crashed". It's not necessarily the same, since AFAIK different OSes have different numbering for errors, so you should check yours.

Is this error generated from a PHP script? Have you tried running this query directly from the console? -------------------

Current reading --

http://www.wnd.com/news/article.asp?ARTICLE_ID=25456

 

[perlone]

Hi,

I'm using apache on windows. It works fine after I empty the table and the error is generating from a perl script. I did ran the console and here's the results:

mysql-> use ng;
mysql-> database changed
mysql-> select * from user_opinions;
ERROR 1030: Got Error 127 from table handler.
There is no Knowledge that is not power.
Age: 16
E-mail: projectnet01@yahoo.com
School: Coral Springs High (

http://www.coralspringshigh.com)

Companynot done yet)
Status: Currently working with C++ for game developing. And making a musical band.
-Aaron

 

[rycamor]

Run the following:

mysqldump -u {username} -p ng > ng.sql

Then create a new database, and import this sql file in to re-create your tables:

msyql -u {username} -p new_database < ng.sql

Try running your query on this database. If it still doesn't work, and if you feel comfortable showing your database structure, post the SQL create statements here, and we will have a look ;-). -------------------

Current reading --

http://www.wnd.com/news/article.asp?ARTICLE_ID=25456