ADMIN > CUSTOMERS > ORDER > FILTER Problem.
Posted: Wed Jul 22, 2009 2:09 pm
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.
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.