Shopping Cart Issue

[tdewitt274]

I've been logged into my account for some time and refreshed my browser to see the new postings. Upon Refresh, I noticed that I have 3 things in my shopping cart that I had already purchased.

I logged out of my account and then back in, still there. I closed my browser and opened the page again, still there. It's really odd because only 3 items show out of 28 from April 21 of 2006 (order number 629577).

Thought you might want to know.

[tdewitt274]

Captain's Log, Supplimental:

I forgot to say that the first time I noticed it, I edited it so that the items reflected 0 in the Shopping Cart and submitted. This got rid of them, but opening a new page still populated the issue.

Windows Vista, IE 7.0.6 (OEM)

[jthilo]

I've seen this happen as well. The problem is pretty easy to replicate:

0. Start with an empty cart.
1. Add an item to your cart.
2. Remove the item from your cart.
3. Sign out.
4. Sign in.

The item will be back in your cart. You can repeat steps 2-4 ad nauseam. The item will still be there.

[Gary Teter]

I've fixed your cart.

This week I rewrote the cart code. The old code would dump the contents of your cart after 30 days. Well, not precisely. What it would do is create a new cart, and ignore the old one. So we have 148,705 unused carts in our database (I counted). Each filled with stuff a customer wanted at some point to buy. But the code ignored all those old carts and forced people to hunt down products and add them all over again. Pointless.

The new code just uses your most recent unsubmitted cart. In your case, it dated back to April 2006 and contained stuff you subsequently re-added to a newly-created cart and submitted.

[Gary Teter]

jthilo wrote:

I've seen this happen as well. The problem is pretty easy to replicate:

0. Start with an empty cart.
1. Add an item to your cart.
2. Remove the item from your cart.
3. Sign out.
4. Sign in.

The item will be back in your cart. You can repeat steps 2-4 ad nauseam. The item will still be there.

Hmmmm. That is a separate bug, which I've never noticed and no one's ever reported before!

Investigating....

[Gary Teter]

OK, I've tracked it down. This will be fixed the next time I roll the site.

[jthilo]

Gary Teter wrote:

That is a separate bug, which I've never noticed and no one's ever reported before!

Probably because when people put things in their carts, they usually buy 'em...

As an aside, your previous post in this thread (where you talk about the thousands of unused carts) is not showing up in the thread. In case you're still hunting that particular bug. :-)

[tdewitt274]

Thanks, just thought it was wierd to see those again.

Gary Teter wrote:

So we have 148,705 unused carts in our database (I counted).

Hopefully via "SELECT Count(UniqueID) FROM tbl_ShoppingCart". If not, you're a quick count ; )

[Gary Teter]

tdewitt274 wrote:

Thanks, just thought it was wierd to see those again.

Gary Teter wrote:

So we have 148,705 unused carts in our database (I counted).

Hopefully via "SELECT Count(UniqueID) FROM tbl_ShoppingCart". If not, you're a quick count ; )

... One thousand two hundred fifty-eight shopping carts. One thousand two hundred fifty-nine shopping carts. One thousand two hundred sixty shopping carts. One thousand two hundred sixty-one... no, wait, that one's missing a wheel.

[farewell2kings]

Happened to me too. I would come back to the site and find my shopping cart filled with an order for 1 copy of "The Gamers" movie. I would change the quantity to 0, but next time I came to Paizo, it would reappear.

[farewell2kings]

It's still doing it.

[Gavgoyle]

Me too, and it's like the first three things I ever ordered from Paizo. In a way, it's a bit nostalgic.

[Gary Teter]

I didn't roll the site Friday, so it won't be fixed before Tuesday (Monday's a holiday here).

[primemover003]

As of this morning My Cart still had the steelsqwire spell templates in it... I'l try to sign out and in to see if the fix took!

EDIT: It took! Huzzah!

[pedr]

Sorry to say it's still doing it for me.

I hadn't got round to mentioning it - I have mainly been adding/deleting things to/from my cart to check how much postage would be and then putting things on the 'to buy once I get my first pay-cheque of new job' list so it's not been a pressing issue.

[Vic Wertz]

pedr wrote:

Sorry to say it's still doing it for me.

I hadn't got round to mentioning it - I have mainly been adding/deleting things to/from my cart to check how much postage would be and then putting things on the 'to buy once I get my first pay-cheque of new job' list so it's not been a pressing issue.

Try removing them again.