393971 - postgresql: Receive SW error when trying to view graph

Status: RESOLVED FIXED

(Testopia :: Reports, defect)

Description

[JK]

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

Comment 1

[Greg Hendricks]

Fixed