CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054'

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

Moderators: Developers, Moderators

User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Assigned it to me
Reinhard
User avatar
kendier
Posts: 1
Joined: Thu Oct 30, 2008 6:20 am
Location: Rio de Janeiro / Brazil

Post by kendier »

I have the same problem...

10/30/2008 11:00:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname FROM graph_tree_items LEFT JOIN host ON (host.id=graph_tree_items.host_id) LEFT JOIN graph_templates ON (graph_templates_graph.graph_template_id=graph_templates.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=1) OR (host.id=user_auth_perms.item_id AND user_auth_perms.type=3 AND user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id AND user_auth_perms.type=4 AND user_auth_perms.user_id=1)) WHERE graph_tree_items.graph_tree_id=6 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))) AND graph_tree_items.local_graph_id = 0 ORDER BY graph_tree_items.order_key"




I couldn't find the patch... Could you avaliable it?


Thanks!
Last edited by kendier on Sun Nov 02, 2008 3:44 pm, edited 1 time in total.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

I did not yet start working on it.
Please monitor that bug report to be notified about the patch
Reinhard
stotch
Posts: 2
Joined: Wed Jan 14, 2009 10:13 pm
Location: Oakland, CA

Same problem

Post by stotch »

I seem to have the same problem with my version of Cacti 0.8.7b (patches with all three patches).

And I seem to be unable to see that bug report even though I have account on Mantis. It says "Access Denied".

--Brendan
User avatar
phakesley
Posts: 39
Joined: Tue Nov 13, 2007 11:24 am

Post by phakesley »

I have the same problem. WOuld like to know the solution if it is available. P.s. I cannot find the bug on bugs.cacti.

Pete
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Is now assigned to Larry (TheWitness) and being worked on. Current status is "feedback required" :cry:
Reinhard
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests