On Tue, 27 Mar 2001, Sascha Eversmeier wrote:
> Hi,
>
> could anyone of you please take a look at this message:
> 'MySQL said: Got error 127 from table handler'
>
> This occurs when trying to access a specific table, like 'select * from
> someTab', but it works when appending ' limit 0, X'.
>
> Of what type is this error?
> Any comments highly appreciated.
Running perror shows "127 = Record-file is crashed"
This means that somewhere along the way, you guessed it, there is a crashed record(!)
When you ran with limit 0,X you obviously don't have X large enough to reach the
broken rec. I trust that if you ran with limit 0,X where X=count(*), you'll get the
same error :-)
Hopefully running a check with myisamchk (if table is MyISAM) will do the job (?)
regards,
thalis
---------------------------------------------------------------------
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