Fix OsCommerce - upgrade

We have a few oscommerce sites that were built on mysql4, and php4. We have upgraded our server to php4 OR 5, and mysql5. Some sites have stopped working - we need them carefully patched to current version. THIS BID REQUEST IS FOR ONE SITE, IF YOU HANDLE IT WELL, WE WILL HIRE YOU FOR OTHERS! Here is one of the sites, this is a direct link to the ERRORING PAGE. [login to view URL] We found from searching the internet that this is a problem with going from mysql4 to mysql5, most of the site works, but on this one - the search page doesn't. We would like someone that is good with oscommerce to just update it while leaving the custom 'theme' intact.