Upgraded database compatibility for pre-7 versions of Concrete5

Developing with Concrete
1

My webhost is upgrading their database to Maria DB 10.11.

I have developed a number of older sites using Concrete 5.6.4.0 and wonder if they are compatible?

Currently they run happily on Maria DB 10.6.

thanks

2

I suspect that you may find that the word “groups” is now a reserved word in the late MySQL versions, and IIRC the groups table is used in various places in 5.6 unescaped so you will get errors. The fix is to surround the word groups with backticks. The good news is you should be able to do that now, before the upgrade happens.

You’ll need to look at
File Changes
concrete/core/models/groups.php 9
concrete/core/models/user.php 1 (query had 6 Groups. references)
concrete/core/models/search/group.php 3
concrete/core/models/permission/keys/custom/access_user_search.php

3

So I just need to change SQL table names with Groups to `Groups`? I do this in phpmyadmin?

4

I don’t believe that Concrete 5.6.4.0 suffers from the ‘Groups’ reserved words problem as this was addressed some time ago.

5

You may need to download the github latest for 5.6.4.0. The downloadable zip on ConcreteCMS may pre-date the reserved words fix.

6

Thanks for the advice.

I checked the table name and Groups is actually `Groups` so looks like I am set. Hopefully the sites wont break when update happens on the 27th!

7

Correct - the download zip does not have that fix in.

8

No - you need to check your code/files, not the the database. You can’t do that in phpmyadmin. You’ll need a text editor/ftp/file manager etc.