470486 - Graphical reports and New chart do not work and show broken image instead

Status: RESOLVED DUPLICATE of bug 464992

(Bugzilla :: Reporting/Charting, defect)

Description

[Mubashir]

User-Agent:       Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)
Build Identifier: 3.2

In the stable release of bugzilla 3.2 running on Windows XP, old chart works but New chart and Graphical report come up with a broken image. The tabular report works fine though. 

Reproducible: Always

Steps to Reproduce:
1. Go to Reports and choose either Graphical Reports or New Chart
2. Having selected the product and relevant components, click on generate report

Actual Results:  
Only a broken image is displayed.

Expected Results:  
An image for graph should have been displayed

Comment 1

[Frédéric Buclin]

This is a bit vague and looks like a support question to me. Unless you give us more information, this bug will be closed as INVALID pretty quickly.

Do you have all the required Perl modules installed (check checksetup.pl's output)? Is the image generated but is corrupted, or isn't it generated at all? Are you sure permissions are correct so that Bugzilla can write to the directory? Is the URL pointing to the image correct or not?

Comment 2

[Mubashir]

Hi,

Yes,i've got all perl modules installed except PerlMagick which was not found. Following url contains the output of the checksetup.pl (http://pastebin.mozilla.org/592563). Following is the location of the image(http://supporttestkit/bugzilla/report.cgi?bug_file_loc=&bug_file_loc_type=allwordssubstr&bug_id=&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&bugidtype=include&chfieldfrom=&chfieldto=Now&chfieldvalue=&cumulate=0&deadlinefrom=&deadlineto=&email1=&email2=&emailassigned_to1=1&emailassigned_to2=1&emailcc2=1&emailreporter2=1&emailtype1=substring&emailtype2=substring&field0-0-0=noop&long_desc=&long_desc_type=substring&product=RCC%20-%20ORCA&query_format=report-graph&short_desc=&short_desc_type=allwordssubstr&type0-0-0=noop&value0-0-0=&votes=&x_axis_field=component&y_axis_field=product&z_axis_field=&format=bar&ctype=png&action=plot&width=600&height=350). 

Please refer to the following discussion: http://groups.google.com/group/mozilla.support.bugzilla/browse_thread/thread/f86fec59c2fa99f5?pli=1

There are many others who are having the same issue with this stable build on Windows XP platform. For e.g. in the notes of the bug 464992 (ref: https://bugzilla.mozilla.org/show_bug.cgi?id=464992). 

This problem is seen on both fresh install as well as upgrade from version 3.0.6. 

One point worth mentioning is that only old chart works, not the new and graphical reports and yes directory configurations are correct and they have got write permission for everyone.

Hope this helps.

Comment 3

[Vitaly Fedrushkov]

The problem is Windows-specific.  Reproducible at the same time are: bug 469794, bug 467920, bug 457524, bug 464992.

Root cause: patch from bug 363153, diagnosed by himorin.

Comment 4

[Frédéric Buclin]

Could you test on http://windows.bugzilla.org/qa32win/ ? Graphical reports are working just fine, and binary attachments, e.g. a JPEG image, is also displayed correctly.

Comment 5

[Frédéric Buclin]

(In reply to comment #4)
> Could you test on http://windows.bugzilla.org/qa32win/ ?

FYI, this installation is running on Windows 2003.

Comment 6

[Vitaly Fedrushkov]

(In reply to comment #4)
> Could you test on http://windows.bugzilla.org/qa32win/

of

> Reproducible at the same time are: bug 469794, bug 467920, bug 464992.

neither were reproduced there.

LpSolit, could you post/attach module versions according to checksetup.pl ?

Comment 7

[Frédéric Buclin]

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\lpsolit\Desktop>cd \webroot\qa32win

C:\webroot\qa32win>checksetup.pl -t
* This is Bugzilla 3.3 on perl 5.8.8
* Running on Win2003 Build 3790 (Service Pack 2)

Checking perl modules...
Checking for              CGI.pm (v3.21)   ok: found v3.42
Checking for            TimeDate (v2.21)   ok: found v2.22
Checking for            DateTime (v0.28)   ok: found v0.4501
Checking for           PathTools (v0.84)   ok: found v3.12
Checking for                 DBI (v1.41)   ok: found v1.52
Checking for    Template-Toolkit (v2.15)   ok: found v2.15
Checking for          Email-Send (v2.16)   ok: found v2.181
Checking for          Email-MIME (v1.861)  ok: found v1.861
Checking for Email-MIME-Modifier (v1.442)  ok: found v1.442

Checking available perl DBD modules...
Checking for              DBD-Pg (v1.45)    not found
Checking for           DBD-mysql (v4.00)   ok: found v4.005
Checking for          DBD-Oracle (v1.19)    not found

The following Perl modules are optional:
Checking for                  GD (v1.20)   ok: found v2.35
Checking for               Chart (v1.0)    ok: found v2.3
Checking for         Template-GD (any)     ok: found v1.56
Checking for          GDTextUtil (any)     ok: found v0.86
Checking for             GDGraph (any)     ok: found v1.4308
Checking for            XML-Twig (any)     ok: found v3.26
Checking for          MIME-tools (v5.406)  ok: found v5.420
Checking for         libwww-perl (any)     ok: found v2.033
Checking for         PatchReader (v0.9.4)  ok: found v0.9.5
Checking for          PerlMagick (any)      not found
Checking for           perl-ldap (any)     ok: found v0.33
Checking for         Authen-SASL (any)      not found
Checking for          RadiusPerl (any)      not found
Checking for           SOAP-Lite (any)     ok: found v0.55
Checking for         HTML-Parser (v3.40)   ok: found v3.55
Checking for       HTML-Scrubber (any)     ok: found v0.08
Checking for Email-MIME-Attachment-Stripper (any)     ok: found v1.3
Checking for         Email-Reply (any)     ok: found v1.200
Checking for         TheSchwartz (any)      not found
Checking for      Daemon-Generic (any)      not found
Checking for            mod_perl (v1.999022)  not found
Checking for              CGI.pm (v3.11)   ok: found v3.42

* NOTE: You must run any commands listed below as Administrator.

***********************************************************************
* Note For Windows Users                                              *
***********************************************************************
* In order to install the modules listed below, you first have to run *
* the following command as an Administrator:                          *
*                                                                     *
*   ppm repo add theory58S http://theoryx5.uwinnipeg.ca/ppms
*                                                                     *
* Then you have to do (also as an Administrator):                     *
*                                                                     *
*   ppm repo up theory58S                                             *
*                                                                     *
* Do that last command over and over until you see "theory58S" at the *
* top of the displayed list.                                          *

***********************************************************************
**********************************************************************
* OPTIONAL MODULES                                                   *
**********************************************************************
* Certain Perl modules are not required by Bugzilla, but by          *
* installing the latest version you gain access to additional        *
* features.                                                          *
*                                                                    *
* The optional modules you do not have installed are listed below,   *
* with the name of the feature they enable. If you want to install   *
* one of these modules, just run the appropriate command in the      *
* "COMMANDS TO INSTALL" section.                                     *
**********************************************************************

***********************************************************************
*    MODULE NAME * ENABLES FEATURE(S)                                 *
***********************************************************************
*     PerlMagick * Optionally Convert BMP Attachments to PNGs         *
*    Authen-SASL * SMTP Authentication                                *
*     RadiusPerl * RADIUS Authentication                              *
*    TheSchwartz * Mail Queueing                                      *
* Daemon-Generic * Mail Queueing                                      *
*       mod_perl * mod_perl                                           *
***********************************************************************
COMMANDS TO INSTALL:

     PerlMagick: ppm install PerlMagick
    Authen-SASL: ppm install Authen-SASL
     RadiusPerl: ppm install RadiusPerl
    TheSchwartz: ppm install TheSchwartz
 Daemon-Generic: ppm install Daemon-Generic
       mod_perl: ppm install mod_perl
Reading ./localconfig...

OPTIONAL NOTE: If you want to be able to use the 'difference between two
patches' feature of Bugzilla (which requires the PatchReader Perl module
as well), you should install patchutils from:

    http://cyberelk.net/tim/patchutils/

Checking for           DBD-mysql (v4.00)   ok: found v4.005
Checking for           MySQL (v4.1.2)  ok: found v4.1.22-community-nt


C:\webroot\qa32win>

Comment 8

[Mubashir]

I tried the above url mentioned in comment #4. Graphical Reports are working fine but Old Charts threw the following exception. 

"URL: http://windows.bugzilla.org/qa32win/reports.cgi
Unable to open the chart datafile ./data/mining/-All-.  "

I could not test the file download or upload as dont have login account. Now is there a way if i could update my 3.2 build for Graphical Charts only (i.e. with 3.3) so my graphs could be backl live again?

Thanks.

Comment 9

[Vitaly Fedrushkov]

Bug 464992 comment 41: related bug can be remedied by upgrading Perl to 5.10.0.

Comment 10

[Mubashir]

Update on this issue. I've recently installed Bugzilla 3.2 on Windows Vista 32 bit running on Apache web server with latest MySQL and Perl. I installed it using CVS instead of tar ball. Initially graphs were broken. But then i installed the optional perl modules and one of those was mod_perl and after installing that, all the graphs seem to be working fine.

Comment 11

[Frédéric Buclin]

Same root cause as bug 464992. I have a patch which I will attach to the other bug.