Missing Custom Data

[jackouille]

Where is it?
[root@cacti4 ~]# find / -name database_audit.php
[root@cacti4 ~]#

And on another server, same:
[root@cacti2 cacti]# find / -name database* | grep cacti
/root/cacti-1.2.26/lib/database.php
/root/cacti-1.2.26/include/fa/svgs/solid/database.svg
/usr/share/cacti/lib/database.php
/usr/share/cacti/include/fa/svgs/solid/database.svg
/usr/share/cacti/plugins/syslog/database.php
/usr/share/cacti/plugins/thold/includes/database.php
[root@cacti2 cacti]#

[TheWitness]

It's in the cli directory. It might be audit_database.php. Note that if this is 1.3, you should run the upgrade_database.php with the forcever=1.2.20 or something like that. We have not fully regression checked 1.3. I've been on sabbatical for a while due to family issues. So, our whole release schedule went up in smoke.

[jackouille]

Yeah great thanks, here is output):
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
SUCCESS: Loaded the Audit Schema
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_graph'
ERROR Col: 'image_format_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'
ERROR Col: 'auto_scale_opts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_item'
ERROR Col: 'color_template', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_graph_item'
ERROR Col: 'color_template', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11) unsigned'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_items' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'audit_log' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_devices'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'snmp', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'known', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'up', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'time', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rule_items' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rules' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_ips' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_match_rule_items' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_networks' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_processes'
ERROR Col: 'pid', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp_items'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'snmp_retries', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(11) unsigned'
ERROR Col: 'max_oids', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_templates'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'
ERROR Col: 'host_template', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rule_items' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rules' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'cdef' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'cdef_items'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'color_template_items'
ERROR Col: 'color_template_item_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'color_templates' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'colors' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'dashboard_graphs' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_debug'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11) unsigned'
ERROR Col: 'started', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'done', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'user', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'datasource', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'issue', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input'
ERROR Col: 'type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'
WARNING Index: 'name', does not exist in default Cacti. Dropping.

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_data'
WARNING Index: 'data_input_field_id', does not exist in default Cacti. Dropping.

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_fields' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_local'
ERROR Index: 'host_id_snmp_query_id', is missing from 'data_local'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_cf' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_rra' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_action'
ERROR Col: 'action', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_temp'
ERROR Col: 'in_cacti', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_daily'
ERROR Col: 'average', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'
ERROR Col: 'peak', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly'
ERROR Col: 'average', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'
ERROR Col: 'peak', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_cache'
ERROR Col: 'value', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_last'
ERROR Col: 'calculated', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_monthly'
ERROR Col: 'average', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'
ERROR Col: 'peak', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_weekly'
ERROR Col: 'average', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'
ERROR Col: 'peak', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_yearly'
ERROR Col: 'average', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'
ERROR Col: 'peak', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_template' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_data' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_rrd'
WARNING Index: 'data_source_name', does not exist in default Cacti. Dropping.

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'external_links'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'sortorder', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_local' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input_defs'
ERROR Col: 'graph_template_input_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'mediumint(8) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_gprint' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_graph'
ERROR Col: 'image_format_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'
ERROR Col: 'auto_scale_opts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_item'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'
ERROR Col: 'consolidation_function_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree'
ERROR Col: 'locked', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree_items'
WARNING Index: 'parent', does not exist in default Cacti. Dropping.

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'ping_port', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'ping_timeout', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'ping_retries', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'max_oids', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'device_threads', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'
WARNING Col: 'manage', does not exist in default Cacti. Plugin possible
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'
ERROR Col: 'total_polls', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'failed_polls', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
WARNING Index: 'poller_id', does not exist in default Cacti. Dropping.

