Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008702TestLinkTest Plan - Add/Remove Test Casespublic2019-06-19 11:362020-01-28 13:41
Reportermjltigger 
Assigned To 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformChromeOSWindowsOS Version10
Product Version1.9.17 (2018 Q1) 
Fixed in Version 
Summary0008702: unable to assign test cases by requirement if filtered on custom field
Descriptionwhen assigning test cases to a test plan, if the custom field filter is used, TestLink reports 'No Test Case Available'
Steps To ReproduceHave a custom field (check box with 6 options) for requirements
Have requirements with the check boxes set appropriately
Have test cases assigned to some requirements
Have a test plan
Have platforms assigned to test plans

From main menu, select valid current test plan (UAT 1)
Select Add/Remove Test Cases
In 'Settings' select UAT 1 (already populated)
In settings, select 'Tests Grouped' = Requirements
In Filters, select a check box against a custom fild (Delivery Phase (Sprint) = UAT1
Click Apply
Select the requirement folder containing the requirements
The main pain displays ' No Test Case Available'

Additional Informationif the same steps are followed but without selecting the custom field filter, test cases are displayed and can be correctly assigned.
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
BrowserChrome
PHP Version7.2.10
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
(0028956)
fman (administrator)
2019-06-19 14:34

please get latest code from github, do fresh install, retest and provide feedback

provide the XML EXPORT OF CUSTOM FIELDS
(0028960)
mjltigger (reporter)
2019-06-24 08:21

thank you, @fman. I will get onto this during this coming week.
(0029455)
mjltigger (reporter)
2020-01-28 11:34
edited on: 2020-01-28 13:41

have upgraded to 1.9.19. Issue is now worse but more obvious. With or without the custom fields selected I now get this issue when selecting a requirement in the add_remove_tes_cases screen
 ==============================================================================
 DB Access Error - debug_print_backtrace() OUTPUT START
 ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200)
            Having this additional Information could be useful for reporting
            issue to development TEAM.
 ==============================================================================
#0 database->exec_query( SELECT NH_TC.id,NH_TC.name,NH_TC.parent_id, NH_TC.node_type_id,NH_TC.node_order FROM nodes_hierarchy AS NH_TC JOIN req_coverage RC ON RC.testcase_id = id WHERE RC.req_id = 9243 AND node_type_id NOT IN (5,6,7) ORDER BY node_order,id) called at [C:\xampp\htdocs\TestLink\lib\functions\tree.class.php:948]
#1 tree->_get_subtree(9243, Array (), Array ([exclude_node_types] => Array ([testplan] => exclude_me,[requirement_spec] => exclude_me,[requirement] => exclude_me),[exclude_children_of] => Array ([testcase] => exclude_my_children,[requirement_spec] => exclude_my_children),[exclude_branches] => ,[additionalWhereClause] => AND node_type_id NOT IN (5,6,7),[family] => ), Array ([recursive] => ,[order_cfg] => Array ([type] => req_order),[output] => full,[key_type] => std,[addJoin] => ,[addFields] => ,[exclude_testcases] => )) called at [C:\xampp\htdocs\TestLink\lib\functions\tree.class.php:859]
0000002 tree->get_subtree(9243, Array ([exclude_node_types] => Array ([testplan] => exclude_me,[requirement_spec] => exclude_me,[requirement] => exclude_me),[exclude_children_of] => Array ([testcase] => exclude_my_children,[requirement_spec] => exclude_my_children),[exclude_branches] => ,[additionalWhereClause] => ), Array ([recursive] => ,[exclude_testcases] => ,[output] => full,[order_cfg] => Array ([type] => req_order))) called at [C:\xampp\htdocs\TestLink\lib\functions\testproject.class.php:764]
0000003 testproject->get_subtree(9243, , Array ([order_cfg] => Array ([type] => req_order))) called at [C:\xampp\htdocs\TestLink\lib\functions\specview.php:698]
0000004 getTestSpecFromNode(database Object ([db] => ADODB_mysqli Object ([databaseType] => mysqli,[dataProvider] => mysql,[hasInsertID] => ...

(0029456)
fman (administrator)
2020-01-28 13:40

dear user:
If the issue is related to import, I need all the XML files that can help to reproduce the same scenario, without it trying to reproduce is hard


can you try the query
SELECT NH_TC.id,NH_TC.name,NH_TC.parent_id, NH_TC.node_type_id,NH_TC.node_order FROM nodes_hierarchy AS NH_TC JOIN req_coverage RC ON RC.testcase_id = id WHERE RC.req_id = 9243 AND node_type_id NOT IN (5,6,7) ORDER BY node_order,id

on your sql client, in order to get more detailed error info?

thanks a lot
(0029457)
fman (administrator)
2020-01-28 13:41

Please when you have lot of text in an error message, attach a text file, is easier to manage

- Issue History
Date Modified Username Field Change
2019-06-19 11:36 mjltigger New Issue
2019-06-19 14:34 fman Note Added: 0028956
2019-06-24 08:21 mjltigger Note Added: 0028960
2020-01-28 11:34 mjltigger Note Added: 0029455
2020-01-28 13:40 fman Note Added: 0029456
2020-01-28 13:41 fman Note Added: 0029457
2020-01-28 13:41 fman Note Edited: 0029455 View Revisions



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker