Guest Posted February 24, 2007 Share Posted February 24, 2007 Hobbzilla, I need help integrating the SPPC contribution with the multi stores. I modified the files with the new contribution but I'm not sure how to modify the statement for the "stores". The first error I get is when I click on any product from the index page: 1054 - Unknown column 's.stores_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials_retail_prices s on p.products_id = s.products_id and s.stores_id = '1' INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' and 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 = '25' [TEP STOP] I just don't even know where to start on this. Any help would be greatly appreciated from anyone. Thanks! Joanne 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.