Jump to content
marcar

Error 1054 Attributes products ORDER CLAUSE CE Phoenix v1.0.7.10

Recommended Posts

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

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

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

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×