bazzeray Posted November 29, 2009 Share Posted November 29, 2009 Hi, On the template I have uploaded to http://www.sub-zeroclothing.co.uk/shop When clicking on the products such as Camcorders it comes up with the following error... 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 = '95' [TEP STOP] I have only uploaded the template and not touched anything as yet. Does anyone have any idea what could be causing this and how to fix it please? Thanks in advance for your help! :) Baz Link to comment Share on other sites More sharing options...
StarburstHosting Posted November 29, 2009 Share Posted November 29, 2009 Hi Baz Have you tried looking at this thread If you still have problems post back including PHP version and OScommerce release that you are using. HTH Rob My advice is personal and not from my company. Use it at your own risk! Rules. 1. Backup before making any changes. 2. Try one thing at a time. 3. Write down all steps you take. 4. Make any changes on a development server/domain before on a live site. 5. BACKUP Link to comment Share on other sites More sharing options...
bazzeray Posted November 29, 2009 Author Share Posted November 29, 2009 Thank you soo much! In the end I tried a few things on that topic but found the answer in the 1054-problem text file located here: http://www.oscommerce.com/community/contributions,4654 Baz :) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.