moosh
moosh copied to clipboard
sudo -u www-data moosh db-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 "'table'" LINE 1: SELECT table_name AS 'table', ^ SELECT table_name AS 'table', ROUND(((data_length + index_length))) AS 'size' FROM information_schema.TABLES WHERE table_schema = 'db_mooc-nce' ORDER BY (data_length + index_length) DESC [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 25 of /usr/share/moosh/Moosh/Command/Moodle39/Report/DbStats.php: call to pgsql_native_moodle_database->get_records_sql()
- line 361 of /usr/bin/moosh: call to Moosh\Command\Moodle39\Report\DbStats->execute()
!!! Erro ao ler a base de dados !!!
Expected behaviour
Shows the total size of the Moodle database and the biggest tables.
Steps to reproduce
sudo -u www-data moosh db-stats