PDA

View Full Version : 1054 - Unknown column 'p.products_id' in 'on clause'



starview
08-14-2007, 01:36 PM
In Oscommerce
I am getting this error when I select a product from any of the sub categories.
This happen on all the different products
Can some one tell me what the problem is?

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 = '3957'

[TEP STOP]

kris7845
08-16-2007, 05:44 AM
It is a syntax error in the php when using php 5, even if you do not use that version it still errors out. You can find some information on fixing the problem from another post I did.

http://www.oscmax.com/forums/oscmax-projects-discussion/8739-multi-stores-shop-system-oscmax-3.html#post29644