MantisBT - TestLink
View Issue Details
0008080TestLinkGUIpublic2017-09-19 19:512018-04-14 09:04
acoloma 
fman 
normalminoralways
closedfixed 
WindowsWindows Server 2012 R26.3.9600
1.9.16 (2016 Q4) 
1.9.17 (2018 Q1) 
MySQL
IE, Edge, Firefox & Chrome
PHP 7.1.2
TBD
0008080: Search Test Cases displays query
Search Test Cases feature displays the database query on top of the Form.
1. From Desktop
2. Click on Search Test Cases
3. Fill in Creation Date From:, Creation Date To:, Modification Date From: & Modification Date To: Form
4. Click on Find.
Here is the query displayed:
RRR SELECT NH_TC.id AS testcase_id,NH_TC.name,TCV.id AS tcversion_id, TCV.summary, TCV.version, TCV.tc_external_id FROM nodes_hierarchy NH_TC JOIN nodes_hierarchy NH_TCV ON NH_TCV.parent_id = NH_TC.id JOIN tcversions TCV ON NH_TCV.id = TCV.id LEFT OUTER JOIN nodes_hierarchy NH_TCSTEPS ON NH_TCSTEPS.parent_id = NH_TCV.id LEFT OUTER JOIN tcsteps TCSTEPS ON NH_TCSTEPS.id = TCSTEPS.id WHERE 1=1 AND TCV. creation_ts >= '2016-01-04' AND TCV.creation_ts <= '2017-06-05 23:59:59' AND TCV. modification_ts >= '2016-01
No tags attached.
child of 0007817closed fman Availables hot-fixes for 1.9.16 & How To get full fixed package from GitHub 
png Search_Test_Cases.png (148,752) 2017-09-19 19:51
http://mantis.testlink.org/file_download.php?file_id=4813&type=bug
png
Issue History
2017-09-19 19:51acolomaNew Issue
2017-09-19 19:51acolomaFile Added: Search_Test_Cases.png
2017-09-19 19:54acolomaNote Added: 0026851
2017-09-20 08:39fmanQA Team - Task Workflow Status => TBD
2017-09-20 08:39fmanAdditional Information Updatedbug_revision_view_page.php?rev_id=5356#r5356
2017-09-20 08:39fmanNote Added: 0026852
2017-09-20 08:44fmanNote Added: 0026855
2017-09-20 08:45fmanStatusnew => resolved
2017-09-20 08:45fmanFixed in Version => 1.9.17 (2018 Q1)
2017-09-20 08:45fmanResolutionopen => fixed
2017-09-20 08:45fmanAssigned To => fman
2017-09-20 08:45fmanRelationship addedchild of 0007817
2017-09-21 16:54acolomaNote Added: 0026858
2017-09-21 19:10fmanNote Added: 0026859
2018-04-14 09:04fmanNote Added: 0027314
2018-04-14 09:04fmanStatusresolved => closed

Notes
(0026851)
acoloma   
2017-09-19 19:54   
I tried the fix here but it didn't help.
Database search queries are displayed in GUI
http://mantis.testlink.org/print_bug_page.php?bug_id=6994 [^]

Commented out these lines on this file.
C:\xampp\htdocs\testlink-1.9.16\lib\functions\testplan.class.php

6815 # new dBug($rs);
7049 # new dBug($my['join']['ua']);
7106 # new dBug($union);
(0026852)
fman   
2017-09-20 08:39   
Thanks for help, I'm going to fix
(0026855)
fman   
2017-09-20 08:44   
if you see this info is because you have configured the debug enabled.

https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/a7e441a14caeec0af9c27941c04d52c788748e8f [^]
(0026858)
acoloma   
2017-09-21 16:54   
I tried using the testplan.class.php file from GitHub but the issue persisted.
Downloaded the file and replace the one under
C:\xampp\htdocs\testlink-1.9.16\lib\functions\testplan.class.php
(0026859)
fman   
2017-09-21 19:10   
well is near impossible because I've removed the debug lines.
double check that you have the right code
(0027314)
fman   
2018-04-14 09:04   
release 1.9.17