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
