MantisBT - TestLink
View Issue Details
0006994TestLinkGUIpublic2015-03-11 07:442015-09-19 08:49
Reinhard Borek 
fman 
normalminoralways
closedfixed 
x86-64Windows8, Server 2008 R
1.9.13 (2015 #1) 
1.9.14 (2015 Q3) 
MySQL
Chrome, Internet Browser
5.6.3
READY FOR TESTING
0006994: Database search queries are displayed in GUI
In GUI frames where displays information based on tree structured test cases database search queries are displayed (an example is in "Additional Information").
It looks like additional debug information. I looked after some setup issue and think that I turn off all debug logs.
With the previous version of Testlink and the same database this not occurs.
odes_hierarchy NH_TCV ON NH_TCV.id = TPTCV.tcversion_id JOIN nodes_hierarchy NH_TCASE ON NH_TCASE.id = NH_TCV.parent_id LEFT OUTER JOIN platforms PLAT ON PLAT.id = TPTCV.platform_id JOIN ( SELECT EE.tcversion_id,EE.testplan_id,EE.platform_id,EE.build_id, MAX(EE.id) AS id FROM executions EE WHERE EE.testplan_id = 283 GROUP BY EE.tcversion_id,EE.testplan_id,EE.platform_id,EE.build_id ) AS LEX ON LEX.testplan_id = TPTCV.testplan_id AND LEX.platform_id = TPTCV.platform_id AND LEX.tcversion_id = TPTCV.tcversion_id AND LEX.testplan_id = 283 JOIN executions E ON E.tcversion_id = TPTCV.tcversion_id AND E.testplan_id = TPTCV.testplan_id AND E.platform_id = TPTCV.platform_id AND E.id = LEX.id WHERE TPTCV.testplan_id =283 AND NH_TCASE.parent_id IN (296) UNION /* Class:testplan - Method: getLinkedTCVersionsSQL sqlUnion - not run */ SELECT NH_TCASE.name AS tcase_name, NH_TCASE.id AS tcase_id, NH_TCASE.id AS tc_id,TPTCV.tcversion_id,TCV.version, TCV.tc_external_id AS external_id, TCV.execution_type,TCV.status, TPTCV.id AS feature_id, TPTCV.platform_id,PLAT.name AS platform_name,TPTCV.node_order AS execution_order, COALESCE(E.status,'n') AS exec_status, E.execution_duration, TCV.importance,CONCAT('cmsT-',TCV.tc_external_id) AS full_external_id ,COALESCE(E.id,0) AS exec_id,E.tcversion_number,E.build_id AS exec_on_build,E.testplan_id AS exec_on_tplan,NH_TCASE.name,TPTCV.creation_ts AS linked_ts,TPTCV.author_id AS linked_by,NH_TCASE.parent_id AS testsuite_id FROM testplan_tcversions TPTCV JOIN tcversions TCV ON TCV.id = TPTCV.tcversion_id JOIN nodes_hierarchy NH_TCV ON NH_TCV.id = TPTCV.tcversion_id JOIN nodes_hierarchy NH_TCASE ON NH_TCASE.id = NH_TCV.parent_id LEFT OUTER JOIN platforms PLAT ON PLAT.id = TPTCV.platform_id /* Get REALLY NOT RUN => BOTH LE.id AND E.id ON LEFT OUTER see WHERE */ LEFT OUTER JOIN ( SELECT EE.tcversion_id,EE.testplan_id,EE.platform_id,EE.build_id, MAX(EE.id) AS id FROM executions EE WHERE EE.testplan_id = 283 GROUP BY EE.tcversion_id,EE.testplan_id,EE.platform_id,EE.build_id ) AS LEX ON LEX.testplan_id = TPTCV.testplan_id AND LEX.platform_id = TPTCV.platform_id AND LEX.tcversion_id = TPTCV.tcversion_id AND LEX.testplan_id = 283 LEFT OUTER JOIN executions E ON E.tcversion_id = TPTCV.tcversion_id AND E.testplan_id = TPTCV.testplan_id AND E.platform_id = TPTCV.platform_id AND E.id = LEX.id WHERE TPTCV.testplan_id =283 AND NH_TCASE.parent_id IN (296) /* Get REALLY NOT RUN => BOTH LE.id AND E.id NULL */ AND E.id IS NULL AND LEX.id IS NULL
No tags attached.
png 2015-03-11 08_32_46-TestLink 1.9.14 [DEV] (Padawan).png (132,030) 2015-03-11 07:44
http://mantis.testlink.org/file_download.php?file_id=4137&type=bug
png

? config.inc.php (69,271) 2015-03-11 07:45
http://mantis.testlink.org/file_download.php?file_id=4138&type=bug
? custom_config.inc.php (10,308) 2015-03-11 07:45
http://mantis.testlink.org/file_download.php?file_id=4139&type=bug
Issue History
2015-03-11 07:44Reinhard BorekNew Issue
2015-03-11 07:44Reinhard BorekFile Added: 2015-03-11 08_32_46-TestLink 1.9.14 [DEV] (Padawan).png
2015-03-11 07:45Reinhard BorekFile Added: config.inc.php
2015-03-11 07:45Reinhard BorekFile Added: custom_config.inc.php
2015-03-11 10:06fmanNote Added: 0022855
2015-03-11 10:23Reinhard BorekNote Added: 0022857
2015-03-11 10:24fmanNote Added: 0022859
2015-03-11 10:27Reinhard BorekNote Added: 0022860
2015-03-12 21:39fmanNote Added: 0022887
2015-03-12 21:39fmanQA Team - Task Workflow Status => READY FOR TESTING
2015-03-12 21:39fmanStatusnew => resolved
2015-03-12 21:39fmanFixed in Version => 1.9.14 (2015 Q3)
2015-03-12 21:39fmanResolutionopen => fixed
2015-03-12 21:39fmanAssigned To => fman
2015-03-13 15:21Reinhard BorekNote Added: 0022893
2015-09-19 08:49fmanNote Added: 0023977
2015-09-19 08:49fmanStatusresolved => closed

Notes
(0022855)
fman   
2015-03-11 10:06   
I understand what is happening, but the way issue was described is not good.
I need always I say always no matter how simple do you think issue is: detailed
steps to reproduce.
(0022857)
Reinhard Borek   
2015-03-11 10:23   
Thank you for your quick answer.
Detailed steps to reproduce (is one way of several):
1. Create a test project, a platform
2. Create some test cases with test suite tree structure at least to order 2 and more as one test case in each test suite
3. Create a test plan, a build
4. Assign platform to test plan
5. Open "Add / Remove Test Cases "
6. Select on the left pane a test suite with includes some test cases.

It is very difficult for me to decide what important/helpful is for you to reproduce this behavior. Of course I creates some custom fields, set up some relationships between the test cases and so on.
I'm afraid I can certainly only say:
1. With the previous version of Testlink and the same database this not occurs.
2. Requirements have not any influence. It happens with test cases which are associated with requirements also witch one aren't related.
If you have any detailed questions please ask me.
(0022859)
fman   
2015-03-11 10:24   
OK now is better thanks for helping
(0022860)
Reinhard Borek   
2015-03-11 10:27   
Your welcome. I know how difficult it is to figure out bugs without helpful description.
(0022887)
fman   
2015-03-12 21:39   
to quick fix this
look for file:
testplan.class.php
-> Method: getLinkedTCVersionsSQL
remove any echo or new dBug() you will find
(0022893)
Reinhard Borek   
2015-03-13 15:21   
I removed in "testplan.class.php"
-> Method: getLTCVNewGeneration
at line 6721 and 6722 two echo.

It helps.

Thanks a lot.
(0023977)
fman   
2015-09-19 08:49   
1.9.14 Padawan - released - 2015-09-19