Ad Widget

Collapse

1.1.2 and Postgresql troubles

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • winamp
    Junior Member
    • Oct 2006
    • 7

    #1

    1.1.2 and Postgresql troubles

    Hello
    Having troubles while adding new graph... always get this error:

    Code:
    Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error at end of input at character 38 in /var/www/localhost/htdocs/zabbix-frontend/include/db.inc.php on line 108
    
    Warning: pg_fetch_row() expects parameter 1 to be resource, boolean given in /var/www/localhost/htdocs/zabbix-frontend/include/db.inc.php on line 216
    Error getting row
    and nothing being added.
    Same problem with items and hosts, but they appear after error displayed
  • winamp
    Junior Member
    • Oct 2006
    • 7

    #2
    These queries are trying to be executed:

    PHP Code:
    Query=select from profiles where userid=and idx='web.latest.groupid'
    Query=select from profiles where userid=and idx='web.latest.hostid'
    Query=select distinct h.hostid,h.host from hosts h where h.status<>4 order by h.host
    Query
    =select distinct h.hostid from hosts h where h.status<>and h.hostid=10100
    Query
    =select value from profiles where userid=and idx='web.latest.hostid'
    Query=select value from profiles where userid=and idx='web.latest.groupid'
    Query=select value from profiles where userid=and idx='web.menu.config.last'
    Query=select graphid from graphs where oid=

    Warningpg_exec() [function.pg-exec]: Query failedERRORsyntax error at end of input at character 38 in /var/www/localhost/htdocs/zabbix-frontend/include/db.inc.php on line 109

    Warning
    pg_fetch_row() expects parameter 1 to be resourceboolean given in /var/www/localhost/htdocs/zabbix-frontend/include/db.inc.php on line 217
    Error getting row 

    Comment

    • akuzn
      Junior Member
      • Sep 2006
      • 2

      #3
      I've get the same error on Zabbix 1.1.3 and PostgreSQL 8.1
      This thread helps:

      Comment

      • Alexei
        Founder, CEO
        Zabbix Certified Trainer
        Zabbix Certified SpecialistZabbix Certified Professional
        • Sep 2004
        • 5654

        #4
        The issues is fixed. Thanks for reporting this!
        Alexei Vladishev
        Creator of Zabbix, Product manager
        New York | Tokyo | Riga
        My Twitter

        Comment

        Working...