netphlex Posted June 28, 2009 Share Posted June 28, 2009 I am new so be gentle with me. For some reason when I click on a link in the browse by categories area I get an 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 = '33' [TEP STOP] How can this be fixed? Link to comment Share on other sites More sharing options...
lindsayanng Posted June 28, 2009 Share Posted June 28, 2009 highlight the top part of the error 1054 - Unknown column 'p.products_id' in 'on clause' then copy.. then paste into GOOGLE.. Then in the google search put : site:www.oscommerce.com/forums you will find your own answer A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!! Link to comment Share on other sites More sharing options...
Guest Posted June 28, 2009 Share Posted June 28, 2009 By any chance did you do a google search Click Me OOPS! Sorry Lindsay you beat me to it. ;) 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.