Dear Everybody, Today I received the following error message in my web site (which is in php with mySql in UNIX environment), but it worked half a year until Today: Database allasajanlat Error SQL-query: SELECT TEHinserted, INFfoglalkozas, KEPmihezertek, KEPszakvizsgak, id FROM onelet WHERE TEHinserted >= '' AND (ELEemail != '' OR ELEurl != '' OR ELEtel != '' OR ELEfax != '') OR (INFfoglalkozas != '' OR KEPmihezertek != '' OR KEPszakvizsgak != '') ORDER BY TEHinserted DESC; MySQL said: Got error 127 from table handler I suppose too many records are in the table. 4216, but it shouldn't be the reason :-(, and unfortunately I am not allowed to delete any record from the database, because the records contain the information about subscripted users. 1, Do you know what can cause this error message? 2, What is the related exact error message text? 3, Where can I check the error message text, which related to error 127? 4, How can I solve this problem? 5, Do I have to change the mySql query, but how? And what is the reason that it worked half a year until now? 6, It should be some change in php or UNIX, but what? Thank you very very much for your help in advance Derby _____________________________________________________________ 6 MB ingyen email [EMAIL PROTECTED] ---> http://www.allasajanlat.hu --------------------------------------------------------------------- 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
