I have installed Opencart 2.3.0.2 and all is working fine except for when I try to run Reports > Customers > Orders. The server just hangs and I have to kill the processes in my CPanel WHM. I contacted the hosting company who are remarkably good at helping with everything and they said this:
Site hangs because its code is waiting MySQL query to complete
===
[root@server ~]# mysqladmin proc stat
+-------+------------------+-----------+------------------+---------+------+--------------
| Id | User | Host | db | Command | Time | State | Info |
+-------+------------------+-----------+------------------+---------+------+--------------
| 44547 | ppporguk_dev2019 | localhost | ppporguk_dev2019 | Query | 257 | Sending data | SELECT t.customer_id, t.customer, t.email, t.customer_group, t.status, COUNT(DISTINCT t.order_id) AS |
====
You need to check with developer why this happens.
Here's full query
====
SELECT t.customer_id, t.customer, t.email, t.customer_group, t.status, COUNT(t.order_id) AS orders, SUM(t.products) AS products, SUM(t.total) AS total FROM (SELECT c.customer_id, CONCAT(c.firstname, ' ', c.lastname) AS customer, c.email, cgd.name AS customer_group, c.status, o.order_id, SUM(op.quantity) as products, SUM(DISTINCT o.total) AS total FROM `oc_order` o LEFT JOIN `oc_order_product` op ON (o.order_id = op.order_id)LEFT JOIN `oc_customer` c ON (o.customer_id = c.customer_id) LEFT JOIN `oc_customer_group_description` cgd ON (c.customer_group_id = cgd.customer_group_id) WHERE o.customer_id > 0 AND cgd.language_id = '1' AND o.order_status_id > '0' GROUP BY o.order_id) AS t GROUP BY t.customer_id ORDER BY total DESC LIMIT 0,30
====
Can anybody here tell me what could cause this please? I have found a few posts on google related to other, different issues with running this report on earlier versions but cannot find anything to offer a solution for my issue with 2.3.0.2.
Apologies if this has been discussed/fixed but I think I have exhausted the search feature
Thanks
Robster
