marcar 0 Posted November 2, 2020 Attributes Products ERROR 1054 - Unknown column 'po.sort_order' in 'order clause' CE Phoenix v1.0.7.10 Share this post Link to post Share on other sites
burt 5,437 Posted November 2, 2020 Not enough information. Is this a new install? Is this an update of an older version? On what page does this error message show? What steps did you take to make the error message show. And so on. Everytime you ask for help, you must make it so that those who are willing to help you...can help you. Help shape the future of Phoenix; join the Phoenix Club Share this post Link to post Share on other sites
marcar 0 Posted November 7, 2020 Hi, Burt Thank you for answer me, Champion, is a clean new installation V1.0.7.10. The error is present in all pages for to show attributes of any products of the catalog the web page report: 1054 - Unknown column 'po.sort_order' in 'order clause' SELECT DISTINCT po.products_options_id, po.products_options_name FROM products_options po INNER JOIN products_attributes patrib ON patrib.options_id = po.products_options_id WHERE patrib.products_id = 14 AND po.language_id = 2 ORDER BY po.sort_order, po.products_options_name[TEP STOP] Share this post Link to post Share on other sites
marcar 0 Posted November 7, 2020 The error is present all time in all page for to show any attribute of any product of the catalog. Share this post Link to post Share on other sites
♥ecartz 696 Posted November 7, 2020 You are using the 1.0.7.10 code with an older database. In particular, you are missing this change: https://github.com/gburton/CE-Phoenix/commit/81969c8891924ec281eb3ca26fb81d4946a7fa7d#diff-8e2028966f44d325bd969e19422a5e50d0ab727fa158192adddeaca0e5345e20 So either add the sort_order field to the proper tables (in something like phpMyAdmin) or reinstall. Always back up before making changes. Share this post Link to post Share on other sites