When managing graphs, Graphs can be listed multiple times incorrectly

[Coporton]

Describe the bug

I don't know why but I checked several times. The result is still the same. Graph Name in Graph Management shows the same name multiple times.

To Reproduce

Steps to reproduce the behavior:

1. Go to 'Console'
2. Click on 'Management'
3. Click on 'Graphs'
4. See the Graph Name

Expected behavior

It's showing the same name multiple times with the same URL.

Screenshots

If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information)

• OS: [e.g. iOS]

• Browser [e.g. chrome, safari]
  chrome

• Version [e.g. 22]
  1.2.23

[TheWitness]

Appreciate you reporting this one.

[TheWitness]

Please run this query and let me know if you get duplicates:

SELECT gtg.id, gl.id AS local_graph_id,
        gtg.height, gtg.width, gtg.title_cache, gt.name, gl.host_id,
        IF(gl.graph_template_id = 0, 0, IF(gl.snmp_query_id = 0, 2, 1)) AS graph_source
        FROM graph_local AS gl
        INNER JOIN graph_templates_graph AS gtg
        ON gl.id=gtg.local_graph_id
        LEFT JOIN graph_templates AS gt
        ON gl.graph_template_id=gt.id
        LEFT JOIN aggregate_graphs AS ag
        ON ag.local_graph_id=gl.id
        LEFT JOIN host AS h
        ON h.id=gl.host_id
        LEFT JOIN sites AS s
        ON h.site_id=s.id
       ORDER BY gl.id
       LIMIT 20 ;

[TheWitness]

Lastly, on line 2222 of graphs.php, take the query for the variable $graph_list and put it inside of a cacti_log() function call. After that, render the page once, and then goto the cacti.log and post what the query you find there. Just to be clear:

$graph_list = db_fetch_assoc("blah");

cacti_log("blah");

[Coporton]

Thanks, @TheWitness. I ran the query and got zero duplicates but I don't understand your second instruction. Actually, I'm not that smart... :(

[TheWitness]

Well for me this is philanthropic work. so if you want free support you're going to have to meet me halfway. I'll patiently await you to provide the response I requested.

[Coporton]

I understand the situation, my friend. Anyways, After doing some research, I may able to understand what you wanted to say. The query works. Now I can see the single result on GUI, however only 20 rows according to the statement.

In the cacti log, I found no error. Please have a look.

[bmfmancini]

Do you have any plugins installed ?

[bmfmancini]

Also run /cacti/cli/audit_database --report

[Coporton]

Hi, @bmfmancini, no I don't have any installed plugins. Actually, I am just trying to follow the instruction that @TheWitness told me to do.

[bmfmancini]

Hmm I am not able to replicate on 1.2.23

[bmfmancini]

@Coporton run audit_database --report and check for any errors/warnings

[TheWitness]

Copy Paste the text of that log message. Here. Then I'll have a follow-up query for you to run.

[Coporton]

@TheWitness, here is the log message report

2022-11-09 21:00:27 - CMDPHP SELECT gtg.id, gl.id AS local_graph_id, gtg.height, gtg.width, gtg.title_cache, gt.name, gl.host_id, IF(gl.graph_template_id = 0, 0, IF(gl.snmp_query_id = 0, 2, 1)) AS graph_source FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON gl.id=gtg.local_graph_id LEFT JOIN graph_templates AS gt ON gl.graph_template_id=gt.id LEFT JOIN aggregate_graphs AS ag ON ag.local_graph_id=gl.id LEFT JOIN host AS h ON h.id=gl.host_id LEFT JOIN sites AS s ON h.site_id=s.id ORDER BY gl.id LIMIT 20;