Thold 0.4.1 + Cacti 0.8.7e + PA 2.5 = SQL Assoc Failed!

[nothing_fr]

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: Select all

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

[atem]

I had the same issue.. i had to import the pa.sql file into my mysql database
that fixed the issue

>> mysql -u root < pa.sql

cacti: 0.8.7e (fedora)
Thold 0.4.1