ERRORS: 11, WARNINGS: 1
---------------------------------------------------------------------------------------------
Checking Table: 'host_graph' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_cache'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_query' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_template' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_graph' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_snmp_query' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'manage_admin_link' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_alerts' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_groups' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_host' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_poller_output' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_process' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_services' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_sites' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_tcp' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'manage_uptime_method' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'notification_queue' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_aggregate_color_template_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_aggregate_color_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_autom8_graph_rule_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_autom8_graph_rules' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_autom8_match_rule_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_autom8_tree_rule_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_autom8_tree_rules' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_config'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_db_changes' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_discover_hosts' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_discover_template' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_dpdiscover_hosts' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_dpdiscover_template' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_fix64bit' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_hooks'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_credentials' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_dhcp' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_dns' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_interfaces' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_lists' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_mac2hostname' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_processes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_processor' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_queues' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_storage' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_system' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_system_health' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_trees' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_users' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_wireless_aps' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_mikrotik_wireless_registrations' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_dashboards' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_notify_history' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_reboot_history' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_uptime' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_notification_lists' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_realms' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_cache_measurands' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_cache_reports' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_cache_variables' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_data_items' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_data_source_items' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_data_template_groups' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_measurands' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_presets' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_recipients' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_reports' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_rvars' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_templates' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_reportit_variables' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_rrdclean' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_rrdclean_action' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_slowlog' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_slowlog_details' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_slowlog_details_methods' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_slowlog_details_tables' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_slowlog_methods' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_slowlog_tables' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_spikekill_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_contacts' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_daemon_data' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_device_template' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_failed' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_template' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_log' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_template_contact' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_threshold_contact' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'poller'
ERROR Col: 'dbretries', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'
ERROR Col: 'sync_interval', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'requires_sync', Attribute 'Type' invalid. Should be: 'char(2)', Is: 'char(3)'
ERROR Col: 'requires_sync', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_command' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_data_template_field_mappings' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_item'
ERROR Col: 'action', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'rrd_num', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_local_data_ids' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_processes' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_realtime' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_reindex'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_resource_cache' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_time'
ERROR Col: 'pid', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'processes'
ERROR Col: 'timeout', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'reports'
ERROR Col: 'offset', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'reports_items'
ERROR Col: 'item_type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'site_id', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'
ERROR Col: 'host_template_id', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'
ERROR Col: 'host_id', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'
ERROR Col: 'graph_template_id', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'
ERROR Col: 'align', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'rrdcheck' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'sessions' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings_graphs' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_tree'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user_group' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'sites' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph'
WARNING Index: 'graph_template_id', does not exist in default Cacti. Dropping.
WARNING Index: 'snmp_query_id', does not exist in default Cacti. Dropping.

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd_sv' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_sv' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_notifications' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_textual_conventions' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'
ERROR Col: 'max_log_size', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'snmp_message_type', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers_notifications'
ERROR Col: 'manager_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_mibs'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_notifications_log'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12)'
ERROR Col: 'severity', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'
ERROR Col: 'manager_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'syslog' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_alert' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_facilities' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_host_facilities' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_hosts' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_incoming' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_logs' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_priorities' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_remove' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_removed' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_reports' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'syslog_statistics' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'table_columns' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'table_indexes' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'thold_data' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'thold_template' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth'
ERROR Col: 'login_opts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'
ERROR Col: 'policy_graphs', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_trees', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_hosts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_graph_templates', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'lastchange', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int(12)'
ERROR Col: 'lastlogin', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int(12)'
ERROR Col: 'lastfail', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12)'
ERROR Col: 'reset_perms', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 9, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_cache' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group'
ERROR Col: 'login_opts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'
ERROR Col: 'policy_graphs', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_trees', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_hosts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_graph_templates', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_members' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_perms'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_realm' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_perms'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_realm' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_row_cache' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains'
ERROR Col: 'defdomain', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains_ldap' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_log'
ERROR Col: 'result', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'vdef' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'vdef_items'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'version' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_auth' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_data' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_groups' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_maps' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_settings' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
ERRORS are fixable using the --repair option. WARNINGS will not be repaired
due to ambiguous use of the column.
---------------------------------------------------------------------------------------------
[root@cacti cli]#

[jackouille]

I performed the DB repair on my test environment that runs version 1.2.26 but I'm still facing the original issue with Custom Data fields asked to be filled.

[TheWitness]

What MariaDB version are you running?

[TheWitness]

There was a date input repair function in one of the version upgrade scripts. May have been 1.2.24. You should find that version upgrade script and the do a upgrade_datsbase.php run with the --forcever=version_thst_included_thst_function(eg 1.2.24)

[TheWitness]

I just reread your first post and noted something.

Edit the graph template and re-save it. I just noted this. See if that gets it. Also, upload your data device template to a cacti bug on GitHub. Include all dependencies.

[jackouille]

I'm using Maria version 11.2.3
Attached you have one graph template.

[TheWitness]

Sorry, I'm an idiot. Edit the "Data Template" for this Data Query and note the three Checked boxes. You simply need to edit it and then save it. Then, creating new Graphs should not prompt for that data. They should be checked and you should not be able to uncheck them. If you can, there are bitter problems. Anyway, if they are not toggleable, you should simply be able to re-save the Data Template and problem solved.

[jackouille]

You are the boss yes !!!
Unfortunately I never changed the default Traffic DS by myself, it maybe happens during one upgrade.
By the way I'm still stuck because I can't change it, please check attached pic.

How shall I do ?

[TheWitness]

Hit save. See if that fixes it.

[TheWitness]

Also, did you run the database repair option?

[jackouille]

Yes DB repair was performed.
Saving the template doesn't change the result, it's still not possible to disable the values from GUI. Maybe in DB ?

[TheWitness]

Dump your database and email to TheWitness at Cacti dot net.

[jackouille]

Does the DB export helps you?