Error: Save Failed

[biliati]

Gentlemen,
I'm having trouble inserting a new device in cacti. After saving messangem appears the following "Error: Save Failed." and debug "CMDPHP: Poller [0] ERROR: SQL Command Failed for Save Table 'host'. Error was 'Unknown column' device_threads 'in' field list''
Can anyone help?

[gandalf]

Which version of cacti is this, please?
R.

[cckid]

I'm having the same problem on version 0.8.8
I've tried changing my config.php file to log in with root access to ensure it wasn't a permissions issue but it did not work.

The following error appears in the cacti.log file. Although it looks to pertain to the poller, I did not find any other errors in any obvious log files.

Code: Select all

05/09/2012 01:50:06 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function  FROM plugin_hooks AS ph  LEFT JOIN plugin_config AS pc  ON pc.directory=ph.name  WHERE ph.status = 1 AND hook = 'poller_bottom'  AND ph.name IN ('settings', 'boost', 'dsstats')  UNION  SELECT pc.id, ph.name, ph.file, ph.function  FROM plugin_hooks AS ph  LEFT JOIN plugin_config AS pc  ON pc.directory=ph.name  WHERE ph.status = 1 AND hook = 'poller_bottom'  AND ph.name NOT IN ('settings', 'boost', 'dsstats')  ORDER BY id ASC"

[BSOD2600]

MySQL error 1146 = Message: Table '%s.%s' doesn't exist.

cacti technical support page. What tables are present?

[cckid]

Thanks for the reply.
These are the tables that I have in my cacti DB:

• cdef
  cdef_items
  colors
  data_input
  data_input_data
  data_input_fields
  data_local
  data_template
  data_template_data
  data_template_data_rra
  data_template_rrd
  graph_local
  graph_template_input
  graph_template_input_defs
  graph_templates
  graph_templates_gprint
  graph_templates_graph
  graph_templates_item
  graph_tree
  graph_tree_items
  host
  host_graph
  host_snmp_cache
  host_snmp_query
  host_template
  host_template_graph
  host_template_snmp_query
  poller
  poller_command
  poller_item
  poller_output
  poller_reindex
  poller_time
  rra
  rra_cf
  settings
  settings_graphs
  settings_tree
  snmp_query
  snmp_query_graph
  snmp_query_graph_rrd
  snmp_query_graph_rrd_sv
  snmp_query_graph_sv
  user_auth
  user_auth_perms
  user_auth_realm
  user_log
  version

Should I have a 'plugin_hooks' table?

[BSOD2600]

Should I have a 'plugin_hooks' table?

Yes.

This a fresh install of cacti 0.8.8 or upgrade? you know 0.8.8a is out too, right?

[cckid]

This was a fresh install via RPMForge on a clean CentOS6 box.
I downloaded the 0.8.8 source and imported the SQL database from it. It seems to have fixed the issue as I was able to add a new device!
Thanks for the hints!

[BSOD2600]

This was a fresh install via RPMForge on a clean CentOS6 box.

You might want to send a note to the package maintainers to update the installer...