Problems after MYSQL upgrade - Please help

[gosvald]

My ISP just upgraded MYSQL to version Mysql Distrib
5.0.45.
When I try to access the catalog on the web site I get this error message:
1054 Unknown column 'p.products_id' in 'on clause'
Catalog in Admin pages seems to be working fine.

I am still running the old version 1.2.6
Database: MySQL 5.0.45-log
HTTP Server: Apache/1.3.34 (Unix) PHP/4.4.2 DAV/1.0.3 mod_jk/1.2.3 mod_ssl/2.8.25 OpenSSL/0.9.8a
PHP Version: 4.4.2 (Zend: 1.3.0)

Thank you for any help

[kobra]

All I am aware of is that many of the mysql 5.x issues have been addressed in 1.3.7 and do not know if there is a patch for the 1.2.x series