Page 1 of 1

ADMIN > CUSTOMERS > ORDER > FILTER Problem.

Posted: Wed Jul 22, 2009 2:09 pm
by cluv
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.

PARTIALLY FIXED: Re: ADMIN > CUSTOMERS > ORDER > FILTER Prob

Posted: Fri Jul 24, 2009 8:11 am
by WCNZ
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