moosh icon indicating copy to clipboard operation
moosh copied to clipboard

udo -u www-data moosh data-stats - error

Open caiadogithub opened this issue 2 years ago • 0 comments

  • 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

caiadogithub avatar Apr 12 '22 18:04 caiadogithub