emailanj Posted August 10, 2005 Share Posted August 10, 2005 :'( Customers cannot log in anymore. It kicks back to the indexphp page but stays in secure mode and does not kick out anymore. I get this error at the bottom of the page: 1062 - Duplicate entry 'a6cda91f5218288ec4e0f89f3d39690b' for key 1 insert into sessions values ('a6cda91f5218288ec4e0f89f3d39690b?osCAdminID=da3594bdc1bd3fe2423953ff9c015d93', '1123707253', '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:\"index.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:76:\"a6cda91f5218288ec4e0f89f3d39690b?osCAdminID=da3594bdc1bd3fe2423953ff9c015d93\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') [TEP STOP] 1062 - Duplicate entry 'a6cda91f5218288ec4e0f89f3d39690b' for key 1 insert into sessions values ('a6cda91f5218288ec4e0f89f3d39690b?osCAdminID=da3594bdc1bd3fe2423953ff9c015d93', '1123707253', '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:\"index.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:76:\"a6cda91f5218288ec4e0f89f3d39690b?osCAdminID=da3594bdc1bd3fe2423953ff9c015d93\";}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 Thanks so much for any advise, anj Link to comment Share on other sites More sharing options...
wizardsandwars Posted August 10, 2005 Share Posted August 10, 2005 Go into your phpmyadmin, and run the following in the sql window. truncate table sessions; ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
emailanj Posted August 10, 2005 Author Share Posted August 10, 2005 Thank You so much for your response, but I am not quite sure what you mean? I hate to ask as I am sure you are busy, just like all of us, but could you please list a few directions? Sorry I am kind of new. anj Go into your phpmyadmin, and run the following in the sql window.truncate table sessions; <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
FalseDawn Posted August 10, 2005 Share Posted August 10, 2005 First of all, are you running a Cpanel host? If so, there's a phpMyAdmin icon on the main screen. Find that, click it and phpMyAdmin should open. Then you select your database from the drop-down list on the left, and click the "SQL" tab at the top. Then type your command into the text box, then click "go" Link to comment Share on other sites More sharing options...
emailanj Posted August 10, 2005 Author Share Posted August 10, 2005 Thanks, I followed the instructions and ran the command and nothing happened. I know it took because it said it took 8 sec. I went to my site and I still have the same error. I took a screen shot but I am unsure of how I can post it here. Thanks for everything guys, anj First of all, are you running a Cpanel host? If so, there's a phpMyAdmin icon on the main screen. Find that, click it and phpMyAdmin should open.Then you select your database from the drop-down list on the left, and click the "SQL" tab at the top. Then type your command into the text box, then click "go" <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
emailanj Posted August 10, 2005 Author Share Posted August 10, 2005 Any idea's on what might have happened? Can I save my cart? (Ihope I hope Ihope...) Is there a file that needs to be replaced? I was almost finnished :'( I was hopping to go live by Friday :'( Please any thoughts....Please...... :'( anj Thanks, I followed the instructions and ran the command and nothing happened. I know it took because it said it took 8 sec. I went to my site and I still have the same error.I took a screen shot but I am unsure of how I can post it here. Thanks for everything guys, anj <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Guest Posted August 10, 2005 Share Posted August 10, 2005 in your configure.php file, what do you have set for store sessions? is it set to mysql? Link to comment Share on other sites More sharing options...
emailanj Posted August 10, 2005 Author Share Posted August 10, 2005 Thank you for your response, this is my config php fie <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://proshowequipment.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://secure.bluehost.com/~proshowe'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', true); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'proshowequipment.com'); define('HTTPS_COOKIE_DOMAIN', 'secure.bluehost.com/~proshowe'); define('HTTP_COOKIE_PATH', '/store/'); define('HTTPS_COOKIE_PATH', '/store/'); define('DIR_WS_HTTP_CATALOG', '/store/'); define('DIR_WS_HTTPS_CATALOG', '/store/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/home/proshowe/public_html/store/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be NULL for productive servers define('DB_SERVER_USERNAME', 'proshowe_osc1'); define('DB_SERVER_PASSWORD', 'I took this out for the post[t'); define('DB_DATABASE', 'proshowe_osc1'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?> in your configure.php file, what do you have set for store sessions? is it set to mysql? <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Guest Posted August 10, 2005 Share Posted August 10, 2005 you will need to change your password info and username now that you have posted the info. the things you dont want to post here are your db username and password Link to comment Share on other sites More sharing options...
emailanj Posted August 10, 2005 Author Share Posted August 10, 2005 Great...Blew it again... :'( Thanks. anj you will need to change your password info and username now that you have posted the info. the things you dont want to post here are your db username and password <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
emailanj Posted August 10, 2005 Author Share Posted August 10, 2005 Can you delete this? Great...Blew it again... :'( Thanks. anj <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
emailanj Posted August 10, 2005 Author Share Posted August 10, 2005 I guess you can't delete this one. Thats ok because I'LL just start from square one again. Too bad my mysq doesn't have a place were you can change the user name and password ,just delete it. Big mistake I made, but my cart was broken anyway. I was soooo close to being ok to go live.... Please for any of you newbies out there don't do what I did. I guess I will be here for a few more weeks. :'( Thanks again for all of your help. anj Can you delete this? <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
emailanj Posted August 10, 2005 Author Share Posted August 10, 2005 I guess you can't delete this one. Thats ok because I'LL just start from square one again. Appears my mysq doesn't have a place were you can change the user name and password just just delete it. What a Big mistake I made, but my cart was broken anyway. I was soooo close to being ok to go live.... Please for any of you newbies out there don't do what I did. I guess I will be here for a few more weeks. :'( Thanks again for all of your help. anj Can you delete this? <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
shaunklink Posted August 11, 2005 Share Posted August 11, 2005 for others looking through the forum, can you please post what you might have done to cause this? Link to comment Share on other sites More sharing options...
emailanj Posted August 11, 2005 Author Share Posted August 11, 2005 You, know I still have no Idea. It was something I must have done about a week ago because when I reinstalled a back up I had the problem was still there. I was unable to get any awnsers. I did how ever find out you can change your mysql database name password etc. Its a little complex but can be done. You have to be careful to make sure you change it in the admin/includes config.php as well as the includes config.php Sorry I could not be of more help anj. for others looking through the forum, can you please post what you might have done to cause this? <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Guest Posted August 11, 2005 Share Posted August 11, 2005 try adding this as previously i had similiar issue from customer who can't add products to cart. hope this helps: define('HTTP_COOKIE_PATH', 'www.domain.com'); define('HTTPS_COOKIE_PATH', 'www.domain.com'); Link to comment Share on other sites More sharing options...
emailanj Posted August 14, 2005 Author Share Posted August 14, 2005 OK...I have started from square one and have gotten to the point again of running a test and I am getting this error again: 1062 - Duplicate entry '9f9006a7ad97cbe0896888e150694266' for key 1 insert into sessions values ('9f9006a7ad97cbe0896888e150694266?ssl_result=1', '1124058561', '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:45:\"9f9006a7ad97cbe0896888e150694266?ssl_result=1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') [TEP STOP] 1062 - Duplicate entry '9f9006a7ad97cbe0896888e150694266' for key 1 insert into sessions values ('9f9006a7ad97cbe0896888e150694266?ssl_result=1', '1124058561', '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:45:\"9f9006a7ad97cbe0896888e150694266?ssl_result=1\";}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 Although a little different than before. It happened this time right after I clicked confirm order and then it kicked me out to login again. I have tried all the suggestions but nothing has worked so far. Thanks for everyones time any and all help... anj try adding this as previously i had similiar issue from customer who can't add products to cart. hope this helps: define('HTTP_COOKIE_PATH', 'www.domain.com'); define('HTTPS_COOKIE_PATH', 'www.domain.com'); <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
emailanj Posted August 15, 2005 Author Share Posted August 15, 2005 Please.......Help me :'( OK...I have started from square one and have gotten to the point again of running a test and I am getting this error again: 1062 - Duplicate entry '9f9006a7ad97cbe0896888e150694266' for key 1 insert into sessions values ('9f9006a7ad97cbe0896888e150694266?ssl_result=1', '1124058561', '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:45:\"9f9006a7ad97cbe0896888e150694266?ssl_result=1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') [TEP STOP] 1062 - Duplicate entry '9f9006a7ad97cbe0896888e150694266' for key 1 insert into sessions values ('9f9006a7ad97cbe0896888e150694266?ssl_result=1', '1124058561', '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:45:\"9f9006a7ad97cbe0896888e150694266?ssl_result=1\";}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 Although a little different than before. It happened this time right after I clicked confirm order and then it kicked me out to login again. I have tried all the suggestions but nothing has worked so far. Thanks for everyones time any and all help... anj <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
emailanj Posted August 15, 2005 Author Share Posted August 15, 2005 Anyone....Please.....Pretty please..... :blush: I have been looking every were, OSC docments, searched the form, looked on my hosts help quide and in there q+a form and I have found nothing....I am at your mercy, general support board....Please at least if I know that no one knows I can dump my whole cart again and start fresh, I am getting pretty good with all of my practice ;) I don't know why though I have had this problem twice in a row. anj Please.......Help me :'( <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Rob123 Posted August 15, 2005 Share Posted August 15, 2005 Go into your phpmyadmin, and run the following in the sql window.truncate table sessions; <{POST_SNAPBACK}> See Post #2 HTH, Robert Link to comment Share on other sites More sharing options...
OceanRanch Posted August 15, 2005 Share Posted August 15, 2005 Try turning SSL off and see if that makes a difference. Your settings for SSL in your configure.php files may not be correct for your setup. Also you may need to check all of the admin->configuration->sessions values and toggle a few true/false. Doing that over the forum a question at time is and will take lots of time (as you have seen). HTH Tom Link to comment Share on other sites More sharing options...
emailanj Posted August 15, 2005 Author Share Posted August 15, 2005 Thanks your for your response..I did do what is instructed in post #2 but nothing happened. Could you please advise what the purpose of this is and what I should be looking for so I can be sure I am doing it correctly? Thank you so very much again, anj See Post #2 HTH, Robert <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
emailanj Posted August 15, 2005 Author Share Posted August 15, 2005 Please....does anyone know what is supposed to happen when you Go into your phpmyadmin, and run the following in the sql window.truncate table sessions; I did this but nothing happened and I am not sure what to look for...It does seem to be the key to fixing my problem.....I hope :blush: Anj See Post #2 HTH, Robert <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
shaunklink Posted August 15, 2005 Share Posted August 15, 2005 TRUNCATE TABLE empties a table completely. Logically, this is equivalent to a DELETE statement that deletes all rows, but there are practical differences under some circumstances. http://dev.mysql.com/doc/mysql/en/truncate.html sorry, never used this function, nor have I had any errors like yours.....this was just on the mysql site Link to comment Share on other sites More sharing options...
shaunklink Posted August 15, 2005 Share Posted August 15, 2005 the only thing I can think logically about truncate the table "sessions" is that there must be a problem with the sessions being stored into your database. are you storing sessions in your DB? I think there is an option to turn it off... try that..... (are you supposed to store them? I don't) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.