Bug 160625

Summary:	"new charts" reports no longer work
Product:	Gentoo Infrastructure	Reporter:	Simon Stelling (RETIRED) <blubb>
Component:	Other	Assignee:	Bugzilla Admins <bugzilla>
Status:	RESOLVED INVALID
Severity:	normal
Priority:	High
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

Description Simon Stelling (RETIRED) gentoo-dev

2007-01-07 03:08:14 UTC

since the bugzilla upgrade I can no longer produce graphical reports for the "Change over time - new Charts". fex: http://tinyurl.com/ynadfm
The image to be produced is replaced by its alternative text "Graphical report results".

Comment 1 Robin Johnson archtester

2007-01-07 07:07:29 UTC

your chart link is defective.
If you go to that page, and look in the HTML src, and grab the image link.
Throw it in your browser, and look at it as HTML, not an image. You get this error reported:

undef error - DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 [for Statement &quot;SELECT MIN(series_date) FROM series_data WHERE series_id IN ()&quot;] at Bugzilla/Chart.pm line 223
    Bugzilla::Chart::readData('Bugzilla::Chart=HASH(0xd736e59ffb0)') called at Bugzilla/Chart.pm line 204 
    Bugzilla::Chart::data('Bugzilla::Chart=HASH(0xd736e59ffb0)') called at data/template/template/en/custom/reports/chart.png.tmpl line 50
    eval {...} called at data/template/template/en/custom/reports/chart.png.tmpl line 50
    eval {...} called at data/template/template/en/custom/reports/chart.png.tmpl line 16
    Template::Provider::__ANON__('Template::Context=HASH(0xd736ea9ef60)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux/Template/Document.pm line 155 
    eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux/Template/Document.pm line 153 
    Template::Document::process('Template::Document=HASH(0xd736f0ef610)', 'Template::Context=HASH(0xd736ea9ef60)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux/Template/Context.pm line 350
    eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux/Template/Context.pm line 320 
    Template::Context::process('Template::Context=HASH(0xd736ea9ef60)', 'Template::Document=HASH(0xd736f0ef610)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux/Template/Service.pm line 97 
    eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux/Template/Service.pm line 94
    Template::Service::process('Template::Service=HASH(0xd736ea5a0f0)', 'reports/chart.png.tmpl', 'HASH(0xd736ea0d8d0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux/Template.pm line 71 
    Template::process('Bugzilla::Template=HASH(0xd736e9daa60)', 'reports/chart.png.tmpl', 'HASH(0xd736ea0d8d0)') called at /var/www/bugs.gentoo.org/htdocs/chart.cgi line 279
    main::plot() called at /var/www/bugs.gentoo.org/htdocs/chart.cgi line 122