Zabbix graph section not working correctly when using Postgresql database

[surenx]

Hi

I've installed the Zabbix server on my computer and inserted all the data to the zabbix database.
The zabbix seems to work fine, but when I enter by Admin access and go to configuration->graphs section then, below the (NO Graphs Defined) text it shows the following error

    * pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "while" LINE 1: ...graphid left join items i on gi.itemid=i.itemid while (g.... ^[/usr/local/share/zabbix/php/include/db.inc.php:293]
    * Error in query [select distinct g.* from graphs g left join graphs_items gi on g.graphid=gi.graphid left join items i on gi.itemid=i.itemid while (g.graphid/100000000000000) in (0) and ( i.hostid not in (-1) OR i.hostid is NULL ) order by g.name, g.graphid] [ERROR: syntax error at or near "while" LINE 1: ...graphid left join items i on gi.itemid=i.itemid while (g.... ^]
    * pg_fetch_array() expects parameter 1 to be resource, boolean given[/usr/local/share/zabbix/php/include/db.inc.php:414] 

When I try to create a graph, it seems that it creates the graph, but when I go back to "Graphs" section then I see the same error with no graphs created.

I'm using the Postgresql Database and the "graphs" table contains all the needed information.

P.S. This is the first time I try to run Zabbix on Postgresql database, Is it generally working without any problems on this database or not?

Thanks in Advance!

[nelsonab]

Check the following post, I beleive it's related.

http://www.zabbix.com/forum/showthread.php?t=7718

I posted a fix in that situation I beleive it will work in your case too.

[surenx]

Thanks your post has helped me very much!