Mike,
Erro 127 means that the table is marked as crashed. You should run a
check and repair if necessary.
Error code 127: Unknown error
127 = Record-file is crashed
I hope this helps.
-----Original Message-----
From: Mike Lucente [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 9:00 AM
To: [EMAIL PROTECTED]
Subject: Unable to add index
Hello,
I cannot add an index to one of my tables. I get the following message:
mysql> alter table devlog add index (dt_status);
ERROR 1030: Got error 127 from table handler
I've run 'myisamchk -o <table>' on the table in question.
What should I try next?
Version: Server version 3.23.29a-gamma
OS: RedHat Linux 7.2
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
