Does anyone know how to fix this problem? On the Customers >> Orders
I use the filter on this page with a Customer Name value. With any Customer Name value it returns this URL:
shop/admin/index.php?route=customer/order&filter_name=Doug
And returns the following statement on a blank white page:
Error: Unknown column 'o.firstname' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `order` WHERE order_status_id > '0' AND CONCAT(o.firstname, ' ', lastname) LIKE '%Doug%'
Is there a fix for this?
Also, the Order ID is non-functional, no error, just no response from applying filter with any Order ID values.
However, Status, Date Added, and Total work just fine with any values, the filter works great and returns information.
Any help is greatly appreciated.
Exactly the same issue with me - I've just discovered it. I have only one order, and I'm running version 1.2.9
Any known fixes?
UPDATE: Go here for a fix to the filter by name problem: http://forum.opencart.com/viewtopic.php ... 645#p24645
Any known fixes?
UPDATE: Go here for a fix to the filter by name problem: http://forum.opencart.com/viewtopic.php ... 645#p24645
Who is online
Users browsing this forum: No registered users and 10 guests