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!!
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!!
Comment