OpenCart Community

Are you saying to download all the master files (done that)

and then FTP files over current Admin directory?

BillK wrote: ↑

Sat Jun 16, 2018 5:20 pm

Here's what I've found so far with this issue:

The statistics/addOrderHistory() function shows that it should be triggered by the model/checkout/order/addOrderHistory/before event, but the trigger is set to model/checkout/order/addOrderHistory/after.
It is getting triggered after the order is already saved, so when the function checks if the new order_status_id is different from the saved order_status_id it doesn't do anything because it thinks that order status didn't change.

After updating the the statistics_order_history row in oc_event and changing the trigger to catalog/model/checkout/order/addOrderHistory/before, I then had to change the addOrderHistory function in catalog/controller/event/statistics.php from

Code: Select all

public function addOrderHistory(&$route, &$args, &$output) {

to

Code: Select all

public function addOrderHistory(&$route, &$args) {

It's still buggy but at least its updating the oc_statistics table now. If I get it working better I will post my updates here.

Thanks

countzer0 wrote: ↑

Fri Oct 19, 2018 5:10 pm

For anyone applying this fix, you'll want to update the oc_statistics table with the order_status counts. You can get these using the following query:

Code: Select all

SELECT o.order_status_id, COUNT( o.order_status_id ) AS total, os.name
FROM oc_order o
LEFT JOIN oc_order_status os ON ( o.order_status_id = os.order_status_id ) 
GROUP BY o.order_status_id

SELECT o.order_status_id, COUNT(o.order_status_id) AS total, os.name
FROM `" . DB_PREFIX . "order` o
LEFT JOIN `" . DB_PREFIX . "order_status` os ON (o.order_status_id = os.order_status_id) 
GROUP BY o.order_status_id

#1146 - Table ' mytable" . DB_PREFIX . "order' doesn't exist