Getting the above error message on one of our servers using mySQL. Went to go and set up WebCalender on it and tracked an issue down to mySQL. If I execute the query of: mysql> SELECT * FROM webcal_entry, webcal_entry_user WHERE webcal_entry.cal_id = webcal_entry_user.cal_id AND webcal_entry.cal_date >= 20010201 AND webcal_entry.cal_date <= 20010231; It works fine and I get results back. However, if I add a simple ORDER BY, as in: mysql> SELECT * FROM webcal_entry, webcal_entry_user WHERE webcal_entry.cal_id = webcal_entry_user.cal_id AND webcal_entry.cal_date >= 20010201 AND webcal_entry.cal_date <= 20010231 ORDER BY webcal_entry.cal_time; Then I get "ERROR 1030: Got error -1 from table handler" returned back to me. I've shut down mysql (made sure no active processes left) and run isamchk -r on the ISM files. This was the output: # isamchk -r *.ISM - recovering ISAM-table 'webcal_entry.ISM' Data records: 4 - Fixing index 1 --------- - recovering ISAM-table 'webcal_entry_repeats.ISM' Data records: 0 - Fixing index 1 --------- - recovering ISAM-table 'webcal_entry_user.ISM' Data records: 4 - Fixing index 1 --------- - recovering ISAM-table 'webcal_user.ISM' Data records: 2 - Fixing index 1 --------- - recovering ISAM-table 'webcal_user_layers.ISM' Data records: 0 - Fixing index 1 --------- - recovering ISAM-table 'webcal_user_pref.ISM' Data records: 12 - Fixing index 1 # This did nothing to affect the problem. Some helpful info about the system: # mysql -V mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) # rpm -qa | grep -i mysql MySQL-3.22.32-1 mysqlgui-static-1.7.1-1 MySQL-client-3.22.32-1 MySQL-devel-3.22.32-1 MySQL-shared-3.22.32-1 # uname -a Linux <host> 2.2.14-5.0.14smp #2 Fri Jun 30 16:25:11 EDT 2000 i686 unknown # Any help appreciated. -- Nathan Clemons <[EMAIL PROTECTED]> 978-635-5300 ext 123 Linux Systems Administrator IRC: etrnl ICQ: 2810688 AIM: StormeRidr O | S | D | N, 50 Nagog Park, Acton, MA 01720 http://www.osdn.com/ Open Source Development Network Nextel: 978-423-0165 [EMAIL PROTECTED] --------------------------------------------------------------------- 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