Data corruption on deletes

[Jim Nachlin]

I have a table with several keys.  When I try to delete anything from 
this table, I get data corruption and have to repair it with myisamchk. 
 Selects, updates work fine.

Here's the create table statement:
CREATE TABLE `postsearch` (
  `postId` int(11) NOT NULL default '0',
  `weblogId` int(11) NOT NULL default '0',
  `url` varchar(200) NOT NULL default '',
  `plink` varchar(200) NOT NULL default '',
  `image` varchar(100) default NULL,
  `language` varchar(100) default NULL,
  `title` varchar(100) default NULL,
  `weblogTitle` varchar(100) default NULL,
  `dateCreated` datetime NOT NULL default '0000-00-00 00:00:00',
  `post` text,
  `excerpt` text,
  `parserVersion` varchar(255) default NULL,
  PRIMARY KEY  (`postId`),
  KEY `weblog_key` (`weblogId`,`dateCreated`),
  KEY `url_key` (`url`),
  KEY `plink_key` (`plink`),
  FULLTEXT KEY `excerpt` (`excerpt`)
) TYPE=MyISAM
I think I have to somehow disable the keys, but am not sure quite how.
Here's what happens when I try to delete:
mysql> select postId from postsearch where dateCreated < NOW() - 
INTERVAL 14 DAY limit 1;
+--------+
| postId |
+--------+
|  65031 |
+--------+
1 row in set (0.10 sec)

mysql> delete from postsearch where postId=65031 limit 1;
ERROR 1034: Incorrect key file for table: 'postsearch'. Try to repair it

Anybody have any idea?
   Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]