Error: 1062 - Duplicate entry

[garnut]

Hi,

 

I had transfer all my files to my server. When i click to the menu categories i have this error: 1062 - Duplicate entry 'b7dec0e7397240d8c02397d97b54574f' for key 1

 

insert into sessions values ('b7dec0e7397240d8c02397d97b54574f?cPath=4', '1155692219', 'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:6:\"french\";languages_id|s:1:\"1\";currency|s:3:\"CAD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:40:\"b7dec0e7397240d8c02397d97b54574f?cPath=4\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')

 

How can i resolve this? One thing i know, it comes from the data base. I dont know nothing about SQL.

 

Thanks

[brianstorm]

are you using a bookmark from before? if so try not using the bookmark....

 

you could also try the link www.yourdomain.co.uk/login.php?osCsid=b7dec0e7397240d8c02397d97b54574f and see what happens

 

i'm not sure of exactly how the sessions are created & stored but you could try storing sessions as flat files (set in admin) or flushing your sessions table (potentially risky if you don't know what you are doing, and i can't say categorically that it won't cause a total disaster)

 

you can get documentation on mysql at www.mysql.com/documentation (if it is mysql)... sql itself is fairly easy...

[garnut]

I have tried this solution http://www.oscommerce.com/forums/index.php?sho...403&hl=1062 the problem seem resolved, however, the categories menu became inoperant.

 

Thanks