Looking further, I noticed that ALL of my Graph Templates no longer contain Graph Template Items. [See Screen-shot]
It seems that I can re-import a template and fix this problem. Unfortunately, I do not have templates to import for many of my graph templates.
Turning on debug output I receive this in the log (I added some comments):
- ' THE FOLLOWING LINE RETURNS ONE (1) ROW
06/06/2008 09:53:10 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where graph_template_id=18 and local_graph_id=0"
' THE FOLLOWING LINE RETURNS ONE (1) ROW
06/06/2008 09:53:10 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates where id=18"
' THE FOLLOWING LINE RETURNS TWO (2) ROWS
06/06/2008 09:53:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,name from graph_template_input where graph_template_id=18 order by name"
' THE FOLLOWING LINE RETURNS ONE (1) ROW
06/06/2008 09:53:10 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select name from graph_templates where id=18"
' ######### THE FOLLOWING LINE RETURNS AN EMPTY RECORD SET #########
06/06/2008 09:53:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.graph_type_id, graph_templates_item.consolidation_function_id, CONCAT_WS(' - ',data_template_data.name,data_template_rrd.data_source_name) as data_source_name, cdef.name as cdef_name, colors.hex from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join data_local on (data_template_rrd.local_data_id=data_local.id) left join data_template_data on (data_local.id=data_template_data.local_data_id) left join cdef on (cdef_id=cdef.id) left join colors on (color_id=colors.id) where graph_templates_item.graph_template_id=18 and graph_templates_item.local_graph_id=0 order by graph_templates_item.sequence"
' THE FOLLOWING LINE RETURNS THIRTY (30) ROWS
06/06/2008 09:53:08 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT graph_templates.id,graph_templates.name FROM graph_templates WHERE (graph_templates.name LIKE '%%%%') ORDER BY name ASC LIMIT 0,30"
' THE FOLLOWING LINE RETURNS ONE (1) ROW (COUNT=77)
06/06/2008 09:53:08 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT COUNT(graph_templates.id) FROM graph_templates WHERE (graph_templates.name LIKE '%%%%')"
I'm using Version 0.8.7b on Windows Server 2003.
