Number of Hosts are not displayed in dashboard when mariadb backend is used

Checklist

• Have you pulled and found the error with jc21/nginx-proxy-manager:latest docker image?
  • Yes
• Are you sure you're not using someone else's docker image?
  • Yes
• Have you searched for similar issues (both open and closed)?
  • Yes

Describe the bug
Numbers of Hosts are not displayed in Dashboard. See screenshot below. Instance is running with the mysql-backend. On another instance with the sqlite-database the issue is not there.

There is a HTTP-500-Error in API-Endpoint api/reports/hosts .

Nginx Proxy Manager Version
v2.12.3

To Reproduce
Steps to reproduce the behavior:

1. Login
2. Look at Dashboard

Expected behavior
Number of hosts in each category is displayed.

Screenshots

Operating System
VM with Debian and docker ($hostname is the hostname of the vm, removed for security reasons)
uname -a : Linux $hostname 6.1.0-31-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.128-1 (2025-02-07) x86_64 GNU/Linux
Docker-version: Docker version 28.0.1, build 068a01e

Additional context
Docker-Compose content:

services:
app:
image: 'jc21/nginx-proxy-manager:latest'
restart: unless-stopped
ports:
# These ports are in format :
- '80:80' # Public HTTP Port
- '443:443' # Public HTTPS Port
- '81:81' # Admin Web Port
# Add any other Stream port you want to expose
# - '21:21' # FTP
environment:
DB_MYSQL_HOST: "db"
DB_MYSQL_PORT: $dbport
DB_MYSQL_USER: "$username"
DB_MYSQL_PASSWORD: "$password"
DB_MYSQL_NAME: "$dbname"
# Uncomment this if IPv6 is not enabled on your host
# DISABLE_IPV6: 'true'
volumes:
- ./data:/data
- ./letsencrypt:/etc/letsencrypt
depends_on:
- db

db:
image: 'jc21/mariadb-aria:latest'
restart: unless-stopped
environment:
MYSQL_ROOT_PASSWORD: '$root_password'
MYSQL_DATABASE: '$dbname'
MYSQL_USER: '$username'
MYSQL_PASSWORD: '$password'
MARIADB_AUTO_UPGRADE: '1'
volumes:
- ./data/mysql:/var/lib/mysql

Reproduce the issue with the MariaDB Docker setup and inspect the api/reports/hosts endpoint first, since it returns HTTP 500 while the dashboard is missing host counts. Compare its behavior with the SQLite-backed instance and trace the related dashboard request. Done means the endpoint succeeds and the dashboard displays counts for each host category with MariaDB.