Community Builder no longer compatible with MySQL 5.6

5 months 4 days ago #324789 by fede312
I've got a warning on the backend saying that php7.3 and My5.6 will not longer be compatible with new releases of Community Builder. I've immediately updated the php to version 7.4. But I still have MySQL 5.6.41-84.1 and HostGator told me that it is not possible to upgrade at the moment, unless I switch to a VPS hosting plan, which is thousands of dollars beyond my reach. The representative told me that they may upgrade my current hosting plan sometime in the future, but did not specify when. What's your advice in this matter?


Please Log in to join the conversation.

5 months 3 days ago - 5 months 3 days ago #324792 by krileon
MySQL 5.6 is officially end of life this year as of February. All hosts should have already move away from it. It will no longer receive updates or support from Oracle unless you join their lifetime support program (not free and not recommended to be exposed to the internet). Without MySQL 5.7 we can't use JSON columns which have more optimum storage for JSON strings (which is what all `params` columns are). I suggest changing to a better host or stressing the importance to them that their MySQL version is EOL.

We will no longer be supporting EOL versions in CB 2.7 and onwards (when this will be enforced in our installation checks). This will change with each release of CB as needed. We will always provide an advanced notice regarding this as well (as we've done in CB 2.6).

Hosting with MySQL 5.7 isn't expensive either. SiteGround supports MySQL 5.7 (except on legacy servers). DreamHost supports MySQL 5.7. Both are within 10-20 CENTS price range of HostGator. You can even get a cloud VPS for as little as $5/mo through Vultr and DigitalOcean. Hosting doesn't have to be terrible anymore folks. Move to something better.

On a personal note I also strongly recommend never buying into an EIG host. They're all equally awful. HostGator is a part of EIG. You can find a list of hosts to avoid below. They are an awful company that have done awful things to the companies they've absorbed.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: fede312

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.166 seconds

Facebook Twitter LinkedIn