marleenverbeek Posted October 5, 2009 Share Posted October 5, 2009 Hello, I have the all products add on installed on my webshop. It works, but if you click on "price" (so that it will order the products on price) it gives an error message. This is the message: 1054 - Unknown column 'final_price' in 'order clause' This is whole message: All Products All our Products A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z All Products 1054 - Unknown column 'final_price' in 'order clause' select p.products_id, products_weight, p.products_quantity, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where pd.products_name like '%' AND p.products_status='1' order by final_price , pd.products_name limit 0, 20 [TEP STOP] Does anybody know how ti fix this? My website is online already: www.willy-condoms.com Thanks in advance, Marleen Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.