Do sites running on C5.6 work with MySQL 5.7 ?

Permalink
I still have a few legacy sites running on version 5.6 on one of my servers, and want to upgrade MySQL from 5.6 -> 5.7.

Does anyone have any experience / advice as to whether Concrete5.6 works okay or not with MySQL 5.7?

Thanks.

drbiskit
View Replies: View Best Answer
ConcreteOwl replied on at Permalink Best Answer Reply
ConcreteOwl
I have some 5.6 sites on my dev server that run quite happily on mysql 5.7.24
drbiskit replied on at Permalink Reply
drbiskit
That's really useful, thanks! I'll run a few tests in dev and see what I find.

Cheers.
juandavid0528 replied on at Permalink Reply
Hi!

I am planning to migrate my client website currently using 5.6.4.0,

Is it okay on PHP 7.3 and MySQL 5.7?

Thanks!
drbiskit replied on at Permalink Reply
drbiskit
Hello.

It should run on MySQL5.7 okay. I have sites using 5.6.4, and have just upgraded MySQL from 5.6 -> 5.7. All seems to be running fine.

But - it won't run on PHP7.

There is a version of the 5.6 branch of Concrete5 that you could try using - details here:
https://www.concrete5.org/community/forums/chat/concrete5.6-on-php7...

But you might find that addons or custom code might not work without some further work. My advice would be to only apply these updates to a development copy of the site and see how you get on. And in both cases of updating MySQL, and PHP - obviously make sure you take full backups of everything first.
juandavid0528 replied on at Permalink Reply
Hi!

so PHP 7 is also fine?
drbiskit replied on at Permalink Reply
drbiskit
Apologies - I meant to say that it won't run on PHP7. (including 7.0 / 7.1 / 7.2 / 7.3 )
juandavid0528 replied on at Permalink Reply
5.6.4 wont run on PHP 7?

I have seen some people here says it is the legacy version that works on PHP 7.
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Concrete 5.6.4 will run on PHP 7 I have some 5.6.4. sites running on PHP 7.3.
Your Addons might need some tweaking to run on PHP 7 but the Concrete Core runs fine.
Take a look at
https://www.deepsea.co.uk/phpinfo.php...
juandavid0528 replied on at Permalink Reply
That was a relief so to be short 5.6.4 Core is fine IN PHP 7 Mysql latest

Donyou have any idea how can I know if is add-on is not compatible? currently I have 4

Any help is appreciated. I
juandavid0528 replied on at Permalink Reply 1 Attachment
Here is my add-on on the attachment
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
@juandavid0528
Those addons appear to work fine, the only error I could find was in 'Page List Title' , one of the template files ( blog_index.php ) has this on line 20
$entryController = Loader::controller($cobj);
$comments = $entryController->getCommentCountString('%s '.t('Comment'), '%s '.t('Comments'));

And I patched it by changing the code to this
$entryController = Loader::controller($cobj);
if(method_exists($entryController,'getCommentCountString')) {
$comments = $entryController->getCommentCountString('%s '.t('Comment'), '%s '.t('Comments'));
}
juandavid0528 replied on at Permalink Reply
Hi!

Thanks for the time, so that error is not related to Concrete5 Core but on Add-on but Page Title right?

I will try to check where is that file

By the way this is the website I am planning to migrate

http://www.boistec.com/
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Yes it is the Page List Title Addon, look in the templates folder for the blog_index.php file.
juandavid0528 replied on at Permalink Reply
Thanks for the help!

May I know how do you test and find that error?
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
I use WAMP on my Windows 10 machine and WAMP will offer different versions of PHP (if you have installed them) to run the site on.
So I loaded up my development 5.6.4 site on PHP 7.3.8 and installed those addons.
I then created a new page, loaded the addons to be tested and looked for the errors.
Once the errors are displayed it is just a matter of tracking down the code and patching it.
drbiskit replied on at Permalink Reply
drbiskit
Every day is a school day. That's good news, I wasn't aware - thanks!

@juandavid0528 - I would think that it will be a simple matter of trial + error.
juandavid0528 replied on at Permalink Reply
This is my first time on Concrete5,

Can you give points how can I test those add-ons?
I am planning to transfer it first on my local XAMPP using latest php7.3
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Testing your addons is a case of 'Suck It and See'
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
As a point of interest.
I have updated several members legacy sites to run on PHP7 and have always managed to patch the addons to work also.
If you run into difficulty getting your addons to work, post the error messages here on the forums and together we should be able to resolve them.
If you want your site updated as a job, Just send me a PM