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