cacti log error

[zero13ro]

Hi,

i have cat the cacti log file and find this

09/30/2010 12:37:13 PM - SYSTEM STATS: Time:1.1374 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:1
09/30/2010 12:37:23 PM - SYSTEM STATS: Time:1.1367 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
09/30/2010 12:37:33 PM - SYSTEM STATS: Time:1.1323 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
09/30/2010 12:37:43 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.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=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_templates_graph.local_graph_id=graph_local.id 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_templates_graph.local_graph_id= group by graph_templates_graph.local_graph_id"



I also want to add that cacti its working fine and graphics are added corectly.

Can someone help

Thanks

[Nice]

I have exactly the same error.

Anyone has a solution?

I checked "System utilities" --> techical support and there are no errors

[Howie]

Mysql Error 1064 is a SQL syntax error.

That SQL statement is checking permissions for a graph, but the very end has no graph_id.

What were you trying to do when the error appeared?

[Nice]

I upgraded from PA2.6 to PA2.8

[Nice]

I found the problem.
It was a problem with the Graph List View Searching patch .
I replaced the old graph_view.php file an now it works

[Nice]

Unfortunately the problem isn't fixed.
Again I have following errors.
I always get it when I open a page with the graphs tab.

Code: Select all

10/11/2010 02:20:45 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.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=4) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=4) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=4)) where graph_templates_graph.local_graph_id=graph_local.id 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_templates_graph.local_graph_id= group by graph_templates_graph.local_graph_id"

Any idea what is wrong?

[Nice]

Anybody who can help me?

I reinstalled my whole cacti environment and I still get the error...

Cacti 0.8.7g
PIA 2.9b

[gandalf]

What exactly where you trying to view when this error occurs?
You may want to open a bug report for this
R.

[Nice]

I get this error when I want to view a graph.

Everything is workin fine but I always get the error in the logs.

I already reintstalled my cacti system en it is still the samen.

[Nice]

I can specify the problem.

I get the error when I visit a graph.php page by clicking on a graph in tree mode to see the details.

I'm searching right now for the sql code that i found in the error.

Anybody who can help?

[gandalf]

The error is a result of

Code: Select all

...graph_templates_graph.local_graph_id= group...

The local_graph_id is missing. But it is unclear, how this might happen.
R.