Error Message 1054

[Guest]

Help!

 

I got the following error message:

 

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

 

select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_group = 'military' and p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '48'

 

[TEP STOP]

 

---

 

So I went on the OSCommerce site and founds some "fixes" and followed them, or thought I did and things got seemingly worse. The error went away but now it shows all my product as being out of stock. It looks fine on the back end of things but customers see it as "Out of Stock". Any idea how I can fix this? Any assistance is appreciated!

 

Thanks.

 

Sammy

http://www.diecastrunway.com