isiah Posted April 29, 2009 Share Posted April 29, 2009 I'm using oscommerce shopping and when i click on a category then a sub category i get 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 = '13' [TEP STOP] Does anyone know why i am getting this i appreciate anyone who helps. Quote Link to comment Share on other sites More sharing options...
Mchl Posted April 29, 2009 Share Posted April 29, 2009 Is there a column called `products_d` in `products` table? Moving to MySQL section Quote Link to comment Share on other sites More sharing options...
isiah Posted April 29, 2009 Author Share Posted April 29, 2009 Yes there is a column called `products_d` in `products` table? Quote Link to comment Share on other sites More sharing options...
fenway Posted April 29, 2009 Share Posted April 29, 2009 Use this: 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 = '13' Next time, don't copy code from v4 to v5. Quote Link to comment Share on other sites More sharing options...
isiah Posted April 30, 2009 Author Share Posted April 30, 2009 Im pretty new to this is there any way you could give me step by step instructions on what to do i would really appreciate it. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 30, 2009 Share Posted April 30, 2009 Im pretty new to this is there any way you could give me step by step instructions on what to do i would really appreciate it. Do what? I gave you the new query? Quote Link to comment Share on other sites More sharing options...
Mchl Posted April 30, 2009 Share Posted April 30, 2009 I think we may have a third party script issue here... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.