Guest Posted January 23, 2004 Share Posted January 23, 2004 Hello.. can you help me? I`ve installed the Product_Sort contribution and it works absolutelt perfect for me, except when I try I want to sort by price in a productlist. Then I get the following error.. 1109 - Unknown table 'pd.products_namep' in order clause select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_sort_order, 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 = '4' and p2c.categories_id = '21' order by final_price , pd.products_namep.products_sort_order, pd.products_name limit 0, 20 [TEP STOP] Of course the table 'pd.products_namep' doesn`t exist.. But I don`t know in which file and where I made this script-error .. Can you help me please Thanks a lot ! Link to comment Share on other sites More sharing options...
241 Posted January 23, 2004 Share Posted January 23, 2004 You are indeed missing a , try a search of your files for pd.products_namep then add in your , space between e and p No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2004 Share Posted January 23, 2004 Hi Steve ! I did in the search option in dreamweaver.. but did not find it ! can i search any other way that you know?? thx Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2004 Share Posted January 23, 2004 any idea? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.