I had a problem last week with a table I was using maybe you have a similar problem. I had an auto increment problem as I was using tiny int (which only allows 127 records) on a column but ended up with more than 127 records. Once I changed my autoincrement column to int from tiny int I was able to proceed.
Hope that helps you. Dave Lake >From: "Diehl, Jeffrey" <[EMAIL PROTECTED]> >To: "'Chris Bolt '" <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" ><[EMAIL PROTECTED]> >Subject: RE: Error 127 from table handler. >Date: Thu, 25 Oct 2001 00:13:10 -0600 > >I guess I haven't given you a complete description of the problem. I've >done an isamchk -o, -r -e on the table. I still get this error. > >Any other ideas? > >Thanx, >Mike Diehl. > >-----Original Message----- >From: Chris Bolt >To: [EMAIL PROTECTED] >Sent: 10/24/2001 5:54 PM >Subject: RE: Error 127 from table handler. > > > I'm using 3.22.27 and am getting an error when I submit queries. > > > > I do a select * from table where... > > > > And it gives me: > > > > ERROR 1030: Got error 127 from table handler > >chris@entropy:~$ perror 127 >Error code 127: Unknown error 127 >127 = Record-file is crashed > >Run isamchk -r on the table. > >--------------------------------------------------------------------- >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 > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp --------------------------------------------------------------------- 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
