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

[emailanj]

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

[wizardsandwars]

Go into your phpmyadmin, and run the following in the sql window.

 

 

truncate table sessions;

[emailanj]

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}>

[FalseDawn]

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"

[emailanj]

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}>

[emailanj]

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}>

[Guest]

in your configure.php file, what do you have set for store sessions? is it set to mysql?

[emailanj]

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}>

[Guest]

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

[emailanj]

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}>

[emailanj]

Can you delete this?

 

 

Great...Blew it again... :'(

 

Thanks.

anj

<{POST_SNAPBACK}>

[emailanj]

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}>

[emailanj]

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}>

[shaunklink]

for others looking through the forum, can you please post what you might have done to cause this?

[emailanj]

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}>

[Guest]

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

[emailanj]

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}>

[emailanj]

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}>

[emailanj]

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}>

[Rob123]

Go into your phpmyadmin, and run the following in the sql window.

truncate table sessions;

<{POST_SNAPBACK}>

 

 

See Post #2

 

HTH,

Robert

[OceanRanch]

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

[emailanj]

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}>

[emailanj]

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}>

[shaunklink]

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

[shaunklink]

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)