Blank orders...
Posted: Mon Nov 02, 2020 9:38 am
Hello,
We have a serious problem, that only shows up sometimes.
Sometimes, after a few days the orders start coming in without any user details at all. The order has the products and prices, but all the user details is all blank.
Therefore we do not know how to contact the customer.
The problem is solved only after we restart the server.
The shop has about 70000 products, and a lot of custom fields. The database is over 700MB in size.
We sometimes do a lot of batch product imports/exports (using CSVi extension), and the problem appears sooner after that.
We upgraded our VPS package to the highest offering, and the problem improved, but it still happens. It just takes more time to appear now.
We need to find a way to troubleshoot and fix this.
Is there a log of orders that maybe contains the order information so we can check for missing data?
Is there a way to see failed orders or errors?
Do you have any suspicion on what is the problem?
Thank you
Our setup: Joomla 3.9.21, VM 3.8.4.10355, OPC 2.0.402.170920.
Our hosting: VPS with 16GB RAM, 4 cores, PHP 7.3
We have a serious problem, that only shows up sometimes.
Sometimes, after a few days the orders start coming in without any user details at all. The order has the products and prices, but all the user details is all blank.
Therefore we do not know how to contact the customer.
The problem is solved only after we restart the server.
The shop has about 70000 products, and a lot of custom fields. The database is over 700MB in size.
We sometimes do a lot of batch product imports/exports (using CSVi extension), and the problem appears sooner after that.
We upgraded our VPS package to the highest offering, and the problem improved, but it still happens. It just takes more time to appear now.
We need to find a way to troubleshoot and fix this.
Is there a log of orders that maybe contains the order information so we can check for missing data?
Is there a way to see failed orders or errors?
Do you have any suspicion on what is the problem?
Thank you
Our setup: Joomla 3.9.21, VM 3.8.4.10355, OPC 2.0.402.170920.
Our hosting: VPS with 16GB RAM, 4 cores, PHP 7.3