PHP 5 and mySQL 5

[MySitesOnline]

Hello,

We are currently thinking of upgrading our servers to PHP 5 and mySQL 5 I was wondering should be expect to run into any issues (not with the upgrades) but issues with customers scripts etc>?

Any advice would be appreciated.

 

[adad]

Same question here. Did you get any updates? We are currently running php 4.4.2 and mysql 4.1.

 

[nickp666]

any object-orientated php sites will need a look over. - http://uk2.php.net/manual/en/faq.migration5.php

 

[adad]

Thank you for the link.

My customers are typically running Joomla!, OWL intranet, Mambo, OSCommerce, Webcalendar, SMF among others. Anything that will certainly go broken with the upgrade in such applications?

 

[nickp666]

best thing to do is check with each of the scripts homepages/forums to see if they run ok under php5, if you are using oscommerce you will need to put the register_globals back on after the upgrade (unless you have patched it manually) im sure the same would apply to some of the others as well

 

[adad]

OK. Thanks!

 

[Spiral]

Regarding PHP v5, it is fully backwards compatible with the entire v4 series
and you should not have any problems whatsoever with any application.

Most problems you hear about PHP v5 actually have nothing or very little
to do with PHP v5 and more to do with an administrator trying to run both
version 4 and version 5 simultaneously which I don't recommend because
of a number of conflict issues most people are still unaware of.

Running PHP v5 by itself works great with no problems !!!

Unfortunately, the same cannot be said with MySQL v5 which is known to have
a lot of compatible issues with a lot of commonly used applications and a lot
of popular scripts out there and is a major headache patching those applications
to get them all to working correctly with MySQL v5.

For the moment, I would recommend you stay back on the MySQL v4.1 series
and not upgrade to MySQL v5 unless you absolutely have no other choice.

 

[adad]

Crystal clear! That's exactly what I suspected... I've never had any serious issue with PHP, but MySQL upgrades are always a pain in the neck.