-
Incident report
-
Resolution: Fixed
-
Minor
-
2.0.8
-
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]