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 one 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 map 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