Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Oh Goodness what have I done to my site?Help pleas


emailanj

Recommended Posts

:'( 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

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

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;

Link to comment
Share on other sites

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

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"

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

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');

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 :'(

Link to comment
Share on other sites

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

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

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

Archived

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

×
×
  • Create New...