MantisBT - TestLink
View Issue Details
0008499TestLinkDatabase MySQLpublic2018-12-10 16:562018-12-12 21:43
heju 
fman 
normalminoralways
resolvedfixed 
1.9.17 (2018 Q1) 
1.9.19 (2019 Q1) 
MySQL
READY FOR TESTING
0008499: DB Access Error at refresh of "Test result matrix" in case more than 6 builds are active
In 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


create 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
No tags attached.
child of 0008397closed fman Availables hot-fixes for 1.9.18 & How To get full fixed package from GitHub 
Issue History
2018-12-10 16:56hejuNew Issue
2018-12-12 21:43fmanQA Team - Task Workflow Status => READY FOR TESTING
2018-12-12 21:43fmanNote Added: 0028317
2018-12-12 21:43fmanStatusnew => resolved
2018-12-12 21:43fmanResolutionopen => fixed
2018-12-12 21:43fmanAssigned To => fman
2018-12-12 21:43fmanFixed in Version => 1.9.19 (2019 Q1)
2018-12-12 21:43fmanRelationship addedchild of 0008397

Notes
(0028317)
fman   
2018-12-12 21:43   
https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/5385c8131aa331a1dbc2b5af5e119e5671cc8344 [^]