orders not showing no. 2319432 ;)

[Guest]

well, I have problem with orders not showing in admin control panel nor in user account. but what the most strange thing is that all test orders I've made got the same order no. - 0. hope you got some solution for this. thanks in advance

[Guest]

forgot to mention that they're in orders in sql qith proper order numbers

[Guest]

did you import your database recently? Make sure the tables extra column maintain the orginal osc settings. The orders table should have the "extra" set to auto-increment for orders_id. Check with phpmyadmin.

[Guest]

did you import your database recently? Make sure the tables extra column maintain the orginal osc settings. The orders table should have the "extra" set to auto-increment for orders_id. Check with phpmyadmin.

well I've checked it and everything seems to be fine in extra column

[Guest]

I've noticed that orders_total_id in attributes column in orders_total is UNSIGNED:

http://img152.imageshack.us/img152/7644/ordertotalsqljf0.jpg

 

may it be the fault?

[Guest]

in admin>customers>orders when I type the order number it appears but without purchased product listed..

[Guest]

when you place an order the code flow goes through the catalog\checkout_process.php. In particular in that file:

 

  tep_db_perform(TABLE_ORDERS, $sql_data_array);
 $insert_id = tep_db_insert_id();

 

Is where the orders_id will be generated and then returned with the

$insert_id = tep_db_insert_id();

So the $insert_id var will be now used to set the orders_id column in the related orders tables.

 

Do you have customizations to that file? Something that could change that variable?