Database utf8_unicode_ci collation not supported about webtrees-docker HOT 3 OPEN

So, the latest-alpha and latest-beta tags are built based on Webtrees releases that are tagged as beta or alpha. For example, https://github.com/fisharebest/webtrees/releases/tag/2.1.0-beta.2 or https://github.com/fisharebest/webtrees/releases/tag/2.1.0-alpha.2. There hasn't been a beta or alpha release in a long time, so that's likely why those images may be broken. Hopefully fisharebest releases a new version soon with that change applied. You could potentially build yourself a custom version using the Dockerfile and changing the webtrees URL, but I have never explored offering nightly builds or anything. I'm not exactly sure what fisharebest does to create release .zip files.

I will say for my own instance, all of my tables use utf8mb3_unicode_ci and is MariaDB 10.11.7.

from webtrees-docker.

Thanks for your reply. Apologies for my slow reply. My docker swarm migration suddenly got very busy!

I did some more digging and it looks like MariaDB dropped support for utf8_unicode_ci (alias utf8mb3_unicode_ci) somewhere in v11, so that's why your v10.11.7 still works OK. Also the webtrees DB changes to support later versions of MariaDB are still underway so it's not possible to create a custom version yet, although I guess I could just get the current version and find the utf8_unicode_ci strings and change them.

I think the easiest option for now is to create a MariaDB v10 container and have webtrees use that for compatibility purposes and then I can migrate to the 'master' MariaDB v11 database when the next version of webtrees is released.

from webtrees-docker.

No worries, you're getting what you pay for in support 😁. I can't remember why I pinned my MariaDB container at 10.7 but I bet that may be why. Thanks for figuring that out. I updated the example docker-compose.yml file which hopefully helps others.

from webtrees-docker.