Post by guidone » Tue Oct 11, 2016 2:59 pm

If you try to sort orders by Status

Image

get MySQL error:

Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'status' in 'order clause'<br />Error No: 1054<br />SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `oc_order` o WHERE o.order_status_id IS NOT NULL ORDER BY status ASC LIMIT 0,20' in /membri/opencart2/system/library/db/mysqli.php:40 Stack trace: #0 /membri/opencart2/system/library/db.php(16): DB\MySQLi->query('SELECT o.order_...', Array) #1 /membri/opencart2/vqmod/vqcache/vq2-admin_model_sale_order.php(229): DB->query('SELECT o.order_...') #2 [internal function]: ModelSaleOrder->getOrders(Array) #3 /membri/opencart2/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(150): call_user_func_array(Array, Array) #4 [internal function]: {closure}(Array) #5 /membri/opencart2/system/engine/p in /membri/opencart2/system/library/db/mysqli.php on line 40



Please Help.

User avatar
New member

Posts

Joined
Thu Mar 28, 2013 7:39 pm

Post by paulfeakins » Tue Oct 11, 2016 5:03 pm

I can see you're using 2.2.0.0 - probably best thing you can do is upgrade to 2.3.0.2.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by guidone » Tue Oct 11, 2016 5:08 pm

No way, too many Extensions and Mod installed on my 2.2. Every Opencart vaersion has is bug, so better to choose a version and fix one by one.
Someone can help me with this one?

User avatar
New member

Posts

Joined
Thu Mar 28, 2013 7:39 pm

Post by guidone » Tue Oct 11, 2016 6:19 pm

Ok Fixed:

file /admin/controller/sale/order.php

Code: Select all

find:

$data['sort_status'] = $this->url->link('sale/order', 'token=' . $this->session->data['token'] . '&sort=status' . $url, true);

correct:
$data['sort_status'] = $this->url->link('sale/order', 'token=' . $this->session->data['token'] . '&sort=order_status' . $url, true);
hope this helps someone else.

User avatar
New member

Posts

Joined
Thu Mar 28, 2013 7:39 pm
Who is online

Users browsing this forum: No registered users and 3 guests