I am trying to using Magento 184.108.40.206 on a Windows 2008 server. I am getting this error when I tried to add a new product to the database.
SQLSTATE: Integrity constraint violation: 1062 Duplicate entry 24-0-1-60 for key PRIMARY
The database was carried over from a previous version 1.4.2 and since then has not ever worked right.
What I have already tried is:
1. Cleared the Log files
2. Cleared Cache in the Var folder
3. Cleared Session Cache in the Var folder
4. Tried to do a FULL new install and then restore the database and still no good
5. I created a secondary database and tried the repair tool (That Added missing foreign key or field to the database)
And with all of this still not working and starting to get REALLY frustrated. I went back to 1.4.2 and all was fine no erros adding products but then when I go back to 1.5 pop errors again! Can someone please help me figure out what, why and how to fix this please? I am open to any suggestions…
I do have to keep the database it has products in it from the past.
Thanks in advance for the help,