Monitor Plugin Problem

Addons for Cacti and discussion about those addons

Moderators: Moderators, Developers

Post Reply
Author
Message
mario1234
Posts: 1
Joined: Wed Mar 09, 2016 2:01 pm

Monitor Plugin Problem

#1 Post by mario1234 » Wed Mar 09, 2016 2:05 pm

After instaling Cacti from GIT there is a problem with monitor plugin:

03/09/2016 07:57:40 PM - CMDPHP ERROR: SQL Assoc Failed!, Error:1054, SQL:"select graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.id, host.description, host.status, host.hostname, host.cur_time, host.status_rec_date, host.status_fail_date, host.availability from graph_tree_items left join host on (host.id=graph_tree_items.host_id) where graph_tree_items.graph_tree_id=3 and ((host.disabled = '' and host.monitor = 'on') or (title != ''))and host.status < 2 and host.id > 0 and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/09/2016 07:57:40 PM - CMDPHP ERROR: SQL Assoc Failed!, Error: Unknown column 'graph_tree_items.order_key' in 'field list'
03/09/2016 07:57:40 PM - CMDPHP SQL Backtrace: (/plugins/monitor/monitor.php: 57 get_host_down_by_permission)(/plugins/monitor/monitor.php: 796 get_host_tree_array)(/plugins/monitor/monitor.php: 860 db_fetch_assoc)(/lib/database.php: 278 db_fetch_assoc_prepared)(/lib/database.php: 316 cacti_debug_backtrace)
03/09/2016 07:57:40 PM - CMDPHP ERROR: SQL Assoc Failed!, Error:1054, SQL:"select graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.id, host.description, host.status, host.hostname, host.cur_time, host.status_rec_date, host.status_fail_date, host.availability from graph_tree_items left join host on (host.id=graph_tree_items.host_id) where graph_tree_items.graph_tree_id=5 and ((host.disabled = '' and host.monitor = 'on') or (title != ''))and host.status < 2 and host.id > 0 and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/09/2016 07:57:40 PM - CMDPHP ERROR: SQL Assoc Failed!, Error: Unknown column 'graph_tree_items.order_key' in 'field list'
03/09/2016 07:57:40 PM - CMDPHP SQL Backtrace: (/plugins/monitor/monitor.php: 57 get_host_down_by_permission)(/plugins/monitor/monitor.php: 796 get_host_tree_array)(/plugins/monitor/monitor.php: 860 db_fetch_assoc)(/lib/database.php: 278 db_fetch_assoc_prepared)(/lib/database.php: 316 cacti_debug_backtrace)
03/09/2016 07:57:40 PM - CMDPHP ERROR: SQL Assoc Failed!, Error:1054, SQL:"select graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.id, host.description, host.status, host.hostname, host.cur_time, host.status_rec_date, host.status_fail_date, host.availability from graph_tree_items left join host on (host.id=graph_tree_items.host_id) where graph_tree_items.graph_tree_id=4 and ((host.disabled = '' and host.monitor = 'on') or (title != ''))and host.status < 2 and host.id > 0 and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
03/09/2016 07:57:40 PM - CMDPHP ERROR: SQL Assoc Failed!, Error: Unknown column 'graph_tree_items.order_key' in 'field list'
03/09/2016 07:57:40 PM - CMDPHP SQL Backtrace: (/plugins/monitor/monitor.php: 57 get_host_down_by_permission)(/plugins/monitor/monitor.php: 796 get_host_tree_array)(/plugins/monitor/monitor.php: 860 db_fetch_assoc)(/lib/database.php: 278 db_fetch_assoc_prepared)(/lib/database.php: 316 cacti_debug_backtrace)

What to do? How to diagnose that?

User avatar
Osiris
Cacti Pro User
Posts: 835
Joined: Mon Jan 05, 2015 10:10 am

Re: Monitor Plugin Problem

#2 Post by Osiris » Tue Dec 20, 2016 8:00 pm

These things should all be fixed by now.
Before history, there was a paradise, now dust.

Post Reply