1054 - Unknown column 'p.products_id' in 'on clause'

[JohannBorges]

So, I installed a new template from osCommerce and get this 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 = '45'"

 

I don't know which version we use here, but when I change all (Because I don't know which) "p.products_id" to "products_id", give me a error like this:

 

"1052 - Column 'products_id' in where clause is ambiguous"

[NodsDorf]

select count(p.products_id) as total from products_description as pd, products as p left join manufacturers as m on p.manufacturers_id = m.manufacturers_id, products_to_categories as p2c left join specials as s on p2c.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 = '1'

 

That should fix it for you.

 

Good Luck

[NodsDorf]

I added a few "as" es in there for my troubleshooting sanity. They are likely not required but shouldn't hurt. Tested the query on my domain's SQL and it worked.

[JohannBorges]

Thank you, it worked. :D