Plugins check moodle 2.7

Re: Plugins check moodle 2.7

by Johnny Drud -
Number of replies: 0

Hi Mikhail and Albert

I guess you two are not the only ones with that issus so here is the fix.

Write this command to list the problematic tables: php admin/cli/mysql_compressed_rows.php -l

Convert them with this command (as the root user): php admin/cli/mysql_compressed_rows.php -f

If it doesn't work you could run this command to show the DB commands: php admin/cli/mysql_compressed_rows.php -s

The previous command should display something like this: USE yourtable; SET SESSION sql_mode=STRICT_ALL_TABLES; SET GLOBAL innodb_file_per_table=1; SET GLOBAL innodb_file_format=Barracuda; ALTER TABLE mdl_data ROW_FORMAT=Compressed; ALTER TABLE mdl_data_fields ROW_FORMAT=Compressed; ALTER TABLE mdl_enrol_paypal ROW_FORMAT=Compressed; ALTER TABLE mdl_lti ROW_FORMAT=Compressed; ALTER TABLE mdl_user ROW_FORMAT=Compressed; ALTER TABLE mdl_user_info_field ROW_FORMAT=Compressed;

Just run that code in phpMyAdmin or a similar admin tool to fix the tables. Remember to create a backup before you do that smile