Error: Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pr.sort_order' in 'ORDER BY'
Error Code : 42S22
SELECT pr.related_id FROM `oc_product_related` pr LEFT JOIN `oc_product` p ON (pr.related_id = p.product_id) WHERE pr.product_id = '10961' AND p.status = '1' AND pr.`type` = :0 ORDER BY pr.`sort_order`, pr.`related_id` File: /home3/lkvtrcom/yumakusa.com/system/library/db/pdo.php Line: 99 Backtrace: 0 File: /home3/lkvtrcom/yumakusa.com/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\PDO Function: query Backtrace: 1 File: /home3/lkvtrcom/yumakusa.com/catalog/controller/product/product.php Line: 845 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home3/lkvtrcom/yumakusa.com/catalog/controller/product/product.php Line: 658 Class: Opencart\Catalog\Controller\Product\Product Function: getRelatedProducts Backtrace: 3 File: /home3/lkvtrcom/yumakusa.com/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Product Function: index Backtrace: 4 File: /home3/lkvtrcom/yumakusa.com/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 5 File: /home3/lkvtrcom/yumakusa.com/index.php Line: 20 Function: require_once