Forum OpenACS Q&A: Re: Ecommerce 4.6.3+, new users lose basket contents on sign-up

User perspective:

User gets to: http://dekka.com
# no cookies

http://dekka.com:8000/
# cookie: ad_session_id
#   content: 800004%2c0%20%7b338%201076140096%20BF3FBA239412D27D173D25D7670E4B3FB9949A75%7d
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: 02/06/04 23:50:06
#   policy: no policy..

# click link to dekka.com:8000/ecommerce/
http://dekka.com:8000/ecommerce/?usca%5fp=t
# cookie: ad_session_id
#   content: 800004%2c0%20%7b338%201076140096%20BF3FBA239412D27D173D25D7670E4B3FB9949A75%7d
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: 02/06/04 23:50:06
#   policy: no policy..
# cookie: user_session_id
#   content: 281
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: at end of session
#   policy: no policy..

# click link to view category
http://dekka.com:8000/ecommerce/category-browse?category_id=1
# cookie: ad_session_id
#   content: 800004%2c0%20%7b342%201076141032%20E53A12ADF0D0272F7274D8482892D79F8451BAAB%7d
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: 02/07/04 00:05:50
#   policy: no policy..
# cookie: user_session_id
#   content: 281
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: at end of session
#   policy: no policy..

# click on item link: http://dekka.com:8000/ecommerce/product?product_id=3560
http://dekka.com:8000/ecommerce/product?product_id=3560
# cookie: ad_session_id
#   content: 800004%2c0%20%7b342%201076141032%20E53A12ADF0D0272F7274D8482892D79F8451BAAB%7d
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: 02/07/04 00:05:50
#   policy: no policy..
# cookie: user_session_id
#   content: 281
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: at end of session
#   policy: no policy..

# click "add to cart" button
http://dekka.com:8000/ecommerce/shopping-cart?product%5fid=3560
# cookie: ad_session_id
#   content: 800004%2c0%20%7b342%201076141032%20E53A12ADF0D0272F7274D8482892D79F8451BAAB%7d
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: 02/07/04 00:05:50
#   policy: no policy..
# cookie: user_session_id
#   content: 281
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: at end of session
#   policy: no policy..

# click "Proceed to checkout" button
https://dekka.com:8443/ecommerce/register/index?return_url=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout&http_id=0&user_session_id=281
# cookie: ad_session_id
#   content: 800004%2c0%20%7b401%201076141378%2070A9AAF4657275EEE47FF067523122903462491B%7d
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: 02/07/04 00:11:28
#   policy: no policy..
# cookie: user_session_id
#   content: 281
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: at end of session
#   policy: no policy..

#entered new user info (email address, password), clicked "submit"
https://dekka.com:8443/ecommerce/register/user-new?email=user36%40dekka%2enet&persistent%5fcookie%5fp=1&return%5furl=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout
# cookie: ad_session_id
#   content: 800004%2c0%20%7b401%201076141378%2070A9AAF4657275EEE47FF067523122903462491B%7d
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: 02/07/04 00:11:28
#   policy: no policy..
# cookie: user_session_id does not exist

# entered user info (verified password, entered first_names, last_name, cusotmized question/answer), clicked "register" button
https://dekka.com:8443/ecommerce/index
# cookie: ad_session_id
#   content: F4657275EEE47FF067523122903462491B%7d
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: 02/07/04 00:11:28
#   policy: no policy..
# cookie: user_session_id
#   content: 282
#   host: dekka.com
#   path: /
#   server secure: no
#   expires: at end of session
#   policy: no policy..

service0.log perspective:

