Hi,
We are close to migrate from zabbix 1.4 to 1.8.3 on postgres 8.4.
all the migration process has been done and evrything seems to Work fine , except ont thing .
Loggued as a normal user i get the following error when i go to the map configuration or the map consultation :
"pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: syntax error at or near "," at character 680[/USR/zabbix/zabbix183/php/include/db.inc.php:408]
Error in query [SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i,hosts_groups hg,rights r,users_groups ug WHERE ((t.triggerid BETWEEN 000000000000000 AND 099999999999999)) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.hostid=i.hostid AND r.id=hg.groupid AND r.groupid=ug.usrgrpid AND ug.userid=32 AND r.permission>=3 AND NOT EXISTS( SELECT ff.triggerid FROM functions ff, items ii WHERE ff.triggerid=t.triggerid AND ff.itemid=ii.itemid AND EXISTS( SELECT hgg.groupid FROM hosts_groups hgg, rights rr, users_groups gg WHERE hgg.hostid=ii.hostid AND rr.id=hgg.groupid AND rr.groupid=gg.usrgrpid AND gg.userid=32 AND rr.permission<3)) AND (t.triggerid IN (,,,36757,34357,,33793,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1323 4)) ] [ERROR: syntax error at or near "," at character 680]"
then the page load , but it doesn't display as many pages as it should.
If i give super administrateur rights to this users , erverything is back to normal.
Anyone can help ? apparently postgres does not supports (,,,,) in the sql.
thanks in advance.
thierry
We are close to migrate from zabbix 1.4 to 1.8.3 on postgres 8.4.
all the migration process has been done and evrything seems to Work fine , except ont thing .
Loggued as a normal user i get the following error when i go to the map configuration or the map consultation :
"pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: syntax error at or near "," at character 680[/USR/zabbix/zabbix183/php/include/db.inc.php:408]
Error in query [SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i,hosts_groups hg,rights r,users_groups ug WHERE ((t.triggerid BETWEEN 000000000000000 AND 099999999999999)) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.hostid=i.hostid AND r.id=hg.groupid AND r.groupid=ug.usrgrpid AND ug.userid=32 AND r.permission>=3 AND NOT EXISTS( SELECT ff.triggerid FROM functions ff, items ii WHERE ff.triggerid=t.triggerid AND ff.itemid=ii.itemid AND EXISTS( SELECT hgg.groupid FROM hosts_groups hgg, rights rr, users_groups gg WHERE hgg.hostid=ii.hostid AND rr.id=hgg.groupid AND rr.groupid=gg.usrgrpid AND gg.userid=32 AND rr.permission<3)) AND (t.triggerid IN (,,,36757,34357,,33793,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1323 4)) ] [ERROR: syntax error at or near "," at character 680]"
then the page load , but it doesn't display as many pages as it should.
If i give super administrateur rights to this users , erverything is back to normal.
Anyone can help ? apparently postgres does not supports (,,,,) in the sql.
thanks in advance.
thierry
Comment