1062 - Duplicate entry. Pleeeeaaase help!

[Guest]

Been trying for over 3 weeks to halt this problem. These errors occur on the wpcallback.php page when I uss SSL but DOESN'T if SSL is set to false.

 

Driving me round the bend!

 

1062 - Duplicate entry '3e8fb749dd2bd42aaf45661e632f135e' for key 1

 

insert into sessions values ('3e8fb749dd2bd42aaf45661e632f135e?language=en', '1075751250', '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:\"GBP\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:14:\"wpcallback.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:3:{s:6:\"osCsid\";s:44:\"3e8fb749dd2bd42aaf45661e632f135e?language=en\";s:7:\"msgType\";s:10:\"authResult\";s:12:\"installation\";s:5:\"86040\";}s:4:\"post\";a:36:{s:8:\"testMode\";s:3:\"100\";s:8:\"authCost\";s:5:\"255.0\";s:8:\"currency\";s:3:\"GBP\";s:7:\"address\";s:56:\"\\\';l\\\';l\\\';l \\\';l\\\';l\\\';l l;k;lk;lk;lk;l ;lk;lk;kl;lk\";s:13:\"countryString\";s:14:\"American Samoa\";s:12:\"installation\";s:5:\"86040\";s:3:\"fax\";s:0:\"\";s:12:\"countryMatch\";s:1:\"B\";s:7:\"transId\";s:8:\"60601716\";s:3:\"AVS\";s:4:\"0000\";s:12:\"amountString\";s:12:\"?255.00\";s:8:\"postcode\";s:12:\"\\\';l\\\';l\\\';l\";s:7:\"msgType\";s:10:\"authResult\";s:4:\"name\";s:13:\"chris Hempers\";s:3:\"tel\";s:14:\"21321321321321\";s:11:\"transStatus\";s:1:\"Y\";s:4:\"desc\";s:26:\"Purchase from Babydeal Ltd\";s:8:\"cardType\";s:6:\"Switch\";s:4:\"lang\";s:2:\"en\";s:9:\"transTime\";s:13:\"1075749810887\";s:16:\"authAmountString\";s:12:\"?255.00\";s:10:\"authAmount\";s:5:\"255.0\";s:9:\"ipAddress\";s:12:\"81.86.239.41\";s:4:\"cost\";s:5:\"255.0\";s:6:\"instId\";s:5:\"86040\";s:9:\"MC_oscsid\";s:0:\"\";s:6:\"amount\";s:5:\"255.0\";s:8:\"compName\";s:12:\"Babydeal Ltd\";s:7:\"country\";s:2:\"AS\";s:11:\"MC_callback\";s:85:\"www.babydeal.co.uk/wpcallback.php?osCsid=3e8fb749dd2bd42aaf45661e632f135e?language=en\";s:14:\"rawAuthMessage\";s:22:\"cardbe.msg.testSuccess\";s:5:\"email\";s:21:\"[email protected]\";s:12:\"authCurrency\";s:3:\"GBP\";s:11:\"rawAuthCode\";s:1:\"A\";s:6:\"cartId\";s:39:\"osCsid=3e8fb749dd2bd42aaf45661e632f135e\";s:8:\"authMode\";s:1:\"A\";}}}s:8:\"snapshot\";a:0:{}}')

 

[TEP STOP]

 

1062 - Duplicate entry '3e8fb749dd2bd42aaf45661e632f135e' for key 1

 

insert into sessions values ('3e8fb749dd2bd42aaf45661e632f135e?language=en', '1075751250', '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:\"GBP\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:14:\"wpcallback.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:3:{s:6:\"osCsid\";s:44:\"3e8fb749dd2bd42aaf45661e632f135e?language=en\";s:7:\"msgType\";s:10:\"authResult\";s:12:\"installation\";s:5:\"86040\";}s:4:\"post\";a:36:{s:8:\"testMode\";s:3:\"100\";s:8:\"authCost\";s:5:\"255.0\";s:8:\"currency\";s:3:\"GBP\";s:7:\"address\";s:56:\"\\\';l\\\';l\\\';l \\\';l\\\';l\\\';l l;k;lk;lk;lk;l ;lk;lk;kl;lk\";s:13:\"countryString\";s:14:\"American Samoa\";s:12:\"installation\";s:5:\"86040\";s:3:\"fax\";s:0:\"\";s:12:\"countryMatch\";s:1:\"B\";s:7:\"transId\";s:8:\"60601716\";s:3:\"AVS\";s:4:\"0000\";s:12:\"amountString\";s:12:\"?255.00\";s:8:\"postcode\";s:12:\"\\\';l\\\';l\\\';l\";s:7:\"msgType\";s:10:\"authResult\";s:4:\"name\";s:13:\"chris Hempers\";s:3:\"tel\";s:14:\"21321321321321\";s:11:\"transStatus\";s:1:\"Y\";s:4:\"desc\";s:26:\"Purchase from Babydeal Ltd\";s:8:\"cardType\";s:6:\"Switch\";s:4:\"lang\";s:2:\"en\";s:9:\"transTime\";s:13:\"1075749810887\";s:16:\"authAmountString\";s:12:\"?255.00\";s:10:\"authAmount\";s:5:\"255.0\";s:9:\"ipAddress\";s:12:\"81.86.239.41\";s:4:\"cost\";s:5:\"255.0\";s:6:\"instId\";s:5:\"86040\";s:9:\"MC_oscsid\";s:0:\"\";s:6:\"amount\";s:5:\"255.0\";s:8:\"compName\";s:12:\"Babydeal Ltd\";s:7:\"country\";s:2:\"AS\";s:11:\"MC_callback\";s:85:\"www.babydeal.co.uk/wpcallback.php?osCsid=3e8fb749dd2bd42aaf45661e632f135e?language=en\";s:14:\"rawAuthMessage\";s:22:\"cardbe.msg.testSuccess\";s:5:\"email\";s:21:\"[email protected]\";s:12:\"authCurrency\";s:3:\"GBP\";s:11:\"rawAuthCode\";s:1:\"A\";s:6:\"cartId\";s:39:\"osCsid=3e8fb749dd2bd42aaf45661e632f135e\";s:8:\"authMode\";s:1:\"A\";}}}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

[RodrigoDC]

Got the same problem. Any help would be appreciated as well.

 

Thanks.

[OceanRanch]

A work around was recently created that requires changes to the worldpay.php file.

 

It turned out to be a small change - the url created by the module in SSL mode added "language=xxxxxx" to the session id which caused problems by making the session longer than the 32 characters in the database.

 

Go to this thread to get the specific details....

 

http://www.oscommerce.com/forums/index.php?showtopic=79286&hl=

 

Good Luck,

Tom

[RodrigoDC]

Thanks Tom. Actually, I believe I found the reason (although not the technical cause) for the problem.

 

Perhaps Albion was doing the same thing I was doing: whenever I edited a page in the "Define Languages" admin section, I did not pay attention that some of the %s link variables were adding the session ID. Hence, If I edited the english.php page (or the spanish.php or any other page within the admin area), after saving the page it would now be saved with each link variabe as %s?7bf8ad2803fec9b7988579dd5a45dd3d. The more often I edited that one page, the more session IDs would tag onto the link variables. Obvioulsy, whenever I click on a link in the public catalog, the link would then direct me to two (or more) session IDs, thereby causing the error messages above.

 

My work-around was to either pay attention to those links each time I edited a page within the admin, or keep a copy of all language pages on my pc, edited them offline, and upload the pages to the server via FTP. Not practical, but effective.

 

I hope this helps someone..... :D

 

BTW, I am using a secure server provided by my hosting company, which differs from my domain name. So, if my domain is mydom.com, my https is something like secure.myhost.com/~username. I believe this may have something to do with the problem above, but I am not sure.