If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

postgresql: Receive SW error when trying to view graph

RESOLVED FIXED

Status

Testopia
Reports
--
major
RESOLVED FIXED
10 years ago
9 years ago

People

(Reporter: JK, Assigned: Greg Hendricks)

Tracking

Details

(Whiteboard: PostgreSQL)

(Reporter)

Description

10 years ago
User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4
Build Identifier: 

I am using testopia ver 1.3-beta2 with postgreSQL.
When trying to view a graph of test results, after I choose any value for either the horizontal or vertical axis, and select submit I obtain the error in the Actual Results section below.

Reproducible: Always

Steps to Reproduce:
1.
2.
3.
Actual Results:  
Received error below:

Software error:

DBD::Pg::db selectall_arrayref failed: ERROR:  column "map_priority.value" must appear in the GROUP BY clause or be used in an aggregate function
 [for Statement "SELECT map_priority.value,42217354,42217354 FROM test_cases  INNER JOIN priority AS map_priority ON (test_cases.priority_id = map_priority.id) WHERE 1 = 1 GROUP BY test_cases.case_id"] at Bugzilla/Testopia/Report.pm line 204
	Bugzilla::Testopia::Report::init('Bugzilla::Testopia::Report=HASH(0x9749114)', 'case', 'tr_list_cases.cgi', 'Bugzilla::CGI=HASH(0x957a014)') called at Bugzilla/Testopia/Report.pm line 71
	Bugzilla::Testopia::Report::new('Bugzilla::Testopia::Report', 'case', 'tr_list_cases.cgi', 'Bugzilla::CGI=HASH(0x957a014)') called at /var/www/html/bugzilla/tr_case_reports.cgi line 81



Expected Results:  
Graph to be displayed

Updated

10 years ago
Summary: Receive SW error when trying to veiw graph → postgresql: Receive SW error when trying to view graph

Updated

10 years ago
Whiteboard: PostgreSQL
(Assignee)

Comment 1

9 years ago
Fixed
Status: UNCONFIRMED → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.