Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Kenny01 on June 07, 2014, 07:52:32 PM

Title: Mysql and PHP Upgrade?
Post by: Kenny01 on June 07, 2014, 07:52:32 PM
1. Please i want to know if SMF 2.0.7 is compatible with mysql and PHP latest version?

2. What's the latest version of mysql and php?

Because i asked my host to upgrade my server mysql and php to the latest version, they asked me to confirm that SMF is compatible with mysql and php  latest version because upgraded the action can not be reversed.


Please i need your urgent reply.

Thanks.
Title: Re: Mysql and PHP Upgrade?
Post by: Arantor on June 07, 2014, 08:01:01 PM
Latest versions? You *never* upgrade to the 'latest' version of anything. The latest version of PHP at time of writing is 5.6.0 beta 4, which would be totally unsuitable to run in a production environment such as your webserver. PHP themselves say not to run it. Similarly, the latest version of MySQL is an in-development milestone for version 5.7, and again, you would not run it in a production environment.

They should be telling you what version of PHP/MySQL they plan to upgrade to and we can go from there.

SMF 2.0.7 itself works on PHP 5.5.x, or best to use 2.0.6 on 5.4.x, and as for MySQL versions, fine on 5.5 with MyISAM tables, specific configuration required for InnoDB tables, requires a separate mod to be installed against MySQL 5.6 regardless of table type.
Title: Re: Mysql and PHP Upgrade?
Post by: Kenny01 on June 07, 2014, 08:22:45 PM
Thanks Arantor,
I have forwarded your reply to them and i will update this thread once i hear from them.
Title: Re: Mysql and PHP Upgrade?
Post by: Kenny01 on June 07, 2014, 08:31:23 PM
Below is my host reply

"The following are the versions differences your are requesting:

mysql: 5.1 -> 5.5
php: 5.2 -> 5.3

Please let me know when you are prepared for me to perform these upgrades for you. Please verify you understand these upgrades will be irreversible on your server. Let me know if you have any questions.
Title: Re: Mysql and PHP Upgrade?
Post by: Kindred on June 07, 2014, 08:52:56 PM
Php5.3 is certainly anything but the latest...   5.3 is almost ready for sunset, actually....

There will be no problem running smf on it...  But 5.4 is a better choice

MySQL 5.5 is just fine
Title: Re: Mysql and PHP Upgrade?
Post by: Arantor on June 07, 2014, 09:12:29 PM
Technically, 5.3.28 is the latest 5.3 version but yes, it's far from the latest.

Moving those versions will not adversely affect SMF whatsoever.
Title: Re: Mysql and PHP Upgrade?
Post by: Kenny01 on June 08, 2014, 03:31:53 AM
Upgrade done and SMF was working fine only my dating sites in the same server that was affected.
Thanks.