-
New Feature Request
-
Resolution: Fixed
-
Major
-
5.0.42
-
None
-
S24-W16/17, S24-W18/19
-
1
Zabbix server produces error:
34385:20240419:074505.215 [Z3005] query failed: [1064] 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 'content_type,script,timeout,process_tags from media_type where mediatypeid=1' at line 1 [select mediatypeid,type,smtp_server,smtp_helo,smtp_email,exec_path,gsm_modem,username,passwd,smtp_port,smtp_security,smtp_verify_peer,smtp_verify_host,smtp_authentication,exec_params,maxsessions,maxattempts,attempt_interval,content_type,script,timeout,process_tags from media_type where mediatypeid=1]
The same error is when test from command line.
If edit the query and enclose the name by double quotes ("content_type") - it works.
Frontend also shows an error "Cannot find specified media type" when manually test it, see screenshot.
This error appeared after upgrading DB engine from 5.7.mysql_aurora.2.11.4 to 8.0.mysql_aurora.3.06.0
Related discussion is https://github.com/znuny/Znuny/issues/548
Not sure how this can/should be addressed in zabbix. Should be discussed.