John, Error 144 that the table is crashed and the last repair failed. You should run a check and optimize on this table if possible. Error 13 indicates that you do not have permission to access the file. If you are the System Administrator you may want to check the file permissions. Otherwise, you will want to get in touch with the System Administrator.
I hope this has been helpful. Victor -----Original Message----- From: John P To: [EMAIL PROTECTED] Sent: 10/23/02 9:21 AM Subject: Re: INSERT query crashes MySQL Another error! PHP starts to output the error "Too many references: cannot splice - error 144" When logging into mysql, I get: "Didn't find any fields in table IDRefs" started with -A, I get: "cannot open file: IDRefs.MYD (error: 144)" optimize table IDRefs; "Can't open file: 'IDRefs.MYD'. (errno: 13)" explain IDRefs; "ERROR 1016: Can't open file: 'IDRefs.MYD'. (errno: 13)" delete from IDRefs; "Query OK, 0 rows affected (0.02 sec)" explain IDRefs; OK etc (nothing in mysql.err) I have changed the query to INSERT DELAYED in case too many clients are locking the table, should I change it back? Cheers John --------------------------------------------------------------------- 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
