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

I have been running ZenCart for almost a year without any problems and today I started getting an error when I try to load any product and I cant figure out what it means. I can load the front page but when I select any product I get the following:

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

There is no column in MySQL that is called p.products_id? Can anyone help me here?

Thanks,

Chris

What version of Zen Cart?

Did your hosting site suddenly upgrade the server?

http://www.zen-cart.com/forum/showthread.php?t=70400&highlight=1054+Unknown

You might try a clean install in a clean directory with a clean database of the current v1.3.7.1 and see if that works ...
http://www.zen-cart.com/forum/showthread.php?t=69769

if so, then it sounds like a server issue with changes made by your host that will not work with your old version of Zen Cart ...

Where did you get your Zen Cart from?

How did you install it? Clean install or an upgrade? How did you upgrade it?