Bug 1254933 - [Pgsql]Error link of reports.cgi?show_all=1 in the reports.cgi page
Summary: [Pgsql]Error link of reports.cgi?show_all=1 in the reports.cgi page
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Bugzilla
Classification: Community
Component: Reporting/Charting
Version: 4.4
Hardware: Unspecified
OS: Unspecified
medium
low
Target Milestone: 4.4
Assignee: Jeff Fearn 🐞
QA Contact: Rony Gong 🔥
URL:
Whiteboard:
Depends On: 1254054
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-08-19 09:25 UTC by Rony Gong 🔥
Modified: 2018-12-09 06:29 UTC (History)
3 users (show)

Fixed In Version: 4.4.10042-7
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-11-04 04:31:28 UTC
Embargoed:


Attachments (Terms of Use)

Description Rony Gong 🔥 2015-08-19 09:25:56 UTC
Description of problem:
Error link of reports.cgi?show_all=1 in the reports.cgi page

Version-Release number of selected component (if applicable):
4.4.9039-2

How reproducible:
Always

Steps to Reproduce:
1.Go to reports page, then click link 'Old Charts'(reports.cgi)
2.Then click the 'here'(reports.cgi?show_all=1) link in the new page
3.

Actual results:
Page show error:

An error occurred while performing a database operation:

DBD::Pg::db selectcol_arrayref failed: ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 2:         WHERE value != '' ORDER BY type DESC, value
                                           ^ [for Statement "SELECT DISTINCT value FROM mining_data_values
        WHERE value != '' ORDER BY type DESC, value"] at /var/www/html/bugzilla/reports.cgi line 152.
	ModPerl::ROOT::Bugzilla::ModPerl::ResponseHandler::var_www_html_bugzilla_reports_2ecgi::get_data("/var/www/html/bugzilla/data/mining") called at /var/www/html/bugzilla/reports.cgi line 58
	ModPerl::ROOT::Bugzilla::ModPerl::ResponseHandler::var_www_html_bugzilla_reports_2ecgi::handler(Apache2::RequestRec=SCALAR(0x7f29a1ed0fc0)) called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 204
	eval {...} called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 204
	ModPerl::RegistryCooker::run(Bugzilla::ModPerl::ResponseHandler=HASH(0x7f29a1369f88)) called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 170
	ModPerl::RegistryCooker::default_handler(Bugzilla::ModPerl::ResponseHandler=HASH(0x7f29a1369f88)) called at /usr/lib64/perl5/vendor_perl/ModPerl/Registry.pm line 31
	ModPerl::Registry::handler("Bugzilla::ModPerl::ResponseHandler", Apache2::RequestRec=SCALAR(0x7f29a1ed0fc0)) called at /var/www/html/bugzilla/mod_perl.pl line 134
	Bugzilla::ModPerl::ResponseHandler::handler("Bugzilla::ModPerl::ResponseHandler", Apache2::RequestRec=SCALAR(0x7f29a1ed0fc0)) called at -e line 0
	eval {...} called at -e line 0


Expected results:


Additional info:

Comment 1 Jeff Fearn 🐞 2015-08-21 00:20:29 UTC
We will be disabling these reports in the UI, using this URI after BZ 1254054 should present a warning that the feature is disabled.

Comment 2 Rony Gong 🔥 2015-08-31 06:08:47 UTC
Tested on 
QA environment(bzweb01-qe) with version(4.4.9040-1, DB: mysql)
QA environment(bzperfweb01.app.qa) with version(4.4.9040-1, DB: psql )
Result: Pass
Steps:
The links 'Old Charts' and 'New Charts' is viewable in report.cgi now.

Comment 3 Matt Tyson 🤬 2015-11-04 04:31:28 UTC
This change is now live. If there are any issues, do not reopen this bug.
Instead, you should create a new bug and reference this bug.


Note You need to log in before you can comment on or make changes to this bug.