help - order number problems after upgrade

[Chrome Orange]

ok

I upgraded the shop to the latest version from 1.2.4

Customer placed order but had problems so I logged in as himand finished it. It created a new order as order number 0.

I used the 'change order number feature' and re numbered 0 to 2500. Then I created a test order to test it. the test order is order number 0 again

Where does it get the next order number from?

TIA

[DrByte]

There are a huge number of possibilities here.

What payment module are you using when doing these tests?
What addons/contributions are installed?
What customizations exist in this store?
What procedures did you follow to do the upgrade?

[Chrome Orange]

There are a huge number of possibilities here.

What payment module are you using when doing these tests?
What addons/contributions are installed?
What customizations exist in this store?
What procedures did you follow to do the upgrade?

Protx
master password, multisite and column layout
mostly just css stuff
started with a new store and added my template

trying to find where it actually creates the order. Shirley that's one page?

Thanks

[Kim]

Try check/money order to see if it is the payment

[Chrome Orange]

Try check/money order to see if it is the payment

:) I did

ok it seems that my orders table needed the orders id to be set to autoincrement and I needed to add and orders_id field to the beginning of the $sql_data_array

I'm pretty sure I've just bodged it but it's working right now.

thanks

[Kim]

[DrByte]

ok it seems that my orders table needed the orders id to be set to autoincrement

Yes, and in fact, if your orders table "lost" its auto-increment configuration, you might be advised to check out *all* your tables and make sure the appropriate ones have appropriate auto_increment settings in them.
Sometimes doing export/imports between MySQL versions will drop that setting, leaving you with odd results.

and I needed to add and orders_id field to the beginning of the $sql_data_array

Depending on your module, that may or may not matter much.