Antelope to Baracuda

Antelope to Baracuda

Albert Ramsbottom གིས-
Number of replies: 2

I have run the following CMD

sudo php admin/cli/mysql_compressed_rows.php --fix

And get the following error:

Cannot enable GLOBAL innodb_file_per_table setting, use --showsql option and execute the statements manually.Default exception handler: Error writing to database Debug: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

SET GLOBAL innodb_file_per_table=1

[array (

)]

Error code: dmlwriteexception

* line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown

* line 974 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()

* line 140 of /admin/cli/mysql_compressed_rows.php: call to mysqli_native_moodle_database->execute()


!!! Error writing to database !!!

Any ideas

Albert

དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -
In reply to Albert Ramsbottom

Re: Antelope to Baracuda

Paul Holden གིས-
Core developers གི་པར Moodle HQ གི་པར Moodle Workplace team གི་པར Particularly helpful Moodlers གི་པར Peer reviewers གི་པར Plugin developers གི་པར Testers གི་པར
  1. Run the CLI tool with --showsql argument
  2. Login to your database administration tool with a privileged account
  3. Copy and execute SQL produced from step 1

(Just as the error message suggests... མིག་ཁྱབ་)