Monitor for Database Size not working

short description

MYSQL database size is not refreshing when running cron job.

correct behaviour

Refresh database size when running cron job

environment

Server OS: Ubuntu 18.04.5 ISPConfig version: 3.2

proposed fix

wrong sql statement in 100-monitor_database_size.inc.php

SELECT database_id, database_name, sys_groupid, database_quota, quota_exceeded FROM web_database WHERE server_id = ? GROUP BY sys_groupid, database_name ASC

has to be replaced by

SELECT database_id, database_name, sys_groupid, database_quota, quota_exceeded FROM web_database WHERE server_id = ? ORDER BY sys_groupid, database_name ASC
Edited by Sören Weissmann