Tabla de Contenidos

Administración CLI (Moodle)

Instalación

$ sudo -u apache /usr/bin/php admin/cli/install.php –lang=cs

Purgar caches

admin/cli/purge_caches.php

Soluciona el error “Coding error detected, it must be fixed by a programmer: Failed to unserialise data from file. Either failed to read, or failed to write.”

Artículos

Optimizar tablas MySQL

Si en http://moodle.tecnicoelearning.com/admin/environment.php nos dice “Su base de datos tiene tablas utilizando el formato de fichero Antelope. Se le recomienda convertir las tablas al formato de fichero Barracuda. Revise la documentación Administración mediante línea de comandos para detalles de la herramienta para convertir tablas InnoDB a Barracuda.” 

#php admin/cli/mysql_compressed_rows.php --list
mdl_data                        Compact     (needs fixing)
mdl_data_fields                 Compact     (needs fixing)
mdl_enrol_paypal                Compact     (needs fixing)
mdl_lti                         Compact     (needs fixing)
mdl_user                        Compact     (needs fixing)
mdl_user_info_field             Compact     (needs fixing)
#php admin/cli/mysql_compressed_rows.php --fix
Cannot enable GLOBAL innodb_file_per_table setting, use --showsql option and execute the statements manually.!!! Error al escribir a la base de datos !!!
#php admin/cli/mysql_compressed_rows.php --showsql
Copy the following SQL statements and execute them using account with SUPER privilege:

USE moodle;
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;

Documentación oficial

Foros oficiales

Artículos