I did exactly what ZenCart warned me not to do here:
http://www.zen-cart.com/content.php?...fferent-server
The previous database (1.3.9) contained over 10,000 orders. The current database (moved from the old host, upgraded to 1.5.4) is not properly recording new orders. I get the following error in the logs:
PHP Fatal error: 1062uplicate entry '0' for key 'PRIMARY' :: INSERT INTO zen_orders
It appears that a new entry into orders_id is not being generated. The first order after the move was assigned orders_id 0 (zero) for the following tables (but not orders_id):
orders
orders_products
orders_products_attributes
orders_status_history
orders_total
I doubt there is a simple fix to this problem. That being said, might I want to start the order history over (dropping table info)? Or would that just make matters worse.
I'm willing to take any advice to fix (and scolding for doing what should not have been done).
Thanks in advance,
Sean
+<|:-)
Bookmarks