Unknown Error when User Click Categories

[Freelance GD]

I just installed OSCommerce (2.2 Release Candidate 2a + buySAFE) on my test website and also uploaded a new theme. Followed the proper procedure.

 

Everything seems to be working fine except, when user clicks categories, an unknown errors comes up

 

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'

 

I am a noob so don;t know whats causing this problem Please help me out.

 

URL: www.themp3mela.com/shop/

 

Thanking you in anticpation.

[MrPhil]

I can't seem to find this in vanilla osC, so is this from a contribution? See

osC and MySQL 5 - 1054 errors 04/30/09

http://www.oscommerce.com/forums/index.php?sho...=335136&hl=

 

You need to find the PHP code that creates this query:

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'

 

and change it to produce:

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'

 

Once you have found where this fix is needed, please go to the above link and add it to the list. Or, bug the contribution author to clean up their code.

[Freelance GD]

http://www.oscommerce.com/forums/index.php?sho...=335136&hl=

 

It worked! I love you :D