I don't think you don't have a products_id in the products database table. Something like this will mean the database is corrupt and none of the pages would display without errors.

I believe your host upgraded the MySQL and you need to setup the latest osc updates. The catalog/index.php and catalog/advanced_search_results.php are just two of the files you need to modify for this.

__________________
Professional E-Commerce Integration and Services. PM for details or visit
Asymmetric Software