Stats not shown and PHP Error

[lanfire001]

Describe the bug

Classic Server Stats are not shown on main page and on "Server-Stats" page.
Classic is set in the webpage config file.

Apache gives Error message:
[Mon Sep 08 18:04:17.668286 2025] [php:error] [pid 1769:tid 1769] [client X.X.X.X:51852] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'totalKills' in 'SELECT' in /var/www/wow-cms/application/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57\nStack trace:\n#0 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(57): PDO->query()\n#1 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Connection.php(774): Doctrine\\DBAL\\Driver\\PDO\\Connection->query()\n#2 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Query/QueryBuilder.php(305): Doctrine\\DBAL\\Connection->executeQuery()\n#3 /var/www/wow-cms/application/include/status.php(71): Doctrine\\DBAL\\Query\\QueryBuilder->executeQuery()\n#4 /var/www/wow-cms/template/icecrown/tpl/main.php(379): status::get_top_killers()\n#5 /var/www/wow-cms/index.php(35): require_once('...')\n#6 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDO\\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'totalKills' in 'SELECT' in /var/www/wow-cms/application/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28\nStack trace:\n#0 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(62): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\n#1 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Connection.php(774): Doctrine\\DBAL\\Driver\\PDO\\Connection->query()\n#2 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Query/QueryBuilder.php(305): Doctrine\\DBAL\\Connection->executeQuery()\n#3 /var/www/wow-cms/application/include/status.php(71): Doctrine\\DBAL\\Query\\QueryBuilder->executeQuery()\n#4 /var/www/wow-cms/template/icecrown/tpl/main.php(379): status::get_top_killers()\n#5 /var/www/wow-cms/index.php(35): require_once('...')\n#6 {main}\n\nNext Doctrine\\DBAL\\Exception\\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'totalKills' in 'SELECT' in /var/www/wow-cms/application/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:52\nStack trace:\n#0 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Connection.php(1373): Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter->convert()\n#1 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Connection.php(1315): Doctrine\\DBAL\\Connection->handleDriverException()\n#2 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Connection.php(779): Doctrine\\DBAL\\Connection->convertExceptionDuringQuery()\n#3 /var/www/wow-cms/application/vendor/doctrine/dbal/src/Query/QueryBuilder.php(305): Doctrine\\DBAL\\Connection->executeQuery()\n#4 /var/www/wow-cms/application/include/status.php(71): Doctrine\\DBAL\\Query\\QueryBuilder->executeQuery()\n#5 /var/www/wow-cms/template/icecrown/tpl/main.php(379): status::get_top_killers()\n#6 /var/www/wow-cms/index.php(35): require_once('...')\n#7 {main}\n thrown in /var/www/wow-cms/application/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php on line 52

DB Table:
`MariaDB [classiccharacters]> select * from character_honor_cp;
+------+-------------+--------+-------+---------+------+

| guid | victim_type | victim | honor | date | type |

+------+-------------+--------+-------+---------+------+

| 7 | 4 | 5 | 5 | 8192250 | 1 |

| 7 | 4 | 5 | 4 | 8192250 | 1 |

+------+-------------+--------+-------+---------+------+
`

To Reproduce
On every refresh of the page. Webpage was installed twice, Same behavior

Expected behavior
Server stats are visible on main page and on "Server-Stats" page

Screenshots

Desktop (please complete the following information):

• OS: Debian Linux Server
• Server core: cMangos
• Core repository: https://github.com/cmangos/mangos-classic
• Game version: 1.12.1
• PHP version: 8.2.29
• Browser: Firefox