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

SQL Error on "IT services" screen

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.0.9rc1, 2.1.5
    • 2.0.8
    • Frontend (F)
    • None
    • Zabbix 2.0.8, Postgresql 8.1

      After i create under IT services a new Service i get the following error under the SLA Screen:

      pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: syntax error at or near "servicealarmid" at character 67 [include/db.inc.php:440]
      Error in query [SELECT sa.serviceid,sa.value FROM (SELECT MAX(sa3.servicealarmid) servicealarmid FROM (SELECT sa2.serviceid,MAX(sa2.clock) clock FROM service_alarms sa2 WHERE sa2.clock<'1376385501' AND sa2.serviceid IN ('5','6','7') GROUP BY sa2.serviceid) ss JOIN service_alarms sa3 ON sa3.serviceid = ss.serviceid and sa3.clock = ss.clock GROUP BY sa3.serviceid) ss2 JOIN service_alarms sa ON sa.servicealarmid = ss2.servicealarmid] [ERROR: syntax error at or near "servicealarmid" at character 67]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:577]
      pg_free_result(): supplied argument is not a valid PostgreSQL result resource [include/db.inc.php:578]

        1. zabbix1-cct.jpg
          121 kB
          Simon Wetzstein

            iivs Ivo Kurzemnieks
            zumi Simon Wetzstein
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: