Post by cluv » 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.

Newbie

Posts

Joined
Wed Jul 22, 2009 1:59 pm

Post by WCNZ » Fri Jul 24, 2009 8:11 am

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

New member

Posts

Joined
Mon Mar 24, 2008 11:21 am
Who is online

Users browsing this forum: No registered users and 10 guests