moosh
moosh copied to clipboard
udo -u www-data moosh data-stats - error
- moosh version: 1.5
- moodle version: 3.11.6+
- database: PostgreSQL 12
- php version: 7.43
- operating system: Ubuntu 20.04
Actual behaviour
Default exception handler: Erro ao ler a base de dados Debug: ERROR: syntax error at or near "'total'" LINE 1: SELECT SUM(filesize) AS 'total' FROM (SELECT filesize FROM m... ^ SELECT SUM(filesize) AS 'total' FROM (SELECT filesize FROM mdl_files GROUP BY contenthash,filesize) sizes [array ( )] Error code: dmlreadexception
- line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 329 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
- line 977 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
- line 1671 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
- line 38 of /usr/share/moosh/Moosh/Command/Moodle39/Report/DataStats.php: call to moodle_database->get_record_sql()
- line 361 of /usr/bin/moosh: call to Moosh\Command\Moodle39\Report\DataStats->execute()
!!! Erro ao ler a base de dados !!!
Expected behaviour
Provides information on size of dataroot directory, dataroot/filedir subdirectory and total size of non-external files in Moodle.
Steps to reproduce
sudo -u www-data moosh data-stats