Connect problem after php upgrade

prosolutions

I have developed a system that is hosted on a virtual server at a UK Web Host.

There are a couple of installations and it has been running for several months without incident.

The (Cobalt) servers are running Linux 2.2.13, Apache 1.3.20, PHP, MySQL 3.23.39

At the beginning of last week The Web Host upgraded all servers from PHP 4.01pl2 to 4.0.6 without telling anyone that they were going to do it! The first we knew anything about it was when my client sites started getting "No Database Selected" errors when processing 'some' MySQL functions.

The system only uses mysql_connect never mysql_pconnect.

There are no mysql_close functions used, as the system allows the non-persistant dB connections to close automatically when the script finishes.

The problem appears to be because the mysql_connect is now being closed between SQL calls.
i.e. I will perform one mysql_query ... do some processing on the returned fields ... do another mysql_query .... and get the error!?!

The only way I have found to 'fix' the problem to put a dB connect/select before each mysql_query, an untidy kludge! The script responds within a few seconds and so I don't think it is a time-out.

I am having trouble duplicating the problem on my local server and I have limited rights on the virtual server and cannot start playing with its config files (even reading them is termed an abuse!)...I have had a search for related errors with no luck so far!

Has anyone heard of such a problem or have advice on what I can possibly ask the Web Host to check.

Thanks

Chris

mikefn

How did they upgrade it?
Did they do ./configure , make , and make install?
If so, make sure when they configured php4.0.6, you'd better check if they did it with mysql, apache, etc.
If you need to run your database ASAP, ask them to put back the old PHP.
Hope this help.

prosolutions

Hi Mike ... sorry for the delay in getting back to you.

It is almost impossible to get any of that kind of information from the web host ... as an example they have just disabled the phpinfo function on all servers as well!!

Similarly going back to a previous version is not possible as they only want to 'support' one version.

I am going to either host the sites myself or find a more 'support frendly' company!

BTW. I got round my problems by adding a few extra connects, but it would have been nice to have been able to shedule the changes and not have half the site down for updates!

Thnx.
Chris