Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.8
    • Fix Version/s: 2.0.9rc1, 2.1.5
    • Component/s: Frontend (F)
    • Labels:
      None
    • Environment:
      Zabbix 2.0.8, Postgresql 8.1

      Description

      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]

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: