Cacti / cacti

Cacti ™
http://www.cacti.net
GNU General Public License v2.0
1.63k stars 404 forks source link

Error when try create new graph - SNMP - Generic OID Template #337

Closed ObGoN closed 7 years ago

ObGoN commented 7 years ago

Cact 1.0.3 fresh install. PHP 5.3.3 (cli) (built: Aug 11 2016 20:33:53) mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

2017-02-24 10:00:11 - DBCALL ERROR: SQL Save Failed for Table 'graph_templates_graph'. SQL:'INSERT INTO graph_templates_graph (id, local_graph_template_graph_id, local_graph_id, graph_template_id, title, vertical_label, image_format_id, height, width, base_value, slope_mode, auto_scale, auto_scale_opts, auto_scale_log, scale_log_units, auto_scale_rigid, upper_limit, lower_limit, unit_value, unit_exponent_value, unit_length, no_gridfit, alt_y_grid, right_axis, right_axis_label, right_axis_format, right_axis_formatter, left_axis_formatter, auto_padding, dynamic_labels, force_rules_legend, tab_width, legend_position, legend_direction) VALUES (0, 0, 14, 34, NULL, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) ON DUPLICATE KEY UPDATE local_graph_template_graph_id=VALUES(local_graph_template_graph_id), local_graph_id=VALUES(local_graph_id), graph_template_id=VALUES(graph_template_id), title=VALUES(title), vertical_label=VALUES(vertical_label), image_format_id=VALUES(image_format_id), height=VALUES(height), width=VALUES(width), base_value=VALUES(base_value), slope_mode=VALUES(slope_mode), auto_scale=VALUES(auto_scale), auto_scale_opts=VALUES(auto_scale_opts), auto_scale_log=VALUES(auto_scale_log), scale_log_units=VALUES(scale_log_units), auto_scale_rigid=VALUES(auto_scale_rigid), upper_limit=VALUES(upper_limit), lower_limit=VALUES(lower_limit), unit_value=VALUES(unit_value), unit_exponent_value=VALUES(unit_exponent_value), unit_length=VALUES(unit_length), no_gridfit=VALUES(no_gridfit), alt_y_grid=VALUES(alt_y_grid), right_axis=VALUES(right_axis), right_axis_label=VALUES(right_axis_label), right_axis_format=VALUES(right_axis_format), right_axis_formatter=VALUES(right_axis_formatter), left_axis_formatter=VALUES(left_axis_formatter), auto_padding=VALUES(auto_padding), dynamic_labels=VALUES(dynamic_labels), force_rules_legend=VALUES(force_rules_legend), tab_width=VALUES(tab_width), legend_position=VALUES(legend_position), legend_direction=VALUES(legend_direction)' 2017-02-24 10:00:11 - CMDPHP SQL Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 709 sql_save)(/lib/database.php: 943 _db_replace)(/lib/database.php: 890 db_execute)(/lib/database.php: 113 db_execute_prepared)(/lib/database.php: 178 cacti_debug_backtrace) 2017-02-24 10:00:11 - 5 ERROR: A DB Exec Failed!, Error: Column 'title' cannot be null 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: legend_direction in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: legend_position in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: tab_width in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: force_rules_legend in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: dynamic_labels in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: auto_padding in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: left_axis_formatter in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: right_axis_formatter in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: right_axis_format in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: right_axis_label in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:11 - ERROR PHP NOTICE: Undefined index: right_axis in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: alt_y_grid in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: no_gridfit in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: unit_length in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: unit_exponent_value in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: unit_value in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: lower_limit in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: upper_limit in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: auto_scale_rigid in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: scale_log_units in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: auto_scale_log in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: auto_scale_opts in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: auto_scale in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: slope_mode in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: base_value in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: width in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: height in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: image_format_id in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: vertical_label in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: title in file: /var/www/cacti/lib/template.php on line: 704 2017-02-24 10:00:10 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 691 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace) 2017-02-24 10:00:10 - ERROR PHP NOTICE: Undefined index: id in file: /var/www/cacti/lib/template.php on line: 691

cigamit commented 7 years ago

Please explain the exact process you went through to generate this error. Step by step please.

ObGoN commented 7 years ago

Devices > Add > (Description, Hostname, SNMP Community) > Create > Create Graphs for this Device (SNMP - Generic OID Template) > Create > (Title, Vertical Label, Legend Text, Name, OID) > Create > ERROR (Data Source created and no graph)

Settings > Graph/Data Source Creation Method (Advanced) > Save; Graphs > Add > Selected Graph Template (SNMP - Generic OID Template) + Device (SBC-1) > Create > ERROR (no graph)

