HI, The 127 error message is "Record-file is crashed" - use myisamchk -r table_name to fix it. For further information on this topic check http://www.mysql.com/doc/R/e/Repair.html
Hope this helps Dobromir Velev Web Developer http://www.websitepulse.com/ -----Original Message----- From: WANG_FAITH??îÈõ-þì?L <[EMAIL PROTECTED]> To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]> Date: Saturday, December 29, 2001 03:25 Subject: query error >Hi, all >When I query data from a table ,the following error occurs: >ERROR 1030: Got error 127 from table handler. >Would you please tell me the reason to cause the error and how to deal with >it? >Thank you! > >--------------------------------------------------------------------- >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