Can anyone shed some light on this? Have found that others have
run into this (via Google) but no resolution and no hits at
www.mysql.com.
A count(*) query returns fine but trying to select the rows
fails (see log snippet below).
Regards,
Bob
mysql> select count(*) from event where sid=9 and cid > 694725;
+----------+
| count(*) |
+----------+
| 4925 |
+----------+
1 row in set (0.01 sec)
mysql> select * from event where sid=9 and cid > 694725 LIMIT 0, 100000;
ERROR 1030: Got error 127 from table handler
mysql> select * from event where sid=9 and cid > 694725 LIMIT 0, 100000;
ERROR 1030: Got error 127 from table handler
mysql> select * from event where sid=9 and cid > 694725;
ERROR 1030: Got error 127 from table handler
---------------------------------------------------------------------
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
