Orders products problems

[spottedhaggis]

Hi all.

 

Last month all was running well, what database errors I had were repaired thanks to Frank.

 

For some reason now, when you order multiple items, and checkout, the total money is all correct, however, the checkout success page, the customer account invoice view and the orders in admin page all show the correct total, but are missing all but one item from the list of items pourchased.

 

when I check the database I can clearly see where the issue is.

 

In the table Orders_products I can see the order ID of the product that is correctly listed, as being say 50, but all other products which are listed here, show an order id that is incremental from 239 upwards.

 

I cannot seem to figure out how this can happen when its been going fine for the past month.

 

The only thing today was the client mentioned that stock was not being taken away from the tcok value when a purchase was made, but in admin it was all set to true, so I simply set it to false, and update, then straight away set it to tru and update again.

 

This repaired that issue, and since then we seem to have this issue, but so far as I can make out the two are completely unrelated.

 

At the moment the only way to fix it is to manually change the database entry, but this does not stop the customer from pannicing about her having paid for several items but only one being listed?

 

Can anyone help me with this issue.

[spottedhaggis]

Hi all,

 

ok the issue appears to be the auto incremental number for Orders_Products. It is currently set to 245 when in actual fact it should be 200 less tha it is now.

 

I tried using phpmysqladmin to change it, through operations, but for some reason it will not change, it says the query has run ok but no change.

 

I have to be missing something, anyone able to pin poiint it for me