See attachment for error message
"Installation - Moodle 3.11+ (Build: 20210709)
Debug info: InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE."
I've read it might be an issue with a database not being empty. But this is brand new. If I need to delete the database, can someone explain how to do it? Not sure what to do, TIA.
Presumably you've got MariaDB 10.6?
Try adding the following line to C:\Program Files\MariaDB 10.6\data\my.ini:
innodb_read_only_compressed=OFF
And restarting the MariaDB service (the service might be called MySQL).
It looks like this is a problem for Moodle, a feature it uses – ROW_FORMAT=COMPRESSED – is now deprecated in MariaDB ≥ 10.6. I've logged it as MDL-72131.
When you updated the file did you restart the service in the Services console (services.msc)?
You can check the current setting in the MariaDB shell with:
SHOW GLOBAL VARIABLES LIKE 'innodb_read_only_compressed';
And change it with:
SET GLOBAL innodb_read_only_compressed=OFF;
Although this will only last until the MariaDB service is next restarted which is why I recommend changing this in my.ini.
Yes, if you used MariaDB 10.5 this issue should go away.
