chemystery Posted March 23, 2007 Posted March 23, 2007 Hi All, I am using a template with OSC and when I try to view categories I am getting this error message in the display 1054 - Unknown column 'p.products_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 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 = '61' Any clues anyone as to what is the problem?
chooch Posted March 25, 2007 Posted March 25, 2007 Some templates have bits missing. For example I used a template for a client once and I couldn't access the 'reviews' section from admin because the code was removed from the template as a review approval contribution was added but the price didn't include that mod. It was showing an error code. I copied the code from a stock osC download and voila it worked. Without knowing which page the error occurs on and what triggers it, it will be hard to help you. Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.