CMDPHP ERROR: A DB Exec Failed

[JaseMac]

I'm setting up a new Cacti Server to replace an old working installation.

New Windows Server 2022 using the package download of Cacti-1.2.27 and upgraded to 1.2.28 with the download from cacti.net
Cacti 1.2.28
RRD 1.8.0
PHP 8.1.16
MySQL 8.0.32
Thold 1.8.2 (downloaded from GitHub)
ReportIT 2.0 (downloaded from GitHub)

When I install the plugin, I get the following errors in the log:
024/11/11 10:59:07 - CMDPHP SQL Backtrace: (C:\Apache24\htdocs\cacti\plugins.php[78]:api_plugin_install(), C:\Apache24\htdocs\cacti\lib\plugins.php[751]:plugin_reportit_install(), C:\Apache24\htdocs\cacti\plugins\reportit\setup.php[44]:reportit_system_setup(), C:\Apache24\htdocs\cacti\plugins\reportit\setup.php[627]:reportit_system_install(), C:\Apache24\htdocs\cacti\plugins\reportit\system\install.php[374]:db_table_create(), C:\Apache24\htdocs\cacti\lib\database.php[1570]:db_execute(), C:\Apache24\htdocs\cacti\lib\database.php[420]:db_execute_prepared())
2024/11/11 10:59:07 - CMDPHP ERROR: A DB Exec Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALLTER TABLE reports_log CHARSET = utf8mb4' at line 1

thanks
-Jase