jeannek

JorgeFernandes, on 25 August 2011 - 06:46 PM, said:

Hi

I am posting this for the sake of anyone who may not have found a solution for the error "#1062 - Duplicate entry '0' for key 'PRIMARY". (Sorry if it's already been posted elsewhere.) This is what worked for me...

When importing the SQL script into osc 2.3.1 using phpMyAdmin, I got the error:   "#1062 - Duplicate entry '0' for key 'PRIMARY". Amending the the script did not sort it out. Instead, I realised that I needed to UNCHECK the following in order for it to be imported sucessfully:

• Do not use AUTO_INCREMENT for zero values

It seemed to work ok with the same database that I had attempted on before but to be on the safe side I renamed the database, created a new database for osc using the original database's name, and then imported the database structure and data from a backup copy (which I had made before attempting to install this mod). After testing and confirming that all was well, I deleted the database in which I had initially run the script.

Hope it helps someone.

Jeanne