Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error 1054 Attributes products ORDER CLAUSE CE Phoenix v1.0.7.10


marcar

Recommended Posts

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...