Ad Widget

Collapse

1.1beta10 - Templates and graph problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mos
    Junior Member
    • May 2006
    • 2

    #1

    1.1beta10 - Templates and graph problem

    create a graph for Host.UNIX template ; for example cpu_load; this is an example output:

    Id Name
    47 cpu_load


    now create a new host (from host menu) and assign it to template Host.UNIX -> and you have an SQL error

    SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
    Query: insert into graphs (name,width,height,yaxistype,yaxismin,yaxismax,tem plateid,show_work_period,show_triggers) values ('cpu_load',900,200,0,0.0000, 100.0000,47,,)


    and now try this -> delete the graph 47 (cpu_load) from the Graphs menu = for the Host.UNIX you should have No graphs defined for Host.UNIX

    now do the same from beginning = create a graph for Host.UNIX template ; for cpu_load;this is an example output:

    Id Name
    50 cpu_load


    system will update all hosts which have Host.UNIX as template and add graphs without any error.

    The problem for this error is that you have SQL error when you try to add new host and your template has some graphs defined!!
    Last edited by mos; 21-05-2006, 08:25.
  • crs9
    Member
    • Feb 2006
    • 35

    #2
    Host graph issue

    I too am having this same issue with adding existing templates to new hosts.

    Thanks

    Comment

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

      #3
      Fixed. Wait for 1.1beta12.
      Alexei Vladishev
      Creator of Zabbix, Product manager
      New York | Tokyo | Riga
      My Twitter

      Comment

      Working...