Cacti 1.1.2 Poller Command SQL error

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

Moderators: Developers, Moderators

Post Reply
ironman820
Posts: 2
Joined: Tue Apr 04, 2017 10:56 am

Cacti 1.1.2 Poller Command SQL error

Post by ironman820 »

Code: Select all

2017-04-04 11:56:11 - CMDPHP SQL Backtrace: (/poller_commands.php: 112 run_data_query)(/lib/data_query.php: 146 automation_execute_data_query)(/lib/api_automation.php: 2065 db_fetch_assoc)(/lib/database.php: 320 db_fetch_assoc_prepared)(/lib/database.php: 359 cacti_debug_backtrace)
2017-04-04 11:56:11 - DBCALL ERROR: SQL Assoc Failed!, Error: Unknown column 'ht.name' in 'where clause'
2017-04-04 11:56:11 - DBCALL ERROR: SQL Assoc Failed!, Error:1054, SQL:"SELECT h.id AS host_id, h.hostname, h.description, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON h.host_template_id=ht.id WHERE ( `ht.name` LIKE '%Cambium Canopy%') AND h.id=15329"
2017-04-04 11:56:11 - CMDPHP SQL Backtrace: (/poller_commands.php: 112 run_data_query)(/lib/data_query.php: 146 automation_execute_data_query)(/lib/api_automation.php: 2065 db_fetch_assoc)(/lib/database.php: 320 db_fetch_assoc_prepared)(/lib/database.php: 359 cacti_debug_backtrace)
2017-04-04 11:56:11 - DBCALL ERROR: SQL Assoc Failed!, Error: Unknown column 'h.description' in 'where clause'
2017-04-04 11:56:11 - DBCALL ERROR: SQL Assoc Failed!, Error:1054, SQL:"SELECT h.id AS host_id, h.hostname, h.description, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON h.host_template_id=ht.id WHERE ( `h.description` IS NOT NULL AND `h.snmp_version` >= '2' AND `ht.name` NOT LIKE '%Cambium%') AND h.id=15329"
I have seen this in our server that we recently updated to 1.1.2. Graphs are updating after I found an issue with the spine config, now I am getting these messages during polling. Can anyone point me in the right direction as to what these errors are and how to correct them?

CentOS 6.8
PHP 5.5
MySQL 5.6
Spine 1.1.2
RRDTool 1.3.8
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: Cacti 1.1.2 Poller Command SQL error

Post by Osiris »

This is fixed in 1.1.3.
Before history, there was a paradise, now dust.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest