Thold not sending email / Also unable to create thresholds

[mail3dexter]

First of all, just to tell you all, i have migrated from old cacti version to new cacti version on different box.

I have test emails via cacti and i am able to receive test emails.

I uninstalled thold from Plugin Management and reinstalled. After reinstalling, I recreated Threshold Templates.

I selected a Data Source and took Create Threshold from Template and it gave me Validation Error.

Also, the thold tab near Console tab is not opening for me, it takes forever and then dies.

I also tried creating a Threshold from Management --> Threshold however I couldnt see host in it. Basically the dropdown is completely blank. I have thousand's of devices in Cacti and for some reason its not showing.

Regarding Logs,
I see that Thold is working as per the logs.

Code: Select all

08/28/2015 12:06:18 PM - SYSTEM THOLD STATS: Time:0.0013 Tholds:0 TotalHosts:108 DownHosts:33 NewDownHosts:0
08/28/2015 12:06:18 PM - SYSTEM STATS: Time:76.7901 Method:cmd.php Processes:5 Threads:N/A Hosts:109 HostsPerProcess:22 DataSources:6235 RRDsProcessed:3300 

I also saw this error in the logs:

Code: Select all

08/28/2015 12:07:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT DISTINCT host.id, CONCAT_WS('',host.description,' (',host.hostname,')') AS name FROM (graph_templates_graph, host) LEFT JOIN graph_local ON (graph_local.host_id=host.id) LEFT JOIN graph_templates ON (graph_templates.id=graph_local.graph_template_id) LEFT JOIN user_auth_perms ON ((graph_templates_graph.local_graph_id=user_auth_perms.item_id AND user_auth_perms.type=1 AND user_auth_perms.user_id=) OR (host.id=user_auth_perms.item_id AND user_auth_perms.type=3 AND user_auth_perms.user_id=) OR (graph_templates.id=user_auth_perms.item_id AND user_auth_perms.type=4 AND user_auth_perms.user_id=)) WHERE graph_templates_graph.local_graph_id=graph_local.id ORDER BY name"
08/28/2015 12:07:19 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM user_auth WHERE id="
08/28/2015 12:07:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT thold_data.id FROM thold_data LEFT JOIN user_auth_perms ON ((thold_data.graph_id=user_auth_perms.item_id AND user_auth_perms.type=1 AND user_auth_perms.user_id=) OR (thold_data.host_id=user_auth_perms.item_id AND user_auth_perms.type=3 AND user_auth_perms.user_id=) OR (thold_data.graph_template=user_auth_perms.item_id AND user_auth_perms.type=4 AND user_auth_perms.user_id=)) WHERE "
08/28/2015 12:07:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT DISTINCT host.id, host.description, host.hostname FROM host INNER JOIN thold_data ON (host.id = thold_data.host_id) LEFT JOIN user_auth_perms on (thold_data.host_id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=) WHERE ORDER BY description"
08/28/2015 12:07:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT thold_data.*, thold_template.name template_name FROM thold_data LEFT JOIN user_auth_perms on ((thold_data.graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=) OR (thold_data.host_id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=) OR (thold_data.graph_template=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=)) LEFT JOIN thold_template ON thold_template.id = thold_data.template WHERE ORDER BY thold_alert DESC, template asc LIMIT 0,30"
08/28/2015 12:07:11 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM user_auth WHERE id=" 

Please help me in fixing this.

Tech Support if required:

Code: Select all

http://pastebin.com/f9GzJQwy