Thold 0.4.1 + Cacti 0.8.7e + PA 2.5 = SQL Assoc Failed!
I have made a fresh install of cacti 0.8.7e (on CentOS 5.4) with PA 2.5 and Thold 0.4.1, when I click on the "thold tab", an SQL error appear in my logs :
Code:
11/04/2009 08:24:26 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT * 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=5) OR (thold_data.host_id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=5) OR (thold_data.graph_template=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=5)) WHERE thold_data.thold_alert!=0 AND ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) ORDER BY name ASC LIMIT 0,"
anyone for a solution ? Thx
