MantisBT - TestLink
View Issue Details
0008946TestLinkTest Specification Importpublic2020-06-23 10:252020-06-25 15:34
imash 
fman 
highmajoralways
resolvedunable to reproduce 
dcker container Ubuntu16.04.3
1.9.19 (2019 Q1) 
1.9.20_fixed 
mariadb
chrome
PHP 7.3.13
TBD
0008946: Unable to Import Test Suite (XML format) with quotation symbol included within test suites/test cases
Unable to Import Test Suite (XML format) with single quotation symbol included within test suites/test cases.

Here we get DB access error when importing XML file.
Steps to Recreate:
01 - Access TestLink
02 - Goto Test Specification >> Select a test suite
03 - Click on Actions>>Test Suite Operations>>Import
04 - Select an XML file which include quotation mark within test suite name
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(INSERT INTO nodes_hierarchy (name,node_type_id,node_order,parent_id) VALUES('CR_FG_055: Supplier Notification - \'Add Passenger to Item\' & \'Remove Passenger from Item\' as Amendment Triggers', 2,1,3085683)) called at [/opt/bitnami/testlink/lib/functions/tree.class.php:160]

#1 tree->new_node(3085683, 2, CR_FG_055: Supplier Notification - 'Add Passenger to Item' & 'Remove Passenger from Item' as Amendment Triggers, 1) called at [/opt/bitnami/testlink/lib/functions/testsuite.class.php:186]

0000002 testsuite->create(3085683, CR_FG_055: Supplier Notification - 'Add Passenger to Item' & 'Remove Passenger from Item' as Amendment Triggers,

 
Pro tip: press M to comment
Assignee
Kemila Hettinarayana
Reporter
Pamuditha Madusanka
Labels
TestLink
Gap/CR/Story Ref
None
JS Ref
None
Project Ref
None
Category
None
TravelBox Clients
None
Epic/Theme
None
External issue ID
None
Importance
Medium
TravelBox Libs
None
TravelBox Services
None
Deployed to QA
NO
Artifact Ready
NONE
GIM Libs
None
GIM Clients
None
GIM POM
None
GIM Services
None
Ext_Libraries
None
Ext_Services
None
Issue Category
None
Issue Category and Classification
None
Actual MD
None
Estimated MD
None
Priority
Medium
Automation
Rule executions
Smart Checklist
Open Smart Checklist
Exalate
Open Exalate
Created June 19, 2020, 2:50 PM
No tags attached.
png image(1).png (46,329) 2020-06-23 10:25
http://mantis.testlink.org/file_download.php?file_id=5365&type=bug
png

xml SUITE with 'the char'.testsuite-deep.xml (848) 2020-06-24 20:16
http://mantis.testlink.org/file_download.php?file_id=5366&type=bug
xml TS-100.testsuite-deep.xml (1,130) 2020-06-24 20:16
http://mantis.testlink.org/file_download.php?file_id=5367&type=bug
xml TS-100.2.testsuite-deep.xml (1,313) 2020-06-24 20:16
http://mantis.testlink.org/file_download.php?file_id=5368&type=bug
xml TS-100-2-3-testsuite-deep.xml (1,737) 2020-06-24 20:17
http://mantis.testlink.org/file_download.php?file_id=5369&type=bug
Issue History
2020-06-23 10:25imashNew Issue
2020-06-23 10:25imashFile Added: image(1).png
2020-06-24 10:29fmanNote Added: 0029779
2020-06-24 10:29fmanNote Added: 0029780
2020-06-24 10:30fmanStatusnew => feedback
2020-06-24 19:57fmanNote Added: 0029781
2020-06-24 20:16fmanFile Added: SUITE with 'the char'.testsuite-deep.xml
2020-06-24 20:16fmanFile Added: TS-100.testsuite-deep.xml
2020-06-24 20:16fmanFile Added: TS-100.2.testsuite-deep.xml
2020-06-24 20:17fmanFile Added: TS-100-2-3-testsuite-deep.xml
2020-06-24 20:29fmanNote Added: 0029782
2020-06-25 15:34fmanQA Team - Task Workflow Status => TBD
2020-06-25 15:34fmanStatusfeedback => resolved
2020-06-25 15:34fmanFixed in Version => 1.9.20_fixed
2020-06-25 15:34fmanResolutionopen => unable to reproduce
2020-06-25 15:34fmanAssigned To => fman

Notes
(0029779)
fman   
2020-06-24 10:29   
for import issues a sample file is mandatory, without it no action can be taken
(0029780)
fman   
2020-06-24 10:29   
please upgrade to branch testlink_1_9_20_fixed
retest and provide feedback
(0029781)
fman   
2020-06-24 19:57   
tested with branch testlink_1_9_20_fixed with attached files
unable to reproduce

IMHO the problem is related to test case name length > 100 chars.

The issue that import needs to cut the exceeding characters.

But as you can understand If you have provided the exact sample XML, the issue will arise immediately in my environment
(0029782)
fman   
2020-06-24 20:29   
More investigation shows that import cuts the name for test suite e test name to 100 in testlink_1_9_20_fixed