[1.3.2] order status sorting error

Quote

Post by d0tb0t » Sun Sep 06, 2009 11:17 pm

request:

Code: Select all

admin/index.php?route=customer/order&sort=os.name&order=ASC
report:

Code: Select all

Error: Unknown column 'os.name' in 'order clause'
Error No: 1054
SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS name, (SELECT os.name FROM order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS status, o.date_added, o.total, o.currency, o.value FROM `order` o WHERE o.order_status_id > '0' ORDER BY os.name ASC LIMIT 0,10
d0tb0t
Newbie
Posts
12
Joined
Wed Jun 24, 2009 2:50 am
Top

Re: [1.3.2] order status sorting error

Quote

Post by webhelpseeker » Fri Jan 15, 2010 4:34 am

Error: Unknown column 'os.name' in 'order clause'
Error No: 1054
SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS name, (SELECT os.name FROM order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS status, o.date_added, o.total, o.currency, o.value FROM `order` o WHERE o.order_status_id > '0' ORDER BY os.name ASC LIMIT 0,10 ???
webhelpseeker
Newbie
Posts
6
Joined
Thu Jan 14, 2010 12:55 pm
Top
Post Reply
Return to “Bug Reports”
Who is online

Users browsing this forum: No registered users and 28 guests