help - order number problems after upgrade

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

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?

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?

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

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

Kim:

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

:clap::clap::clap:

Chrome Orange:

ok it seems that my orders table needed the orders id to be set to autoincrementYes, 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.

Chrome Orange:

and I needed to add and orders_id field to the beginning of the $sql_data_arrayDepending on your module, that may or may not matter much.