marcar Posted November 2, 2020 Share Posted November 2, 2020 Attributes Products ERROR 1054 - Unknown column 'po.sort_order' in 'order clause' CE Phoenix v1.0.7.10 Link to comment Share on other sites More sharing options...
burt Posted November 2, 2020 Share 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. Link to comment Share on other sites More sharing options...
marcar Posted November 7, 2020 Author Share 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] Link to comment Share on other sites More sharing options...
marcar Posted November 7, 2020 Author Share Posted November 7, 2020 The error is present all time in all page for to show any attribute of any product of the catalog. Link to comment Share on other sites More sharing options...
♥ecartz Posted November 7, 2020 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.