search

esmero / archipelago-deployment

Archipelago Commons Docker Deployment Repository
33 stars 16 forks source link

Mysql 8 has problems with Drupal 8 and some contrib modules. #92

Open patdunlavey opened 3 years ago

patdunlavey commented 3 years ago

This Mysql 8 compatibility problem was encountered while trying to enable the group module in my Archipelago install. Turns out the problem is solved for D9, but not for D8.

I'm not sure what to recommend for Archipelago-deployment for the Drupal 8 version, but one option is to simply set the Mysql version to 5.7.

DiegoPino commented 3 years ago

@patdunlavey thanks a lot for this. I will do some quick research if patching CORE via composer.json opens choices for Drupal 8 users too.

I will also make sure the D9 deployment is 1:1 to the D8 this week so you can also plan ahead in production for that.

DiegoPino commented 3 years ago

The patch in question is : https://www.drupal.org/files/issues/2020-09-14/drupal-allow-dash-in-table-name-2986452.patch

patdunlavey commented 3 years ago

@DiegoPino it's a lot more complicated than that, from what I can see. The issue with the Group module is that it's running afoul of MySQL 8 reserverd words: https://www.drupal.org/project/drupal/issues/2986452. Here's the D9 commit that resolves the problem: https://www.drupal.org/commitlog/commit/2/3e9a5a531ffd801ad5fb8acbb62135d0348e29e2.