How to reset Order ID backward

[wadeng]

I've set the Order ID to it's maximum value (signed interger).

Since the order ID in my previous store is in integer...

Now my zen cart store can't make any new order and error "Duplicated Key" is shown.

Please advise how to reset this order ID backward. Thanks.

[DrByte]

how many records are in your orders table?

[Scott_A2A]

I have the exact same problem. I am just about to launch the store, and did a Reset Order ID to a 14 digit number. The next number was 2147483647, and the following generated an error due to it being a duplicate.

I went into my SQL admin and changed all references to 2147483647 to a lower number, like 10 (I only have 6 test orders so far). The problem is no matter what I do, the next order is again 2147483647.

I've tried setting the number lower in SQL and running the RESET ORDER ID in STORE MANAGER again 1 number ahead, but it's not working.

Is there any way I can just reset this order number to 0 and from there I can set it to whatever I need?

Scott.

[DrByte]

Truncate all tables related to orders. That will wipe out all order history, so be sure that's what you really want to do.

http://www.zen-cart.com/wiki/index.p...#Order_History

[pcspot]

DrByte,

please assist - how do u truncate - which tables (all of them listed in the link under orders?). pleas ehelp...same problem here as well.

[DrByte]

Truncate is equivalent to the "Empty" option in phpMyAdmin.

[TimBaloo]

Hi,

I've got the same problem...

I 've tried to empty impacted tables (zen_orders ...) as you said DrByte but when i test a new command, the number is always 2147483647..

Is there another table to impact or maybe using fix cache key to solve this ???

Thanks in advance for any clue or help

[TimBaloo]

Ok found it,

after emptying orders tables you must also change the auto_increment in th db :"ALTER TABLE zen_orders AUTO_INCREMENT = 50" (if you want to restart your id from 51...)

[DrByte]

Using the "delete" option should "truncate" the tables, and automatically reset the auto-increment counter. It also does some housekeeping and is a more efficient "cleaning" than doing mass deletes.

If you simply deleted numerous records, that will not reset the auto-incrementer, and thus you'd have to do that part manually as you indicated.

[TimBaloo]

Okay, did not know the difference, but i'll use it !

Thanks for the information DrByte