Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1062 Duplicate Entry Error Fix


jpweber

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!

Link to comment
Share on other sites

  • Replies 50
  • Created
  • Last Reply

Archived

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

×
×
  • Create New...