1062 Duplicate Entry

[brianbpe]

I get the following text at the bottom of my screen when I try to log in to my shopping cart.

1062 - Duplicate entry '936b886b19412dc43dfd68b792da2f43' for key 1

 

insert into sessions values ('936b886b19412dc43dfd68b792da2f43?osCAdminID=62bfbbc2883ab89043d9b4320e75293a', '1126643627', 'SESSION_SSL_ID|b:0;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:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"login.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:76:\"936b886b19412dc43dfd68b792da2f43?osCAdminID=62bfbbc2883ab89043d9b4320e75293a\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')

 

[TEP STOP]

 

1062 - Duplicate entry '936b886b19412dc43dfd68b792da2f43' for key 1

 

insert into sessions values ('936b886b19412dc43dfd68b792da2f43?osCAdminID=62bfbbc2883ab89043d9b4320e75293a', '1126643628', 'SESSION_SSL_ID|b:0;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:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"login.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:76:\"936b886b19412dc43dfd68b792da2f43?osCAdminID=62bfbbc2883ab89043d9b4320e75293a\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')

 

[TEP STOP]

 

 

Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

 

I was just wondering if there is a way to end this session if a person has closed their browser without logging out? I am assuming that is what is happening.

[Guest]

use phpmyadmin and empty the sessions table.

also, make sure your configure.php file, store_sessions has mysql for the value

[brianbpe]

ok I checked and my configure.php has store_sessions as mysql. So if I empty the table will it get rid of the problem permanently or will I have to empty the table as part of routine maint?

[Guest]

use phpmyadmin and empty the sessions table.

also, make sure your configure.php file, store_sessions has mysql for the value

 

 

This seems to be a quick fix. What able the other tables in the osCommerce database that you cannot simply dump them?

 

I have had this same error recently from a move that I made from one server to another. Ever since I "exported" from server 1 using phpmyadmin and then "imported" the CSV file on server 2 I have been having the 1062 duplicate entry error on the table writes. I believe the biggest complaint has been that nothing adds to the shopping cart, the admin cannot add any new products, and no-one can order from the site?? Help anyone? I can provide an example export if needed.

 

Thanks

Aaron