Re: Help with Duplicate Key (32-bit Solaris MySQL 4.1)

2005-04-11 Thread Renato Golin
On Monday 11 April 2005 16:00, mysql helppp wrote: > Error - Duplicate key '444642', -1 > (The syntax of the error message is not exact) probably index error, run myisamchk on the table, or "repair table" inside MySQL command line. Should fix without loose any data. --rengolin -- MySQL Genera

Help with Duplicate Key (32-bit Solaris MySQL 4.1)

2005-04-11 Thread mysql helppp
Folks, I've had a database running for months now and suddenly, when inserting into table 'HEARTBEAT_COUNTS' (desc below), I get an error: Error - Duplicate key '444642', -1 (The syntax of the error message is not exact) My insert statement does not include a value for 'id' which is an auto_incr