Ad Widget

Collapse

Zabbix 6.4 / issue with MySQL 8.0 / content_type is reserved keyword now

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • snaki4
    Junior Member
    • Dec 2016
    • 6

    #1

    Zabbix 6.4 / issue with MySQL 8.0 / content_type is reserved keyword now

    Good day,

    Just wondering if somebody "got" already that compatibility issue in between latest Zabbix 6.4 and MySQL 8.0.34 where they added content_type as reserved keyword. So, now, zabbix media type part (at least) is broken.

    Any solution for this?

    Thank you

    Code:
    Zabbix 6.4.12 (revision dba2d5bd63b).
    Example of tte issue from Zabbix server side :

    Code:
    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,maxsessions,maxattempts,attempt_interval,content_type,script,timeout,process_tags from media_type where mediatypeid=1]
Working...