257497 - Graphical charts are not displayed correctly, a broken image link is all that is displayed.

Status: RESOLVED DUPLICATE of bug 275705

(Bugzilla :: Reporting/Charting, defect)

Description

[Stefan Treacy]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Build Identifier: Bugzilla Version 2.18rc2 

I have installed Bugzilla 2.18rc2 on a Linux box. No problems where
experienced during the install and I can now happily track my bugs.

However, whenever I try and generate some reports on the data I cannot
see the charts that are produced. All that I see is a broken link to
the chart image. If I click on the CSV or Table report options I see
the relevant results, its just the grapical charts, bar and line, that
are failing.

Whenever I ran the install I checked that everyting installed
correctly by running the checksetup.pl. The results of this are as
follows:

[root@sydney bugzilla]# ./checksetup.pl

Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.05
Checking for    Data::Dumper (any)     ok: found v2.12
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.36)   ok: found v1.43
Checking for      DBD::mysql (v2.1010) ok: found v2.1021
Checking for      File::Spec (v0.82)   ok: found v0.87
Checking for      File::Temp (any)     ok: found v0.14
Checking for        Template (v2.08)   ok: found v2.13
Checking for      Text::Wrap (v2001.0131) ok: found v2001.0929

The following Perl modules are optional:
Checking for              GD (v1.20)   ok: found v1.33
Checking for     Chart::Base (v1.0)    ok: found v2.3
Checking for     XML::Parser (any)     ok: found v2.31
Checking for       GD::Graph (any)     ok: found v1.43
Checking for GD::Text::Align (any)     ok: found v1.18
Checking for     PatchReader (v0.9.4)  ok: found v0.9.4

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for    MySQL Server (v3.23.41) ok: found v3.23.58-log

[root@sydney bugzilla]#

I had originally thought that I might not have installed the correct
PERL package for the Graphs, but this output confirms that it has
indeed been installed.

I posted a request for assistance on the NewsGroup, 
netscape.public.mozilla.webtools and got the following response:

Do "View Image" on the broken image, then add "&debug=1" to the URL. 
Post the result in a new Bugzilla bug in the Reporting & Charting component.

data hash:
$VAR1 = '-total-';
$VAR2 = {
          'WebAgent' => {
                          '' => 1
                        },
          'Agent Client' => {
                              '' => 1
                            }
        };
$VAR3 = 'WebAgent';
$VAR4 = {
          'WebAgent' => {
                          '' => 1
                        },
          'Agent Client' => {
                              '' => 0
                            }
        };
$VAR5 = 'Agent Client';
$VAR6 = {
          'WebAgent' => {
                          '' => 0
                        },
          'Agent Client' => {
                              '' => 1
                            }
        };


data array:
$VAR1 = [
          [
            'Agent Client',
            'WebAgent'
          ],
          [
            1,
            1
          ]
        ];
$VAR2 = [
          $VAR1->[0],
          [
            0,
            1
          ]
        ];
$VAR3 = [
          $VAR1->[0],
          [
            1,
            0
          ]
        ];



Development Bug Tracking 

Bugzilla Version 2.18rc2 
Report: Component / Component  
    2004-08-31 08:45:17 

