200 new orders missing in database but showing on admin oc 2.3
Posted: Sat Dec 09, 2023 7:18 am
Hi
I am doing an upgrade for a client from 2.3 to 3.x so I took backup and uploaded it on my server, later I noticed that there is a huge difference in number of orders and last order is showing for few months ago.
I first thought I lost the data during backup or upgrading process, but this wasn't the case as I checked the order table on the original store it is showing same data.
The full data is showing on the admin orders of original store 2.x and also if I use opencart backup and restore tool to export orders. But not showing in MySQL database manually.
same for customers data as well.
Can anyone help me out here what's going on.
Thanks
I am doing an upgrade for a client from 2.3 to 3.x so I took backup and uploaded it on my server, later I noticed that there is a huge difference in number of orders and last order is showing for few months ago.
I first thought I lost the data during backup or upgrading process, but this wasn't the case as I checked the order table on the original store it is showing same data.
The full data is showing on the admin orders of original store 2.x and also if I use opencart backup and restore tool to export orders. But not showing in MySQL database manually.
same for customers data as well.
Can anyone help me out here what's going on.
Thanks