Orders not showing up, order numbers don't match

[DrByte]

Those numbers are the maximum value allowed for order_id numbers. Since most people start at 1 it's normally not a problem.

So, your orders table is probably damaged. You'll probably need to reset the auto_increment to match the highest legitimate orders_id in the database.

Either that, or you mussed with the database to make your next order number show as a very long number, causing it to blow out the maximum value allowed.

[MangoSmuggler]

Those numbers are the maximum value allowed for order_id numbers. Since most people start at 1 it's normally not a problem.

So, your orders table is probably damaged. You'll probably need to reset the auto_increment to match the highest legitimate orders_id in the database.

Either that, or you mussed with the database to make your next order number show as a very long number, causing it to blow out the maximum value allowed.

Thanks... So how do I go about resetting the the auto_increment? Can I change the order number to something lower? (None of the orders so far are real orders, just test orders)

Thanks again...

[DrByte]

If none of your orders are legitimate, then do the following.

NOTE: **BOTH** steps are required:

1. Use your admin area to delete all orders. Yes, that means clicking on each one, one-by-one, and clicking the Delete button.
2. After they're ALL deleted via the admin, run this command in Admin->Tools->Install SQL Patch:

truncate table orders;

**** NOTE: DO NOT DO STEP #2 UNTIL YOU HAVE DONE STEP #1 FIRST ****


After that, your next order should start at 1 again.
Test 2 or 3 orders, and make sure the numbers count up correctly.

[MangoSmuggler]

If none of your orders are legitimate, then do the following.

NOTE: **BOTH** steps are required:

1. Use your admin area to delete all orders. Yes, that means clicking on each one, one-by-one, and clicking the Delete button.
2. After they're ALL deleted via the admin, run this command in Admin->Tools->Install SQL Patch:

truncate table orders;

**** NOTE: DO NOT DO STEP #2 UNTIL YOU HAVE DONE STEP #1 FIRST ****


After that, your next order should start at 1 again.
Test 2 or 3 orders, and make sure the numbers count up correctly.

Thanks... However none of the orders displays in the Admin area, can I just go ahead and run the SQL truncate? Thanks. Can I just delete all the records in the following databases from myPHPadmin?

files_uploaded
orders *
orders_products *
orders_products_attributes *
orders_products_download *
orders_status_history
orders_total *

[DrByte]

Sure, but I think your problems are way more serious than that.
Based solely on what you described thus far, I anticipate that you'll have problems with registering new customers, and placing new orders, and more.

Did you change MySQL versions between servers?

[MangoSmuggler]

I had a look at the SQL servers from the old server and the new one and you're right, old server was 4.1.22 and new one is 5.1.30. I guess I need to upgrade to 1.3.9 of the cart and reset the database. I could just import the product info, right?

Thanks for your info, it's much appreciated.

[DrByte]

Part of the formal upgrade instructions includes upgrading your complete database. That way your data is retained during the upgrade process.
https://www.zen-cart.com/tutorials/index.php?article=98