Nikki2249 0 Posted September 15, 2010 Just installed the Printable Catalog V 2.6. Demo looked great and this contrib would be great for my store. However, When I open the page, I get the following: 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id 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 cd.language_id = '1' order by pd.products_name, cd.categories_name Anybody got an idea of what I need to do to correct this, or what information needs to be changed in the sql queries. Would really appreciate. Thanks Nikki Share this post Link to post Share on other sites
