OpenCart Community

When I try to filter my orders by name, I get the following error:

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 '%tracy%'

Can anyone help?

remove the .o in the query

i think i fixed this in 1.3.0

Daniel's right: Here's how you do it

1: Open admin > model > customer > order.php
2: Go to line 148
3: change this part:

$sql .= " AND CONCAT(o.firstname, ' ', lastname)

to this

$sql .= " AND CONCAT(firstname, ' ', lastname)

That fixes the filter by name error.