< 2015-07-15 16:45:28.937 BRT >ERROR:  invalid input syntax for integer: "" at character 281
< 2015-07-15 16:45:28.937 BRT >STATEMENT:  SELECT DISTINCT h.host,tr.description,tr.triggerid,tr.expression,tr.priority,tr.value FROM triggers tr,functions f,items i,hosts h WHERE tr.triggerid=f.triggerid AND f.function IN ('last','min','avg','max') AND tr.status=0 AND i.itemid=f.itemid AND h.hostid=i.hostid AND f.itemid='' ORDER BY tr.priority


< 2015-07-15 16:45:56.070 BRT >STATEMENT:  SELECT h.* FROM hosts h WHERE h.hostid=''
< 2015-07-15 16:45:56.226 BRT >ERROR:  invalid input syntax for integer: "" at character 40


< 2015-07-15 16:48:28.200 BRT >ERROR:  invalid input syntax for integer: "" at character 194
< 2015-07-15 16:48:28.200 BRT >STATEMENT:  SELECT itemid,round(500* MOD(CAST(clock AS BIGINT)+120,600)/(600),0) AS i,COUNT(*) AS count,AVG(value) AS avg,MIN(value) as min,MAX(value) AS max,MAX(clock) AS clock FROM history  WHERE itemid='' AND clock>='1436989080' AND clock<='1436989680' GROUP BY itemid,round(500* MOD(CAST(clock AS BIGINT)+120,600)/(600),0)