Errors with new install

[9Nails]

I have Cacti 0.8.7.d and THold 0.4.1 And I'm getting the following error when I navigate to Console -> Management -> Thresholds:

Code: Select all

07/08/2009 11:22:06 AM - 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 thold_data.thold_alert!=0 AND "
07/08/2009 11:22:06 AM - 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 hostname"
07/08/2009 11:22:06 AM - 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=) 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 thold_data.thold_alert!=0 AND ORDER BY thold_alert DESC LIMIT 0,30"
07/08/2009 11:22:06 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM user_auth WHERE id=" 

This is a new install, not an upgrade. My problem is when I click 'Add' then "Please select a Host" is blank.

I'm not sure what I need to do. The plug-in seems to have installed fine otherwise.

[cigamit]

Is your authentication turned off?

[nothing_fr]

Same error here... (kind of) i have this sql error 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,"

I use the LDAP Authentication scheme with Thold 0.4.1 + Cacti 0.8.7e + PA 2.5

Really need a fix for that... my boss don't like errors in logs :/

Thx !

[zgamer]

Whenever I receive errors like this I'll run the actually sql command via sqlyog and then see what it throws for the actual error. Typically this is a result of one of the following:
1) A table doesn't exist
2) A table column does not exist
3) A table column datatype mismatch
4) Table index mismatch