Positive lead to the problem

This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=226784#226784
----------------------------------------------------------------

Linda,

The only sessions that stack and cannot be deleted are bot sessions.

I mistook several layers of bots for customers sessions

NOTE!
All bot sessions / stacks of bots have no session ID and session expired shopping carts.

From PHPAdmin modify the problem session table entry and insert a session id.
Here you can see I just added loads of the letter 'c'

customer_id  click_id  full_name  session_id  ip_address  time_entry  time_last_click  last_page_url  page_desc  
0 NULL Guest ccccccccccccccccccccccccc 212.222.XXX.X 1063117092 1063117092   White Grease (Heat / Water Resistant Viscostatic Grease) 

refresh the admin page so the session id shows you can then delete the entry OK (in this instance it was a single bot entry so the entire session was deleted having no more bots underneath)


A couple of other things!
This morning when I deleted a stacked session entry of bots the last session entry had 1 page view. I used method 2 to delete the session entry (not having discovered the above information yet, it deleted all sessions including legitimate customer sessions. Ouch.

Also the page URL tracking whilst listing the correct page does not contain the correct URL to that page!! Should it?

Hope some of this helps.