Re: error in sec index entry update

2001-09-12 Thread Heikki Tuuri
Brian, your table seems to get corrupt only temporarily. It suggests I have a bug in the interplay of UPDATE and purge. Probably no need to reimport the table. About keys: there is no need to define the same key as the primary key and a non-primary. Thus the key roster_ is unnecessary. Thanks

Re: error in sec index entry update

2001-09-12 Thread Brian Mard Pittman
Heikki, Here is the output from CHECK TABLE: mysql> check table roster; +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | webassign.roster | check | status | OK | +--+