Ad Widget

Collapse

Problem with Configuration -> Graphs

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • maksim
    Junior Member
    • Jul 2007
    • 5

    #1

    Problem with Configuration -> Graphs

    Then i select Group -> all and Host -> all , i get this error
    Code:
        * 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/www/zabbix/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/www/zabbix/include/db.inc.php:414]
    FreeBSD 6.2
    zabbix-1.4.2,1 from port's
  • nelsonab
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2006
    • 1233

    #2
    I just came across this error myself. Line 348 in graphs.php should say 'where' not 'while'.
    RHCE, author of zbxapi
    Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
    Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

    Comment

    Working...