pony88 Posted January 15, 2007 Share Posted January 15, 2007 Hi, I've been searching for a fix for this error for days! I've tried a few and none have worked, can anybody point me in the right direction? 1054 - Unknown column 'p.products_sort_order' in 'order clause' select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '58' order by p.products_sort_order asc, pd.products_name limit 0, 20 [TEP STOP] I really need to fix this as it's an important site I'm working on which is currently live - not in testing. Any help will be much much appreciated. Tom. Link to comment Share on other sites More sharing options...
wheeloftime Posted January 15, 2007 Share Posted January 15, 2007 Hi, I've been searching for a fix for this error for days! I've tried a few and none have worked, can anybody point me in the right direction? 1054 - Unknown column 'p.products_sort_order' in 'order clause' select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '58' order by p.products_sort_order asc, pd.products_name limit 0, 20 [TEP STOP] I really need to fix this as it's an important site I'm working on which is currently live - not in testing. Any help will be much much appreciated. Tom. It looks like there has been added one of the available sort order contributions but the product table has not been updated for use with this new field. You have to go through the installation instructions for ths contribution and look where it tells the modifications needed to your database. HTH Link to comment Share on other sites More sharing options...
shashank3 Posted June 17, 2009 Share Posted June 17, 2009 It looks like there has been added one of the available sort order contributions but the product table has not been updated for use with this new field. You have to go through the installation instructions for ths contribution and look where it tells the modifications needed to your database. HTH i uploaded updated file with corrections in the contribution... Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.