SQL Save on table 'host': Column 'bulk_walk_size' does not exist

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
tristanB
Posts: 4
Joined: Tue Mar 14, 2023 4:33 am

SQL Save on table 'host': Column 'bulk_walk_size' does not exist

Post by tristanB »

I have a problem after update cacti.
SQL Save on table 'host': Column 'bulk_walk_size' does not exist, unable to save!
Save Failed.
How create this table?
Thanks
Top
User avatar
macan
Cacti Guru User
Posts: 1106
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: SQL Save on table 'host': Column 'bulk_walk_size' does not exist

Post by macan »

cacti version?
Try run
cd /path/to/cacti/cli
php -q audit_database.php --report
Let the Cacti grow!
Top
tristanB
Posts: 4
Joined: Tue Mar 14, 2023 4:33 am

Re: SQL Save on table 'host': Column 'bulk_walk_size' does not exist

Post by tristanB »

Hello macan

Checking Table: 'aggregate_graph_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_item' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_graph_item' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_devices' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rule_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rules' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_ips' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_match_rule_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_networks' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_processes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rule_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rules' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'cdef' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'cdef_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'color_template_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'color_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'colors' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_debug' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_input' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_data' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_fields' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_local' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_cf' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_rra' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_action' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_temp' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_daily' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_last' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_monthly' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_weekly' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_yearly' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_template' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_data' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_rrd' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'external_links' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_local' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input_defs' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_gprint' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_item' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_query' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_template' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_snmp_query' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_config' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_db_changes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_hooks' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_realms' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_command' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_data_template_field_mappings' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_item' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_processes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_realtime' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_reindex' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_resource_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_time' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'reports' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'reports_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'rrdcheck' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'sessions' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_tree' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user_group' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'sites' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd_sv' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_sv' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_notifications' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_textual_conventions' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers_notifications' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_mibs' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_notifications_log' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'table_columns' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'table_indexes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_members' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_perms' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_realm' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_perms' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_realm' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_row_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains_ldap' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_log' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'vdef' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'vdef_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'version' - Does not Exist. Possible Plugin
Top
User avatar
macan
Cacti Guru User
Posts: 1106
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: SQL Save on table 'host': Column 'bulk_walk_size' does not exist

Post by macan »

did you import SQL database?
https://docs.cacti.net/README.md#cacti-installation
Let the Cacti grow!
Top
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: SQL Save on table 'host': Column 'bulk_walk_size' does not exist

Post by TheWitness »

Either /var/www/html/cacti/docs/audit_schema.sql is missing or the user running the script does not have access to it. Might be a packaging issue. If you installed by RPM of DPK, you need to inform the package maintainer.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
tristanB
Posts: 4
Joined: Tue Mar 14, 2023 4:33 am

Re: SQL Save on table 'host': Column 'bulk_walk_size' does not exist

Post by tristanB »

Yes i have upgrade version 0.8 with yum install centos 7. I have access interface and my graph but i can't install new host.
/var/www/html/ is empty
Top
tristanB
Posts: 4
Joined: Tue Mar 14, 2023 4:33 am

Re: SQL Save on table 'host': Column 'bulk_walk_size' does not exist

Post by tristanB »

Thank you very mutch macan and TheWitness.
I have copy docs in folders cacti and run php - q audit.... --repair.
Now it's good :)
Good day
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 1 guest