Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-15030

query failed: [1054] Unknown column 'i.url' in 'field list'

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Major
    • Resolution: Incomplete
    • 4.0 (plan)
    • None
    • Installation (I)
    • CENTOS

    Description

      I have this problem (image attach) after upgrade to zabbix 3.4 to 4.00

      this is the error on /var/log/zabbix/zabbix_server.log

      3269:20181018:111021.952 [Z3005] query failed: [1054] Unknown column 'i.url' in 'field list' [select i.itemid,i.hostid,i.status,i.type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.trapper_hosts,i.logtimefmt,i.params,i.state,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.snmpv3_authprotocol,i.snmpv3_privprotocol,i.snmpv3_contextname,i.lastlogsize,i.mtime,i.history,i.trends,i.inventory_link,i.valuemapid,i.units,i.error,i.jmx_endpoint,i.master_itemid,i.timeout,i.url,i.query_fields,i.posts,i.status_codes,i.follow_redirects,i.post_type,i.http_proxy,i.headers,i.retrieve_mode,i.request_method,i.output_format,i.ssl_cert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_traps from items i,hosts h where i.hostid=h.hostid and h.status in (0,1) and i.flags<>2]

       someone can help me.

      Thanks

      Attachments

        1. Immagine.png
          Immagine.png
          4 kB
        2. Immagine2.png
          Immagine2.png
          11 kB
        3. Immagine3.png
          Immagine3.png
          21 kB

        Activity

          People

            Unassigned Unassigned
            GIANLUCA1989 Gianluca Tozzi
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: