search

Cacti / plugin_gexport

Cacti Graph Export Plugin
GNU General Public License v2.0
12 stars 9 forks source link

Error when defining a new Graph Export Definition -- A DB Exec Failed #2

Closed dsclassen closed 7 years ago

dsclassen commented 7 years ago

received this error when attempting to create a new Graph Export Definition:

2017-01-11 10:56:31 - ERROR PHP NOTICE: Undefined index: next_start in file: /cacti/lib/database.php  on line: 863
2017-01-11 10:56:31 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/gexport/gexport.php: 46 export_form_save)(/plugins/gexport/gexport.php: 131 sql_save)(/lib/database.php: 863 CactiErrorHandler)(/lib/functions.php: 4206 cacti_debug_backtrace)
2017-01-11 10:56:31 - ERROR PHP NOTICE: Undefined index: next_start in file: /cacti/lib/database.php  on line: 864
2017-01-11 10:56:31 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/gexport/gexport.php: 46 export_form_save)(/plugins/gexport/gexport.php: 131 sql_save)(/lib/database.php: 864 CactiErrorHandler)(/lib/functions.php: 4206 cacti_debug_backtrace)
2017-01-11 10:56:31 - ERROR PHP NOTICE: Undefined index: next_start in file: /cacti/lib/database.php  on line: 865
2017-01-11 10:56:31 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/gexport/gexport.php: 46 export_form_save)(/plugins/gexport/gexport.php: 131 sql_save)(/lib/database.php: 865 CactiErrorHandler)(/lib/functions.php: 4206 cacti_debug_backtrace)
2017-01-11 10:56:31 - ERROR PHP NOTICE: Undefined index: next_start in file: /cacti/lib/database.php  on line: 866
2017-01-11 10:56:31 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/gexport/gexport.php: 46 export_form_save)(/plugins/gexport/gexport.php: 131 sql_save)(/lib/database.php: 866 CactiErrorHandler)(/lib/functions.php: 4206 cacti_debug_backtrace)
2017-01-11 10:56:31 - 5 ERROR: A DB Exec Failed!, Error: Unknown column 'next_start' in 'field list'
2017-01-11 10:56:31 - CMDPHP SQL Backtrace: (/plugins/gexport/gexport.php: 46 export_form_save)(/plugins/gexport/gexport.php: 131 sql_save)(/lib/database.php: 889 _db_replace)(/lib/database.php: 836 db_execute)(/lib/database.php: 110 db_execute_prepared)(/lib/database.php: 174 cacti_debug_backtrace)
2017-01-11 10:56:31 - DBCALL ERROR: SQL Save Failed for Table 'graph_exports'.  SQL:'INSERT INTO graph_exports (`id`, `name`, `export_type`, `enabled`, `export_presentation`, `export_effective_user`, `export_expand_hosts`, `export_theme`, `graph_tree`, `graph_site`, `graph_width`, `graph_height`, `graph_thumbnails`, `graph_perpage`, `graph_columns`, `graph_max`, `export_directory`, `export_temp_directory`, `export_timing`, `export_skip`, `export_hourly`, `export_daily`, `export_sanitize_remote`, `export_host`, `export_port`, `export_passive`, `export_user`, `export_password`, `export_private_key_path`, `next_start`) VALUES (0, 'New Graph Export', 'local', 'on', 'preview', 0, 'off', 'modern', '', '', 300, 100, '', 20, 2, 2000, '/cact/cacti_rt_graphs', '/tmp/', 'periodic', 5, '00', '00:00', '', '', 0, '', '', '', '', '2017-01-11 11:01:00') ON DUPLICATE KEY UPDATE `name`=VALUES(`name`), `export_type`=VALUES(`export_type`), `enabled`=VALUES(`enabled`), `export_presentation`=VALUES(`export_presentation`), `export_effective_user`=VALUES(`export_effective_user`), `export_expand_hosts`=VALUES(`export_expand_hosts`), `export_theme`=VALUES(`export_theme`), `graph_tree`=VALUES(`graph_tree`), `graph_site`=VALUES(`graph_site`), `graph_width`=VALUES(`graph_width`), `graph_height`=VALUES(`graph_height`), `graph_thumbnails`=VALUES(`graph_thumbnails`), `graph_perpage`=VALUES(`graph_perpage`), `graph_columns`=VALUES(`graph_columns`), `graph_max`=VALUES(`graph_max`), `export_directory`=VALUES(`export_directory`), `export_temp_directory`=VALUES(`export_temp_directory`), `export_timing`=VALUES(`export_timing`), `export_skip`=VALUES(`export_skip`), `export_hourly`=VALUES(`export_hourly`), `export_daily`=VALUES(`export_daily`), `export_sanitize_remote`=VALUES(`export_sanitize_remote`), `export_host`=VALUES(`export_host`), `export_port`=VALUES(`export_port`), `export_passive`=VALUES(`export_passive`), `export_user`=VALUES(`export_user`), `export_password`=VALUES(`export_password`), `export_private_key_path`=VALUES(`export_private_key_path`), `next_start`=VALUES(`next_start`)'
cigamit commented 7 years ago

The schema changed in the last days to properly support scheduling. Before it was a hack. You simply need to either re-install, or add the column by hand. We hope to get these things released soon.