Nextcloud Error after upgrading / fresh install "General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE."

HI, after setting up nextcloud on the last release I get following error:
"Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE."

In the nextcloud forum I found even the solution: https://help.nextcloud.com/t/update-to-next-cloud-21-0-2-has-get-an-error/117028

But I am still puzzled how to configure the yaml file for the database to put in this fix?
Can someone please help?

Inspect the YAML configuration used to initialize the database and compare it with the fix in the linked Nextcloud forum discussion. Confirm the relevant database setting can be represented there, then verify that a fresh setup completes without the 4047 initialization error.

Written by the indexing model from the issue text.