Error In Query

[chlf]

Hello,

I'm working on a new installation of Zabbix 6.0 and when logged into the front end, I am greeted by the below error....

Error in query [SHOW VARIABLES LIKE "character_set_database"] [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 '"character_set_database"' at line 1] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → MysqlDbBackend->init() → DBselect() → trigger_error() in include/db.inc.php:248]

I tried the

SHOW VARIABLES LIKE "character_set_database"

in mySql and indeed it throws the error. But when I replace the double quotes with single quote, it runs fine and returns the anticipated values.

Any idea how to resolve this? It looks like it's an issue with the DB handling of zabbix frontend.

Thanks,