You might be right that it isn’t related to changing the encoding, but just like tardar says, I get the same error nonetheless even after disabling the compression.
And I’d have thought that the default compression refers to the any new changes, not to the existing tables that have compression on.
[later edit:]
It seems it was related after all to the enconding.
So what I did was:
docker exec -it --user www-data next-app php occ config:system:set mysql.utf8mb4 --type boolean --value="false"
Then I came across another error:
In ValidatePhoneNumber.php line 64:
Can not validate phone numbers without `default_phone_region` being set in the config file
I edited config/config.php and added:
'default_phone_region' => 'NE' # choose some country; the important thing is that you define it.
And then I ran the repair command again and turned off maintaince:
docker exec -it --user www-data next-app php occ maintenance:repair --include-expensive
docker exec -it --user www-data next-app php occ maintenance:mode --off
Now I’m also able to install apps (which threw the same error in the GUI before this)
The only problem I now have is the warning (in settings - overview) that led to all this in the first place:
MySQL is used as database but does not support 4-byte characters. To be able to handle 4-byte characters (like emojis) without issues in filenames or comments for example it is recommended to enable the 4-byte support in MySQL. For further details read