Re: Can some please help me with a duplicate key error

[Peter Brawley]

The likely possibilities seem to be (i) a bug in how ODBC 3.51 interacts with your version 4.1 of MySQL, (ii) a corrupted table or index.

You can test (i) by running the Insert directly from the mysql client. If it works, the error you've been seeing is due to an interaction between Connector/ODBC and MySQL 4.1.22, so consider upgrading to MySQL 5.6.

If the error occurs also in the mysql client, test (ii):

rename table assetschedule to assetschedulebak;
create table assetschedule select * from assetschedulebak;
alter table assetschedule add primary key(recordnumber);
alter table assetschedule change column recordnumber recordnumber int unsigned auto_increment;

Then run the Insert to see if the error still occurs.

Please let us know the results of these tests.



Edited 3 time(s). Last edit at 05/20/2013 11:00PM by Peter Brawley.