Ad Widget

Collapse

missing comma in select

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • drook
    Junior Member
    • Jun 2007
    • 3

    #1

    missing comma in select

    ===Cut===
    2414:20070613:111758 Query::select hosttemplateid hostgroupid from hosts_templates where templateid=10016 and hostid=1
    0021
    2414:20070613:111758 Query failed:PGRES_FATAL_ERROR:ERROR: syntax error at or near "hostgroupid" at character 23
    ===Cut===

    How can I solve that ?
    I know about "missing from" feature in postgres, but nothing about missing commas.

    Solaris 10 x86, Zabbix 1.4
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    Patch is attached.
    Attached Files
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • drook
      Junior Member
      • Jun 2007
      • 3

      #3
      Thanks a lot. That helped.

      The next trouble I'm standing at is that discovery started to work, and zabbix discovered some device with something weird in snmpwalk output. :/

      I got this in logs:

      ===Cut===
      11888:20070613:144935 Parameter [ifInOctets34] is not supported by agent on host [172.16.1.57] Old status [0]
      11890:20070613:144941 OID [1.3.6.1.2.1.2.2.1.16.30] value #2 has unknow type [81]
      11890:20070613:144941 Parameter [ifOutOctets30] is not supported by agent on host [172.16.1.57] Old status [0]
      11890:20070613:144941 Query::select 0,lastvalue from functions where functionid=???:???
      11890:20070613:144941 Query failed:PGRES_FATAL_ERROR:ERROR: syntax error at or near ":" at character 55
      ===Cut===

      If 172.16.1.57 really is that host - then it's a Cisco 2821 running multiple gre/gif tunnels.

      Comment

      Working...