I spent about four very painful hours last night doing an Access to MySQL migration on my forum. At 1AM went I finally put the board live again I just clicked around and made sure all the data was there but I never tried to post anything. The forums are back down again as anytime someone tries to post they receive this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.23-nt]Duplicate entry '2-36-8391-0' for key 1
/forum/post_info.asp, line 981
I'm at work and don't have any ability to troubleshoot - so I thought I would ask here and see if anyone has any suggestions for me to try when I get home.
We created the tables using setup.asp with a local copy of snitz - then exported all the access data into text files and imported those into the various tables. We then exported the entire database to a .sql file and uploaded that to the webserver.
I'll take a look at the table this line is referencing and look for duplicate key values - thanks.
We figured out the problem was that somewhere in the migration process all the auto_increment tags got lost for all the tables. So, once I set those and then updated counts everything works fine.
Topic Locked
Posted - 29 November 2006 : 11:52:53