Fresh install 1.0.4: 2017-02-27 13:01:12 - CMDPHP SQL Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1281 db_execute_prepared)(/lib/database.php: 178 cacti_debug_backtrace) 2017-02-27 13:01:12 - CMDPHP ERROR: A DB Exec Failed!, Error: Column count doesn't match value count at row 1 2017-02-27 13:01:12 - DBCALL ERROR: A DB Exec Failed!, Error:1136, SQL:"REPLACE INTO data_input_data (data_input_field_id, data_template_data_id, t_value, value) VALUES (?, ?, ?)' 2017-02-27 13:01:12 - DBCALL ERROR: SQL Save Failed for Table 'graph_templates_graph'. SQL:'INSERT INTO graph_templates_graph (id, local_graph_template_graph_id, local_graph_id, graph_template_id, title, vertical_label, image_format_id, height, width, base_value, slope_mode, auto_scale, auto_scale_opts, auto_scale_log, scale_log_units, auto_scale_rigid, upper_limit, lower_limit, unit_value, unit_exponent_value, unit_length, no_gridfit, alt_y_grid, right_axis, right_axis_label, right_axis_format, right_axis_formatter, left_axis_formatter, auto_padding, dynamic_labels, force_rules_legend, tab_width, legend_position, legend_direction) VALUES (0, 0, 6, 34, NULL, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) ON DUPLICATE KEY UPDATE local_graph_template_graph_id=VALUES(local_graph_template_graph_id), local_graph_id=VALUES(local_graph_id), graph_template_id=VALUES(graph_template_id), title=VALUES(title), vertical_label=VALUES(vertical_label), image_format_id=VALUES(image_format_id), height=VALUES(height), width=VALUES(width), base_value=VALUES(base_value), slope_mode=VALUES(slope_mode), auto_scale=VALUES(auto_scale), auto_scale_opts=VALUES(auto_scale_opts), auto_scale_log=VALUES(auto_scale_log), scale_log_units=VALUES(scale_log_units), auto_scale_rigid=VALUES(auto_scale_rigid), upper_limit=VALUES(upper_limit), lower_limit=VALUES(lower_limit), unit_value=VALUES(unit_value), unit_exponent_value=VALUES(unit_exponent_value), unit_length=VALUES(unit_length), no_gridfit=VALUES(no_gridfit), alt_y_grid=VALUES(alt_y_grid), right_axis=VALUES(right_axis), right_axis_label=VALUES(right_axis_label), right_axis_format=VALUES(right_axis_format), right_axis_formatter=VALUES(right_axis_formatter), left_axis_formatter=VALUES(left_axis_formatter), auto_padding=VALUES(auto_padding), dynamic_labels=VALUES(dynamic_labels), force_rules_legend=VALUES(force_rules_legend), tab_width=VALUES(tab_width), legend_position=VALUES(legend_position), legend_direction=VALUES(legend_direction)' 2017-02-27 13:01:12 - CMDPHP SQL Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 709 sql_save)(/lib/database.php: 943 _db_replace)(/lib/database.php: 890 db_execute)(/lib/database.php: 113 db_execute_prepared)(/lib/database.php: 178 cacti_debug_backtrace) 2017-02-27 13:01:12 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'title' cannot be null 2017-02-27 13:01:12 - DBCALL ERROR: A DB Exec Failed!, Error:1048, SQL:"INSERT INTO graph_templates_graph (id, local_graph_template_graph_id, local_graph_id, graph_template_id, title, vertical_label, image_format_id, height, width, base_value, slope_mode, auto_scale, auto_scale_opts, auto_scale_log, scale_log_units, auto_scale_rigid, upper_limit, lower_limit, unit_value, unit_exponent_value, unit_length, no_gridfit, alt_y_grid, right_axis, right_axis_label, right_axis_format, right_axis_formatter, left_axis_formatter, auto_padding, dynamic_labels, force_rules_legend, tab_width, legend_position, legend_direction) VALUES (0, 0, 6, 34, NULL, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) ON DUPLICATE KEY UPDATE local_graph_template_graph_id=VALUES(local_graph_template_graph_id), local_graph_id=VALUES(local_graph_id), graph_template_id=VALUES(graph_template_id), title=VALUES(title), vertical_label=VALUES(vertical_label), image_format_id=VALUES(image_format_id), height=VALUES(height), width=VALUES(width), base_value=VALUES(base_value), slope_mode=VALUES(slope_mode), auto_scale=VALUES(auto_scale), auto_scale_opts=VALUES(auto_scale_opts), auto_scale_log=VALUES(auto_scale_log), scale_log_units=VALUES(scale_log_units), auto_scale_rigid=VALUES(auto_scale_rigid), upper_limit=VALUES(upper_limit), lower_limit=VALUES(lower_limit), unit_value=VALUES(unit_value), unit_exponent_value=VALUES(unit_exponent_value), unit_length=VALUES(unit_length), no_gridfit=VALUES(no_gridfit), alt_y_grid=VALUES(alt_y_grid), right_axis=VALUES(right_axis), right_axis_label=VALUES(right_axis_label), right_axis_format=VALUES(right_axis_format), right_axis_formatter=VALUES(right_axis_formatter), left_axis_formatter=VALUES(left_axis_formatter), auto_padding=VALUES(auto_padding), dynamic_labels=VALUES(dynamic_labels), force_rules_legend=VALUES(force_rules_legend), tab_width=VALUES(tab_width), legend_position=VALUES(legend_position), legend_direction=VALUES(legend_direction)' 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: legend_direction in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: legend_position in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: tab_width in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: force_rules_legend in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: dynamic_labels in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: auto_padding in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: left_axis_formatter in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: right_axis_formatter in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: right_axis_format in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: right_axis_label in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: right_axis in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: alt_y_grid in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: no_gridfit in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: unit_length in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: unit_exponent_value in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: unit_value in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: lower_limit in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: upper_limit in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: auto_scale_rigid in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: scale_log_units in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: auto_scale_log in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: auto_scale_opts in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: auto_scale in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: slope_mode in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: base_value in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: width in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: height in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: image_format_id in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: vertical_label in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: title in file: /var/www/cacti/lib/template.php on line: 704 2017-02-27 13:01:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 114 host_new_graphs_save)(/graphs_new.php: 243 create_complete_graph_from_template)(/lib/template.php: 1022 change_graph_template)(/lib/template.php: 691 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:01:12 - ERROR PHP NOTICE: Undefined index: id in file: /var/www/cacti/lib/template.php on line: 691 2017-02-27 13:00:44 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs_new.php: 37 form_save)(/graphs_new.php: 106 host_new_graphs)(/graphs_new.php: 362 CactiErrorHandler)(/lib/functions.php: 4264 cacti_debug_backtrace) 2017-02-27 13:00:44 - ERROR PHP NOTICE: Undefined index: graph_template_name in file: /var/www/cacti/graphs_new.php on line: 362