SELECT 42217354, map_components.name, map_components.name FROM bugs, 
components AS map_components LEFT JOIN bug_group_map ON bug_group_map.bug_id = 
bugs.bug_id AND bug_group_map.group_id NOT IN (7,6,3,5,2,4,8,1) LEFT JOIN cc 
ON cc.bug_id = bugs.bug_id AND cc.who = 2 WHERE bugs.component_id = 
map_components.id AND (bugs.product_id IN (2)) AND (bugs.bug_status IN 
('NEW','ASSIGNED','REOPENED')) AND ((bug_group_map.group_id IS NULL) OR 
(bugs.reporter_accessible = 1 AND bugs.reporter = 2) OR 
(bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR (bugs.assigned_to = 
2) ) GROUP BY bugs.bug_id

Agent Client
 

WebAgent
 

Total
 
Pie | Bar | Line | Table | CSV          Taller
Thinner * Fatter    
Shorter
 


Edit this report 




Reproducible: Always
Steps to Reproduce:
1.Select Reports then Graphical Reports from the menu options
2.Select values for the two chart axis.
3.Generate report.
4.Table and CSV charts are displayed but Pie, Line and Bar are never generated.

Actual Results:  
Only a broken image link is displayed in the browser window. You cannot see 
the grapichal results of the chart.

Expected Results:  
The graphs should be displayed.

Comment 1

[Gervase Markham [:gerv]]

What values are you selecting for the chart axes? Can you give the URL which
generates the page you give?

Gerv

Comment 2

[Thomas Leufkes]

I have the same problem with the graphs in Bugzilla here. 
Our installation is 2.18rc2 under Red Hat Linux ES 3.0. 
Everything works fine but whenever a graphic should be displayed (old or new
graphs, pie, line and so on) it ends with a broken image. I fact the linked
png-files in the graphs-directory are empty (0 bytes). collectstats.pl runs
every night.

We had problems installaing the GD 1.x on our server under Red Hat. 
So we decided to install GD 2 (yes, with png support). 
But that should not be the problem.

Here is the output of my checksetup:
[tst03:buggfi] /kmtools/bugzilla/gfi> checksetup.pl

Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.05
Checking for    Data::Dumper (any)     ok: found v2.12
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.36)   ok: found v1.43
Checking for      DBD::mysql (v2.1010) ok: found v2.1021
Checking for      File::Spec (v0.82)   ok: found v3.01
Checking for      File::Temp (any)     ok: found v0.13
Checking for        Template (v2.08)   ok: found v2.13
Checking for      Text::Wrap (v2001.0131) ok: found v2001.0929

The following Perl modules are optional:
Checking for              GD (v1.20)   ok: found v2.19
Checking for     Chart::Base (v1.0)    ok: found v2.3
Checking for     XML::Parser (any)     ok: found v2.34
Checking for       GD::Graph (any)     ok: found v1.43
Checking for GD::Text::Align (any)     ok: found v1.18
Checking for     PatchReader (v0.9.4)  ok: found v0.9.5

Checking user setup ...

Warning: you have entered a value for the "webservergroup" parameter
in localconfig, but you are not running this script as root.
This can cause permissions problems and decreased security.  If you
experience problems running Bugzilla scripts, log in as root and re-run
this script, or remove the value of the "webservergroup" parameter.
Note that any warnings about "uninitialized values" that you may
see below are caused by this.

Removing existing compiled templates ...
Precompiling templates ...
Checking for    MySQL Server (v3.23.41) ok: found v4.0.18-standard

[tst03:buggfi] /kmtools/bugzilla/gfi>

At the moment I wonder about how to test the graphs functionality in Bugzilla,
so I could figure out where is the problem ?

Any hints welcome !

Comment 3

[Thomas Leufkes]

Attachment: output of example link with &debug=1

Sorry for uploading a zip, but it is about 1,5 MB as txt.

at the end of the attached file it says: "No problems"

output of URL
http://bugtest.ihk-gfi.de/report.cgi?bug_file_loc_type=allwordssubstr&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bugidtype=include&chfieldto=Now&cumulate=1&emailassigned_to1=1&emailassigned_to2=1&emailcc2=1&emailqa_contact2=1&emailreporter2=1&emailtype1=substring&emailtype2=substring&field0-0-0=noop&long_desc_type=substring&query_format=report-graph&short_desc_type=allwordssubstr&status_whiteboard_type=allwordssubstr&type0-0-0=noop&x_axis_field=component&y_axis_field=version&format=line&ctype=png&action=plot&width=600&height=350

