'Suggested Values' mechanism broken

[appugno]

Hi all,

Reapply Suggested Names - breaks graph titles, can you please help me with this? is this a known issue? i searched the forum came up with nothing...

1. when a graph is first created it gets a proper (the one I want, first in the 'Suggested Values' list) title.
2. if I "Reapply Suggested Names" for some yet unknown to me reason graphs title changes to '|host_description| - Traffic - |query_ifName|' even though is the third in the 'Suggested Values' list.
3. if go and chnage it manualy, it breaks the graphs, they won't draw, but their title is proper, I haven't found a non distructive way to fix them, the only way is to delete them and their coresponding 'Data Sources' seperatly as cacti won't delete them automaticly when graphs are deleted (as if a link between the graph and its data source is broken), then create them back. rrdtool for broken graphs in the "turn on graph debug" mode says 'invalid rpn expression (pls see the picture attached)

4. if I delete a graph and then recreate it, it gets a proper title.

this affects whole 'Suggested Values' mechanism.

this install is a couple of years old...a lots of statistics were accumulated.

if a developer wants to access the installation remotely(both ssh and http) is not a problem it can be arranged.

any suggestions, questions, and comments are welcomed

please help...

thank you all

p.s. very sorry about the dimentions of the pictures attached

[appugno]

I found the problem, somehow records in the database got dublicate sequence numbers, I reordered them manually now everything is back to normal

mysql> select sequence, text, field_name from snmp_query_graph_sv where snmp_query_graph_id=13 order by sequence;
+----------+---------------------------------------------------------------------------------+------------+
| sequence | text | field_name |
+----------+---------------------------------------------------------------------------------+------------+
| 1 | |host_description| - Traffic - |query_ifAlias| - |query_ifIP| (|query_ifDescr|) | title |
| 1 | |host_description| - Traffic - |query_ifName| | title |
| 2 | |host_description| - Traffic - |query_ifIP| (|query_ifDescr|) | title |
| 3 | |host_description| - |query_ifAlias| (|query_ifName|) | title |
| 3 | |host_description| - Traffic - |query_ifDescr|/|query_ifIndex| | title |
+----------+---------------------------------------------------------------------------------+------------+
5 rows in set (0.00 sec)

[TheWitness]

Any clue how that happened?

TheWitness

[appugno]

I have no idea, never touched any cacti records myself.

I wonder if back/forward navigation of the browser could've done it.