After migration one of my VPS web server to a new hosting company, all of my websites are working perfectly, except one.
This one mostly works except some difficulty with mySQL, and need a repair. We believe it is because our website was developed for mySQL 4.0, but my new server runs on mySQL [url removed, login to view]
We think there are two possible solutions: either (a)install mySQL 4.0 in my new server, or (b) revise my site to make it compatible with mySQL 4.1. The hosting company techs think "change application to use contant in RAND function argument to get the MySQL compatible with MySQL 4.1", but I am not sure.
I need someone to fix the situation. If you are familiar with mySQL and php, it shouldn't be such a big deal.
Site url is [url removed, login to view]