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?
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.
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.

Who is online
Users browsing this forum: No registered users and 25 guests