without &debug=1 (german template):
Die Grafik
"http://bugtest.ihk-gfi.de/report.cgi?bug_file_loc_type=allwordssubstr&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bugidtype=include&chfieldto=Now&cumulate=1&emailassigned_to1=1&emailassigned_to2=1&emailcc2=1&emailqa_contact2=1&emailreporter2=1&emailtype1=substring&emailtype2=substring&field0-0-0=noop&long_desc_type=substring&query_format=report-graph&short_desc_type=allwordssubstr&status_whiteboard_type=allwordssubstr&type0-0-0=noop&x_axis_field=component&y_axis_field=version&format=line&ctype=png&action=plot&width=600&height=350"
kann nicht angezeigt werden, weil sie Fehler enthält.

Comment 4

[Gervase Markham [:gerv]]

Stefan: are you able to answer my question in comment #1?

What you posted as the output seems very strange. Could you do Save As on the
result and attach it to the bug instead, so I can be sure what you are getting?

Thomas: am I supposed to be able to reach the Bugzilla on
http://bugtest.ihk-gfi.de/?

Gerv

Comment 5

[Thomas Leufkes]

no sorry, bugtest.ihk-gfi.de is an internal website of our company.
The Graphics are broken by any kind of selection.

How could I test the GD installation in an easy way ?
I think it is a general problem, on our server.
checksetup.pl tells everything is fine, but it isn´t.

Comment 6

[Gervase Markham [:gerv]]

Thomas: what's the output of gdlib-config --version?

Gerv

Comment 7

[Thomas Leufkes]

(In reply to comment #6)
> Thomas: what's the output of gdlib-config --version?
> 
> Gerv

[eqf02:buggfi] ~> gdlib-config --version
2.0.33
[eqf02:buggfi] ~>

Comment 8

[Stefan Treacy]

(In reply to comment #1)
> What values are you selecting for the chart axes? Can you give the URL which
> generates the page you give?
> Gerv

Gerv,

Sorry, I cannot provide you with the URL as the server that Bugzilla is 
installed on is not public. 

I will create a new comment with ab attachment illustrating the screen shots 
and out put as requested.

Thx,

Stefan/

Comment 9

[Stefan Treacy]

Attachment: Screen Shots of Actual Problem

The zip file contains three screen shots illustrating the creation of the
report, the graphical report not being displayed and then finally clicking on
the Table option and the appropriate information ebing displayed. I have
blanked out one column of information for privacy reasons.

The HTML code of the page is also contained in the zip file from the page where
the graphical report could not be displayed.

Comment 10

[Gervase Markham [:gerv]]

Guys, I suspect you have different problems. As this is originally Stefan's bug,
Thomas: please can you file your own and take the status over there? :-)

Stefan: please can I have the output of gdlib-config --version? I'd also like
the URL - I don't want to visit it, I just want to see what it says. If you
like, replace the Product names in the URL with Product1, Product2 etc.

Can you also right-click on the broken image, click "View Image", add "&debug=1"
to the resulting URL, load that, save the resulting HTML page and attach it?

Gerv

Comment 11

[Stefan Treacy]

Gerv,

gdlib-config --version
2.0.26

The URL:
URL
http://sydney/bugzilla/report.cgi?y_axis_field=component&cumulate=0&z_axis_field=&format=bar&x_axis_field=assigned_to&query_format=report-graph&short_desc_type=allwordssubstr&short_desc=&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&emailassigned_to1=1&emailtype1=substring&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&action=wrap&field0-0-0=noop&type0-0-0=noop&value0-0-0=

I'll attache the HTML file seperately.

Regards,

Stefan.

Comment 12

[Stefan Treacy]

Attachment: HTML File of URL + &debug=1

HTML File of URL + &debug=1

Comment 13

[Gervase Markham [:gerv]]

Stefan: your problem is a GD version mismatch:

The following Perl modules are optional:
Checking for              GD (v1.20)   ok: found v1.33
vs.
gdlib-config --version
2.0.26

Upgrade your GD.pm to a 2.x version.

Gerv

Comment 14

[Marc Schumann [:Wurblzap]]

*** This bug has been marked as a duplicate of 275705 ***