cigamit commented 7 years ago

Okay, that helps. Checking now.

cigamit commented 7 years ago

Resolved, thanks!

ObGoN commented 7 years ago

This fixed: 2017-02-27 13:01:12 - DBCALL ERROR: A DB Exec Failed!, Error:1136, SQL:"REPLACE INTO data_input_data (data_input_field_id, data_template_data_id, t_value, value) VALUES (?, ?, ?)'

BUT not this: 2017-02-24 10:00:11 - DBCALL ERROR: SQL Save Failed for Table 'graph_templates_graph'. SQL:'INSERT INTO graph_templates_graph (id, local_graph_template_graph_id, local_graph_id, graph_template_id, title, vertical_label, image_format_id, height, width, base_value, slope_mode, auto_scale, auto_scale_opts, auto_scale_log, scale_log_units, auto_scale_rigid, upper_limit, lower_limit, unit_value, unit_exponent_value, unit_length, no_gridfit, alt_y_grid, right_axis, right_axis_label, right_axis_format, right_axis_formatter, left_axis_formatter, auto_padding, dynamic_labels, force_rules_legend, tab_width, legend_position, legend_direction) VALUES (0, 0, 14, 34, NULL, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) ON DUPLICATE KEY UPDATE local_graph_template_graph_id=VALUES(local_graph_template_graph_id), local_graph_id=VALUES(local_graph_id), graph_template_id=VALUES(graph_template_id), title=VALUES(title), vertical_label=VALUES(vertical_label), image_format_id=VALUES(image_format_id), height=VALUES(height), width=VALUES(width), base_value=VALUES(base_value), slope_mode=VALUES(slope_mode), auto_scale=VALUES(auto_scale), auto_scale_opts=VALUES(auto_scale_opts), auto_scale_log=VALUES(auto_scale_log), scale_log_units=VALUES(scale_log_units), auto_scale_rigid=VALUES(auto_scale_rigid), upper_limit=VALUES(upper_limit), lower_limit=VALUES(lower_limit), unit_value=VALUES(unit_value), unit_exponent_value=VALUES(unit_exponent_value), unit_length=VALUES(unit_length), no_gridfit=VALUES(no_gridfit), alt_y_grid=VALUES(alt_y_grid), right_axis=VALUES(right_axis), right_axis_label=VALUES(right_axis_label), right_axis_format=VALUES(right_axis_format), right_axis_formatter=VALUES(right_axis_formatter), left_axis_formatter=VALUES(left_axis_formatter), auto_padding=VALUES(auto_padding), dynamic_labels=VALUES(dynamic_labels), force_rules_legend=VALUES(force_rules_legend), tab_width=VALUES(tab_width), legend_position=VALUES(legend_position), legend_direction=VALUES(legend_direction)' 2017-02-24 10:00:11 - CMDPHP SQL Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 709 sql_save)(/lib/database.php: 943 _db_replace)(/lib/database.php: 890 db_execute)(/lib/database.php: 113 db_execute_prepared)(/lib/database.php: 178 cacti_debug_backtrace) 2017-02-24 10:00:11 - 5 ERROR: A DB Exec Failed!, Error: Column 'title' cannot be null 2017-02-24 10:00:11 - CMDPHP PHP ERROR NOTICE Backtrace: (/graphs.php: 64 form_save)(/graphs.php: 166 change_graph_template)(/lib/template.php: 704 CactiErrorHandler)(/lib/functions.php: 4242 cacti_debug_backtrace)

cigamit commented 7 years ago

Found the root cause of this issue.

cigamit commented 7 years ago

This is resolved, but for you to resolve. Just import the attached template.

cacti_graph_templatesnmp-_generic_oid_template.xml.txt