Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'ps.sort_order' in 'order clause'
Error No: 1054
SELECT SQL_CALC_FOUND_ROWS p.*,pd.*,COUNT(r.`rating`)AS reviews ,r.`rating` ,ps.`price` AS special ,p.`stock_status_id` AS stock_status ,ps.`price` AS price_sort FROM `oc_product` p RIGHT JOIN `oc_product_special` AS ps ON(p.`product_id`=ps.`product_id`) JOIN `oc_product_description` pd ON(p.`product_id`=pd.`product_id`) LEFT JOIN `oc_review` AS r ON(p.`product_id`=r.`product_id`) WHERE ((ps.`date_start`='0000-00-00' OR ps.`date_start`<='2018-11-14')AND(ps.`date_end`='0000-00-00' OR ps.`date_end`>='2018-11-14')AND(ps.`customer_group_id`=1)) AND p.`status`=1 AND pd.`language_id`=1 GROUP BY ps.`product_id` ORDER BY (p.`quantity`>0) DESC, ps.`sort_order` ASC LIMIT 0,12' in /home/d/dyson1405/daysen.ru/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/d/dyson1405/daysen.ru/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT SQL_CALC...', Array) #1 /h in /home/d/dyson1405/daysen.ru/public_html/system/library/db/mysqli.php on line 40