Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008499TestLinkDatabase MySQLpublic2018-12-10 16:562018-12-12 21:43
Reporterheju 
Assigned Tofman 
PrioritynormalSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.9.17 (2018 Q1) 
Fixed in Version1.9.19 (2019 Q1) 
Summary0008499: DB Access Error at refresh of "Test result matrix" in case more than 6 builds are active
DescriptionIn case more than 6 builds are active, the user has to select some builds
when pressing the "Test result matrix" button in "Reports and Metrics" section.


"
Amount of potential data to be generated is too high - please refine your request
You have 7 Active Builds, please choose no more than 6
"

After the user has selected some builds (seems number is not important) he gets presented the Test Result matrix.

Bug:
In case the user was asked to select builds (in case the build number is larger than 6) pressing "refresh" or "Reset to default state" in the Test Result matrix header gui will lead to a DB Access Error.

In the event log an ERROR is logged:
ERROR ON exec_query() - database.class.php
1064 - 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 'ORDER BY name' at line 1 - /* Class:tlPlatform - Method: getLinkedToTestplanAsMap */ SELECT P.id, P.name FROM platforms P JOIN testplan_platforms TP ON P.id = TP.platform_id WHERE TP.testplan_id = ORDER BY name
THE MESSAGE : /* Class:tlPlatform - Method: getLinkedToTestplanAsMap */ SELECT P.id, P.name FROM platforms P JOIN testplan_platforms TP ON P.id = TP.platform_id WHERE TP.testplan_id = ORDER BY name Query failed: errorcode[1064] errormsg: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 'ORDER BY name' at line 1


Steps To Reproducecreate testplan
add testcase
create more than 6 active builds
go to test result matrix
in dialog select some builds
in test result matrix, press "refresh" or "Reset to default state" in the Test Result matrix header gui
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
Browser
PHP Version
TestCaseID
QA Team - Task Workflow StatusREADY FOR TESTING
Attached Files

- Relationships
child of 0008397assignedfman Availables hot-fixes for 1.9.18 & How To get full fixed package from GitHub 

-  Notes
(0028317)
fman (administrator)
2018-12-12 21:43

https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/5385c8131aa331a1dbc2b5af5e119e5671cc8344 [^]

- Issue History
Date Modified Username Field Change
2018-12-10 16:56 heju New Issue
2018-12-12 21:43 fman QA Team - Task Workflow Status => READY FOR TESTING
2018-12-12 21:43 fman Note Added: 0028317
2018-12-12 21:43 fman Status new => resolved
2018-12-12 21:43 fman Resolution open => fixed
2018-12-12 21:43 fman Assigned To => fman
2018-12-12 21:43 fman Fixed in Version => 1.9.19 (2019 Q1)
2018-12-12 21:43 fman Relationship added child of 0008397



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker