Error 1054 Attributes products ORDER CLAUSE CE Phoenix v1.0.7.10

[marcar 0]

Attributes Products ERROR 1054 - Unknown column 'po.sort_order' in 'order clause' CE Phoenix v1.0.7.10

[burt 5,421]

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.
 

[marcar 0]

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]

[marcar 0]

The error is present all time in all page for to show any attribute of any product of the catalog. 

 

[♥ecartz 681]

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.