Internal server error after database update

So I had Nextcloud 20.0.4 running on a Centos7 server with MariaDB 5.5.68 and the update page tells me that I need to get MariaDB 10.2 or higher to update to Nextcloud 21.

I followed this page to upgrade the database
and that process went fine. Didn’t spot any errors.

But now when I try to login I just get “Internal Server Error”

I had a look at /var/www/html/nextcloud/data/nextcloud.log, it wasn’t easy to make sense of it. But I saw this error
General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

Could that be the culprit and what to do?

Since mariadb 10.6 Compressed rows are read-only by default.

you can change that setting in the mariadb configuration:


Thank you. That was spot-on.