This is the SQL code that produces the error:
DELETE FROM testdata.absences;
INSERT INTO testdata.absences SELECT * FROM sourcedata.absences;
INSERT INTO testdata.absences VALUES (101,302,'2003/09/23',2001,'1',201,0,0,505)
Data is copied from a source database, sourcedata, to the destination database,
testdata,
followed by inserting one record into the testdata.absences table.
The first time through, it runs fine without error. The second time through,
this error
occurs: "1034- Couldn't fix table with quick recovery: Found wrong number of
deleted records"
I've attached the absences table files to this email.
2 messages in com.mysql.lists.win32BUG in your SQL engine for MySQL V 4.
