Orders not showing up, order numbers don't match

[MangoSmuggler]

Hope someone can help me with this...

My orders are not showing up in the Admin-->Customers-->Orders. I'm showing that there are Pending and Processing orders in the Admin home page, but can't see them when I click on them.

I made some test purchases and got some weird results: For example the order confirmation on the web page is 2147483654, but the email confirmation is -2147483642. (Yes, it's a negative number!). The next order would be 2147483655 on the web page, but the ocnfirmation email will show -2147483641.

The order history page for the customer account shows no orders, but shows 4 page navigation links: -4, -3, -2, -1. Negative numbers again. Clicking on any of the pages displays no orders.

I checked the database, and only test orders via the PayPal payment module show up in the database, not the Admin or Order History web pages. There is no sign of any of the non-PayPal orders.

I'm using v 1.3.8, and I used both the Classic Green template and one from templates13 called 2748.

I recently transferred the store from a different server to hostgator.com and followed the instructions posted on the zen-cart site. The database imported back correctly as all the products, customers etc. are showing. Just no orders.

Has anyone else experienced this?

[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