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

ℹ️ Support
,
1 
Some or all of the below information will be requested if it isn't supplied; for fastest response please provide as much as you can :heart:

[/details]

Nextcloud version  23.0.0
Operating system Arch Linux
Nginx version 1.21.4
PHP version 8.0.14

The issue you are facing:

I've got to this point in the arch linux wiki: https://wiki.archlinux.org/title/Nextcloud#Nextcloud_setup

When I run:
`sudo occ maintenance:install --database mysql --database-name nextcloud --database-host localhost --database-user nextcloud --database-pass=1234 --data-dir /var/lib/nextcloud/data/
`
it says
`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.`

Full paste bin https://pastebin.com/p0H2A2nR

Is this the first time you've seen this error? _(Y/N)_: Yes?

Steps to replicate it:

1. See above

The output of your Nextcloud log in **Admin > Logging**:
It's blank

The output of your config.php file in `/path/to/nextcloud` (make sure you remove any identifiable information!):
<?php $CONFIG = array ( 'datadirectory' => '/var/lib/nextcloud/data/', 'logfile' => '/var/log/nextcloud/nextcloud.log', 'apps_paths' => array ( 0 => array ( 'path' => '/usr/share/webapps/nextcloud/apps', 'url' => '/apps', 'writable' => false, ), 1 => array ( 'path' => '/var/lib/nextcloud/apps', 'url' => '/wapps', 'writable' => true, ), ), 'passwordsalt' => 'JQU8FZ2mgpk1cclghcs99SZSrNbgvd', 'secret' => 'Hb7Uo/hQA/bPc4l+OT3MefveJem3ziDNQjHF9PGcUUbJSHoi', 'trusted_domains' => array ( 0 => 'localhost', ), 'dbtype' => 'mysql', 'version' => '23.0.0.10', 'overwrite.cli.url' => 'http://localhost', 'dbname' => 'nextcloud', 'dbhost' => 'localhost', 'dbport' => '', 'dbtableprefix' => 'oc_', 'mysql.utf8mb4' => true, 'dbuser' => 'nextcloud', 'dbpassword' => '1234', ); ``` The output of your Apache/nginx/system log in `/var/log/____`: [``` PASTE HERE ```](https://pastebin.com/wi2yzXs3)
2

Fixed by running

SET GLOBAL innodb_read_only_compressed=OFF;