Our web host just upgraded mysql from 4 to 5 without ever informing us, and our zencart site is pretty much dead. I'm running a hacked up version of zencart 1.2.5, and today I'm getting the following error:

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

At first I was getting this when clicking on a category or a product. I made some changes in the includes\index_filters\default_filter.php and my categories are showing up, but when I click on a product to view the product details, I still get the same error. I don't know which query is creating the problem on this page and would appreciate it if someone can tell me which query i need to fix. Upgrading the site to the latest version of zencart at this time is out of the question because we have too many custom hacks and it would take a major effort.

The main site is at http://www.tmpanime.com. If you click on any product, you will get the above SQL error. I'm getting very frustrated because I get no debug info that gives me any clue on which query in what file is causing this. Thanks much.