Reports/Customers/Orders fail 1.5.2.1

[olimax]

I moved this up from general support as I couldn't get anyone else to confirm this before posting to Google Code Issues

This is completely reproducible
I am running a fresh install of 1.5.2.1 will all vqmods disabled

Sign in as Customer
Add product to cart
Go to checkout
Go through steps 1-5

Without clicking Confirm Order look in Admin: Reports/Customers/Orders
The order is there already though not under Sales/Orders or anywhere else

It gets worse
Now, back on the front end, without confirming the order, go back to any previous stage and MODIFY
Now go through each steps except 6 again

If you now look in Reports/Customers/Orders there are now 2 orders!

Can someone else confirm that this is the case too

[williamjay]

Hi,

Yes, definitely confirmed, each time an unconfirmed order is modified that creates a new Order entry and leaves the other ones set to status_id = 0 in the Orders table, or abandoned as it were. This is different from the buggy Reports generation, (which allowed you to see them), it's a flaw in business logic because we get gaps in our Order Numbers. Many users will never see those because the reports query is supposed to get orders with status_id >0, which makes a kind of sense...

This is an issues with Orders entry into the db, the bugs in Reports/Customers/Orders that I've found are that it fails to generate the reports properly to display All Statuses. Had to do some tweaks in the template and controller files to get it to work and in the Reports/Products/Purchased as well. There seems to be some issues with 0 and NULL and "" empty set text entries ...

[straightlight]

Here.

[olimax]

Many thanks for that
but it doesnt fix the issue for me at all

I hope someone is going to be address this in the next version

[williamjay]

For sure,

Having gaps in the Order Numbers leaves us wondering where the "lost" orders might be . . .

[williamjay]

maybe in here ??
viewtopic.php?f=121&t=9192

[williamjay]

Here, use this to fix that issue, a customer can get to Confirm Order, any number of times, (go back and shop some more, Modify Shipping or Payment details any number of times), etcetera . . . and the same temp order_id will be used for the whole session, until Logout, then the order may be deemed abandoned.

This vQmod will suppress the generation of most of those non-sequential Order Numbers!

viewtopic.php?f=121&t=9192

[olimax]

that did the trick
many thanks