Notices 0.1

[Joop]

I am getting a error "Wrong RRA" too...
Nothing check in setttings tab for notices plugin...
Also i see the following error in my graphs:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /usr/share/cacti/site/plugins/notices/load.php on line 103

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /usr/share/cacti/site/plugins/notices/load.php on line 112

I do have that problem too but think I found where it comes from. Printing th rra_id as suggested made me look at the url and saw 'rra_id=all' and 'all' isn't a number so the select is complaining about that.

Edit:
I had line 103 print the select statement and it looks like mysql is right , Notice the empty rra_id= clause

SELECT notice FROM notices WHERE rra_id = AND graph_id =6 AND user_id =1

host_id is probably what you want here.

Regards,

Joop

[brezel]

the rra_id notices uses is another then the one in the URL ,it a number for each graph like in the image below.

it should be saved in $number in baum.php line 5 and load.php also line 5(from $rra["id"]) it seems that it don't do this

[disH]

so is there a solution for this problem? im experiencing the same problem

[brezel]

I still can't reproduce it, can someone post the output of the code i posted before? It should look like on the screenshoot above.

[ivan-impuls]

Can you add following line in baum.php at line 6? Above the Notices button something like "rra:1 number:1" should appear.

Code: Select all

echo('rra:'.$rra["id"].' number:'.$number);

I done this.
Nothing appear...

[/img]

[brezel]

can you add

Code: Select all

echo('rra:'.$rra['id']);

in line 120 in setup.php under

Code: Select all

global $config,$rra;

does a number appear then?

[ivan-impuls]

No, nothing changes.
The same picture.
Sorry for my English.
I'm from Russia...

[brezel]

Can you post lines 98 and 99 in your graph.php from cacti basedirectory?

I have no clue why $rra["id"] contains no data

[ivan-impuls]

###98str
<a href='graph.php?action=zoom&local_graph_id=<?php print $_GET["local_graph_id"];?>&rra_id=<?php print $rra["id"];?>&view_type=<?php print $_REQUEST["view_type"];?>'><img src='images/graph_zoom.gif' border='0' alt='Zoom Graph' title='Zoom Graph' style='padding: 3px;'></a><br>

###99str
<a href='graph_xport.php?local_graph_id=<?php print $_GET["local_graph_id"];?>&rra_id=<?php print $rra["id"];?>&view_type=<?php print $_REQUEST["view_type"];?>'><img src='images/graph_query.png' border='0' alt='CSV Export' title='CSV Export' style='padding: 3px;'></a><br>

[brezel]

I won't be able to look for this for 6 weeks, so after changing

Code: Select all

$number = $rra["id"];

(line 5 in load.php and line 5 in baum.php) in

Code: Select all

if(is_numeric($rra["id"]))
{
  $number = $rra["id"];
}
else
{
  $number = 1;
}

the plugin should behave like in 0.2b (only one window for one notice).

[Joop]

Hi Brezel,

I don't have the mysql errors with this combination but found two other things:

- you're using <script src="'.$config['url_path'].'/plugins/notices/prototype.js"> in baum.php but that leads to
//plugins/notices/prototype.js which is slowing down pageloads quite a bit.

- when trying to delete a comment it doesn't work. Log entries from Cacti show the delete followed by a (re) insert of the same data

Code: Select all

07/10/2009 02:02:21 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "INSERT INTO notices (host_id, rra_id, user_id, notice) VALUES ('1', '1', '1', '')"
07/10/2009 02:02:21 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "DELETE FROM notices WHERE host_id =1 AND rra_id=1 AND user_id =1" 

Other than that is looks like its is working.

Regards,

Joop

[parvedejs]

Hi,

I have same problem , but only @ Graphs -> Tree Mode

:?

[parvedejs]

I resolve my problem
@ begin of load.php
after string >

Code: Select all

$number = $rra["id"];

add

Code: Select all

settype($number, "integer");

p.s. mb not correct, but for me all work fine.

[megatron_007]

Could someone help me to fix this:
(I can't post any remarks, maybe it's a permission issue. )



[/img]

[brezel]

It looks like the User has no permissions to the Plugin ,have you activated it?