tmuras
sudo -u www-data moosh data-stats
- moosh version: 1.2
- moodle version: 3.11.5+
- database: PostgreSQL 12
- php version: 7.4
- 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 !!! !! 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 !! !! Stack trace: * 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() !!
Expected behaviour
Steps to reproduce
sudo -u www-data moosh data-stats
