Frontend syntax error of zabbix 4.0.7

XMLWordPrintable

    • Type: Incident report
    • Resolution: Cannot Reproduce
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Environment:
      PostGreSQL 10 SLES12
      Puppet

      When we add a host with puppet agent, we can see an error in the postgresql lo :

      ERROR:  syntax error at or near "AND" at character 75

      STATEMENT:  SELECT DISTINCT h.* FROM hosts h,hosts_templates ht WHERE h.status=3 AND  AND h.hostid=ht.templateid

       

      When are unale to find where this "

      SELECT * FROM hosts where status = '3';" is done

            Assignee:
            Aleksandrs Petrovs-Gavrilovs
            Reporter:
            Nicolas Bataille
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: