Jump to content

Archived

This topic is now archived and is closed to further replies.

jpweber

1062 Duplicate Entry Error Fix

Recommended Posts

Here is my error I was getting and then went about using Peter's addition:

 

1062 - Duplicate entry '367-2' for key 1
insert into products_description (products_name, products_description, products_url, products_id, language_id) values ('', '', '', '367', '2')
[TEP STOP]

 

Peter you missed a beat.

 

This works well by emptying out the sessions and renew the DB. However, when you added the entries back you didn't specify what Collation. I don't believe the sesskey should be INT or auto_increment, the security is certianly an issue. So, here is what I did once the DB was refreshed using Peter's suggestion:

 

Change sesskey to Type: VARCHAR, Length/Values: 64, Collation: latin1_swedish_ci and that's it! Nothing else. As you can see I sent the Length/Values up to 64, based upon the rest of the forums suggestion. This fixed the problem for me, hope it helps someone else!

Share this post


Link to post
Share on other sites

×