Kallyx
commented
6 years ago Hi,
There was found in /cacti/lib/template.php a typing mistake for variable $title highlighted below.
db_execute('INSERT INTO data_template
(id,name,hash)
VALUES (0, ?, ?)',
array(**$totle**, get_hash_data_template(0)));
Hello,
After succeeded to import data query file(huawei.xml) and make it functional(indexing are working), I tried to import graph templates Cacti - Huawei SFP.xml and Cacti - Huawei Interface Power (Rx_Tx).xml but, it has returned the error below: The errors could be related to some fields that in meantime has been changed in Cacti database from my current Cacti version 1.1.2 to latest Cacti Version 1.1.28 and maybe the graph_template are newer released and fits with the latest cacti version(this is just an assumption). I checked and the error is related to Column name which is null, for some reason, but nut sure how this could be solved. If you need any other info, please let me know. Will appreciate any help. Thank you!
SQL:"INSERT INTO data_template (id, hash, name) VALUES (0, 'ab34c5cc314822ca3b456e8236f52fc2', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'name' cannot be null
All error logs:
2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - DBCALL ERROR: A DB Exec Failed!, Error:1048, SQL:"INSERT INTO data_template (id, hash, name) VALUES (0, 'ab34c5cc314822ca3b456e8236f52fc2', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'name' cannot be null 2017-12-08 14:48:34 - CMDPHP SQL Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 82 xml_to_data_template)(/lib/import.php: 576 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-12-08 14:48:34 - DBCALL ERROR: SQL Save Failed for Table 'data_template'. SQL:'INSERT INTO data_template (id, hash, name) VALUES (0, 'ab34c5cc314822ca3b456e8236f52fc2', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 72 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 72 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: hash_015540f96a3051dcbecbf8b402d05a848e in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - DBCALL ERROR: A DB Exec Failed!, Error:1048, SQL:"INSERT INTO data_template (id, hash, name) VALUES (0, '5540f96a3051dcbecbf8b402d05a848e', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'name' cannot be null 2017-12-08 14:48:34 - CMDPHP SQL Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 82 xml_to_data_template)(/lib/import.php: 576 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-12-08 14:48:34 - DBCALL ERROR: SQL Save Failed for Table 'data_template'. SQL:'INSERT INTO data_template (id, hash, name) VALUES (0, '5540f96a3051dcbecbf8b402d05a848e', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 72 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 72 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: hash_01823d80e868528523498eadda29620a19 in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - DBCALL ERROR: A DB Exec Failed!, Error:1048, SQL:"INSERT INTO data_template (id, hash, name) VALUES (0, '823d80e868528523498eadda29620a19', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'name' cannot be null 2017-12-08 14:48:34 - CMDPHP SQL Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 82 xml_to_data_template)(/lib/import.php: 576 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-12-08 14:48:34 - DBCALL ERROR: SQL Save Failed for Table 'data_template'. SQL:'INSERT INTO data_template (id, hash, name) VALUES (0, '823d80e868528523498eadda29620a19', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 72 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 72 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: hash_01db2505b22d1296e20dca74832d36b2da in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - DBCALL ERROR: A DB Exec Failed!, Error:1048, SQL:"INSERT INTO data_template (id, hash, name) VALUES (0, 'db2505b22d1296e20dca74832d36b2da', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'name' cannot be null 2017-12-08 14:48:34 - CMDPHP SQL Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 82 xml_to_data_template)(/lib/import.php: 576 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-12-08 14:48:34 - DBCALL ERROR: SQL Save Failed for Table 'data_template'. SQL:'INSERT INTO data_template (id, hash, name) VALUES (0, 'db2505b22d1296e20dca74832d36b2da', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 72 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 72 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: hash_003937a3ed866eb41ffb2c05ec922eeb39 in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - DBCALL ERROR: A DB Exec Failed!, Error:1048, SQL:"INSERT INTO graph_templates (id, hash, name) VALUES (0, '3937a3ed866eb41ffb2c05ec922eeb39', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'name' cannot be null 2017-12-08 14:48:34 - CMDPHP SQL Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 79 xml_to_graph_template)(/lib/import.php: 290 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-12-08 14:48:34 - DBCALL ERROR: SQL Save Failed for Table 'graph_templates'. SQL:'INSERT INTO graph_templates (id, hash, name) VALUES (0, '3937a3ed866eb41ffb2c05ec922eeb39', NULL) ON DUPLICATE KEY UPDATE hash=VALUES(hash), name=VALUES(name)' 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 72 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 72 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - ERROR PHP NOTICE: Undefined index: hash_20d62c52891f4f9688729a5bc9fad91b18 in file: /var/www/html/cacti/lib/import.php on line: 75 2017-12-08 14:48:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/templates_import.php: 34 form_save)(/templates_import.php: 87 import_xml_data)(/lib/import.php: 75 CactiErrorHandler)(/lib/functions.php: 4295 cacti_debug_backtrace) 2017-12-08 14:48:34 - CMDPHP IMPORT NOTE: Repairing 1 Damaged data_input_fields 2017-12-08 14:48:34 - CMDPHP WARNING: Could not find Cacti default matching hash for unknown system hash "35637c344d84d8aa3a4dc50e4a120b3f" for 1. No repair performed.