24.20.69.247 - - [07/Feb/2004:07:28:16 +0000] "GET / HTTP/1.1" 200 15768 "http://www.dekka.com/" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:28:20 +0000] "GET /lists.css HTTP/1.1" 304 0 "http://dekka.com:8000/" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:31:20 +0000] "GET /ecommerce/ HTTP/1.1" 302 318 "http://dekka.com:8000/" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:31:21 +0000] "GET /ecommerce/?usca%5fp=t HTTP/1.1" 200 18433 "http://dekka.com:8000/" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:31:21 +0000] "GET /lists.css HTTP/1.1" 304 0 "http://dekka.com:8000/ecommerce/?usca%5fp=t" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:44:00 +0000] "GET /ecommerce/category-browse?category_id=1 HTTP/1.1" 200 16234 "http://dekka.com:8000/ecommerce/?usca%5fp=t" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:44:01 +0000] "GET /lists.css HTTP/1.1" 304 0 "http://dekka.com:8000/ecommerce/category-browse?category_id=1" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:46:38 +0000] "GET /ecommerce/product?product_id=3560 HTTP/1.1" 200 16849 "http://dekka.com:8000/ecommerce/category-browse?category_id=1" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:46:39 +0000] "GET /lists.css HTTP/1.1" 304 0 "http://dekka.com:8000/ecommerce/product?product_id=3560" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:48:10 +0000] "POST /ecommerce/shopping-cart-add HTTP/1.1" 302 338 "http://dekka.com:8000/ecommerce/product?product_id=3560" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:48:11 +0000] "GET /ecommerce/shopping-cart?product%5fid=3560 HTTP/1.1" 200 16466 "http://dekka.com:8000/ecommerce/product?product_id=3560" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:48:11 +0000] "GET /lists.css HTTP/1.1" 304 0 "http://dekka.com:8000/ecommerce/shopping-cart?product%5fid=3560" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:49:38 +0000] "POST /ecommerce/checkout HTTP/1.1" 302 419 "http://dekka.com:8000/ecommerce/shopping-cart?product%5fid=3560" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:49:39 +0000] "GET /ecommerce/register/index?return_url=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout&http_id=0&user_session_id=281 HTTP/1.1" 200 4196 "http://dekka.com:8000/ecommerce/shopping-cart?product%5fid=3560" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:49:39 +0000] "GET /lists.css HTTP/1.1" 200 5932 "https://dekka.com:8443/ecommerce/register/index?return_url=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout&http_id=0&user_session_id=281" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:52:06 +0000] "POST /ecommerce/register/user-login HTTP/1.1" 302 448 "https://dekka.com:8443/ecommerce/register/index?return_url=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout&http_id=0&user_session_id=281" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:52:07 +0000] "GET /ecommerce/register/user-new?email=user36%40dekka%2enet&persistent%5fcookie%5fp=1&return%5furl=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout HTTP/1.1" 200 3666 "https://dekka.com:8443/ecommerce/register/index?return_url=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout&http_id=0&user_session_id=281" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:52:08 +0000] "GET /lists.css HTTP/1.1" 304 0 "https://dekka.com:8443/ecommerce/register/user-new?email=user36%40dekka%2enet&persistent%5fcookie%5fp=1&return%5furl=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:56:08 +0000] "POST /ecommerce/register/user-new-2 HTTP/1.1" 200 317 "https://dekka.com:8443/ecommerce/register/user-new?email=user36%40dekka%2enet&persistent%5fcookie%5fp=1&return%5furl=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:56:09 +0000] "GET /ecommerce/checkout HTTP/1.1" 302 328 "https://dekka.com:8443/ecommerce/register/user-new?email=user36%40dekka%2enet&persistent%5fcookie%5fp=1&return%5furl=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:56:10 +0000] "GET /ecommerce/checkout?usca%5fp=t HTTP/1.1" 302 314 "https://dekka.com:8443/ecommerce/register/user-new?email=user36%40dekka%2enet&persistent%5fcookie%5fp=1&return%5furl=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:56:11 +0000] "GET /ecommerce/index HTTP/1.1" 200 18571 "https://dekka.com:8443/ecommerce/register/user-new?email=user36%40dekka%2enet&persistent%5fcookie%5fp=1&return%5furl=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"
24.20.69.247 - - [07/Feb/2004:07:56:12 +0000] "GET /lists.css HTTP/1.1" 304 0 "https://dekka.com:8443/ecommerce/index" "Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030727"

serivce0-error.log perspective:

[07/Feb/2004:07:28:16][45130.139844608][-conn2-] Notice: Security: 1076138896 sec_generate_session_id_cookie setting 800004, 0.
[07/Feb/2004:07:31:20][45130.143695872][-conn1-] Notice: Huh? redirecting: http://dekka.com:8000/ecommerce/?usca%5fp=t
[07/Feb/2004:07:43:52][45130.143695872][-conn1-] Notice: Security: 1076139832 sec_generate_session_id_cookie setting 800004, 0.
[07/Feb/2004:07:48:10][45130.145106944][-conn3-] Notice: Huh? redirecting: http://dekka.com:8000/ecommerce/shopping-cart?product%5fid=3560
[07/Feb/2004:07:48:10][45130.139866112][-conn4-] Notice: LARS: counter = 0 ; this_row? 0 ; next_row? 0
[07/Feb/2004:07:49:38][45130.145106944][-conn3-] Notice: Security: 1076140178 sec_generate_session_id_cookie setting 800004, 0.
[07/Feb/2004:07:49:38][45130.145106944][-conn3-] Notice: Huh? redirecting: https://dekka.com:8443/ecommerce/register/index?return_url=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout&http_id=0&user_session_id=281
[07/Feb/2004:07:52:05][45130.145106944][-conn3-] Notice: user_session_id cookie expired
[07/Feb/2004:07:52:06][45130.145106944][-conn3-] Notice: Huh? redirecting: https://dekka.com:8443/ecommerce/register/user-new?email=user36%40dekka%2enet&persistent%5fcookie%5fp=1&return%5furl=https%3a%2f%2fdekka%2ecom%3a8443%2fecommerce%2fcheckout
[07/Feb/2004:07:56:06][45130.145106944][-conn3-] Notice: Security: 1076140566 sec_generate_session_id_cookie setting 800004, 0.
NOTICE:  identifier "acs_object__initialize_attributes" will be truncated to "acs_object__initialize_attribut"
NOTICE:  Adding missing FROM-clause entry for table "acs_object_id_seq"
NOTICE:  identifier "acs_object_type_get_tree_sortkey" will be truncated to "acs_object_type_get_tree_sortke"
NOTICE:  identifier "acs_object_type_get_tree_sortkey" will be truncated to "acs_object_type_get_tree_sortke"
NOTICE:  identifier "acs_permission__grant_permission" will be truncated to "acs_permission__grant_permissio"
NOTICE:  identifier "acs_permission__grant_permission" will be truncated to "acs_permission__grant_permissio"
[07/Feb/2004:07:56:08][45130.145106944][-conn3-] Notice: Security: 1076140568 sec_generate_session_id_cookie setting 800004, 3679.
[07/Feb/2004:07:56:08][45130.145106944][-conn3-] Notice: Huh? redirecting: https://dekka.com:8443/ecommerce/checkout
[07/Feb/2004:07:56:09][45130.139866112][-conn4-] Notice: Huh? redirecting: https://dekka.com:8443/ecommerce/checkout?usca%5fp=t
[07/Feb/2004:07:56:10][45130.143695872][-conn1-] Notice: Huh? redirecting: https://dekka.com:8443/ecommerce/index