MantisBT - TestLink
View Issue Details
0008844TestLinkTest Execution - Bulk Modepublic2020-01-13 14:202020-01-22 12:02
spirogov 
fman 
normalminoralways
resolvedfixed 
1.9.19 (2019 Q1) 
1.9.20_fixed 
MySQL
Opera, Chrome
7.3.13
READY FOR TESTING
0008844: Errors when user executes Test Suite
I've installed latest TestLink 1.9.19-10 using installer from Bitnami and executed sqls from the last db backup (we used 1.9.15-2).
And I get errors when I tried to execute any Test Suite.
But all is ok if I execute test case one-by-one.
1. Open Test Execution.
2. Select Test Suite. F.e. there are 6 cases in this test suite.
3. Select Passed radio button and click Save Execution button in result section.
4. Errors occur (please see screen shot).
Please see errors:

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(/* Class:testproject - Method: getTestCasePrefix */ SELECT prefix FROM testprojects WHERE id = ) called at [C:\Bitnami\testlink-1.9.19-10\apps\testlink\htdocs\lib\functions\database.class.php:553]
#1 database->fetchFirstRow(/* Class:testproject - Method: getTestCasePrefix */ SELECT prefix FROM testprojects WHERE id = ) called at [C:\Bitnami\testlink-1.9.19-10\apps\testlink\htdocs\lib\functions\database.class.php:573]
0000002 database->fetchOneValue(/* Class:testproject - Method: getTestCasePrefix */ SELECT prefix FROM testprojects WHERE id = ) called at [C:\Bitnami\testlink-1.9.19-10\apps\testlink\htdocs\lib\functions\testproject.class.php:1045]
0000003 testproject->getTestCasePrefix() called at [C:\Bitnami\testlink-1.9.19-10\apps\testlink\htdocs\lib\functions\testcase.class.php:1780]
0000004 testcase->getPrefix(Array ([0] => 27934,[1] => 27938,[2] => 27942,[3] => 27946,[4] => 27950,[5] => 27956), ) called at [C:\Bitnami\testlink-1.9.19-10\apps\testlink\htdocs\lib\functions\testcase.class.php:5228]
0000005 testcase->getExternalID(Array ([0] => 27934,[1] => 27938,[2] => 27942,[3] => 27946,[4] => 27950,[5] => 27956)) called at [C:\Bitnami\testlink-1.9.19-10\apps\testlink\htdocs\lib\execute\execSetResults.php:165]
No tags attached.
related to 0008130resolved fman Save execution DB Access Error in bulk mode 
jpg 2020-01-13_16h00_18.jpg (302,323) 2020-01-13 14:20
http://mantis.testlink.org/file_download.php?file_id=5276&type=bug
png NewProject_TestSuite_Selection_issue.png (81,634) 2020-01-14 12:42
http://mantis.testlink.org/file_download.php?file_id=5277&type=bug
png

png Steps.png (105,181) 2020-01-15 11:47
http://mantis.testlink.org/file_download.php?file_id=5280&type=bug
png

png Result.png (72,114) 2020-01-15 11:47
http://mantis.testlink.org/file_download.php?file_id=5281&type=bug
png

png Expected result.png (81,290) 2020-01-15 11:47
http://mantis.testlink.org/file_download.php?file_id=5282&type=bug
png
Issue History
2020-01-13 14:20spirogovNew Issue
2020-01-13 14:20spirogovFile Added: 2020-01-13_16h00_18.jpg
2020-01-13 17:37fmanNote Added: 0029409
2020-01-13 17:37fmanAssigned To => fman
2020-01-13 17:37fmanStatusnew => feedback
2020-01-14 12:41spirogovNote Added: 0029411
2020-01-14 12:41spirogovStatusfeedback => assigned
2020-01-14 12:42spirogovFile Added: NewProject_TestSuite_Selection_issue.png
2020-01-14 12:43spirogovNote Edited: 0029411bug_revision_view_page.php?bugnote_id=29411#r5991
2020-01-14 13:18fmanNote Added: 0029412
2020-01-15 11:46spirogovNote Added: 0029413
2020-01-15 11:47spirogovFile Added: Steps.png
2020-01-15 11:47spirogovFile Added: Result.png
2020-01-15 11:47spirogovFile Added: Expected result.png
2020-01-21 22:04fmanNote Added: 0029444
2020-01-21 22:04fmanQA Team - Task Workflow Status => READY FOR TESTING
2020-01-21 22:04fmanStatusassigned => resolved
2020-01-21 22:04fmanFixed in Version => 1.9.20_fixed
2020-01-21 22:04fmanResolutionopen => fixed
2020-01-22 11:53spirogovNote Added: 0029448
2020-01-22 12:02fmanRelationship addedrelated to 0008130

Notes
(0029409)
fman   
2020-01-13 17:37   
in this query
SELECT prefix FROM testprojects WHERE id =

the value for id is missing => this is the issue

are you doing BULK execution?

Please retry using a fresh install => not with your restored data
(0029411)
spirogov   
2020-01-14 12:41   
(edited on: 2020-01-14 12:43)
I've installed bitnami-testlink-1.9.19-10-windows-x64-installer on my local machine and create new test project, new test plan, test platforms, build, test suite, 6 test cases, add them to test plan and assigned them to myself.
After that I select Test Execution -> select Test Plan in tree -> right panel is refreshed -> select Test Suite in the tree -> nothing happens in right panel (please see screen shot - NewProject_TestSuite_Selection_issue.png).
Maybe I forgot something to add?


Note: For initial issue's description - I have 2 projects in testprojects table with id=1 and id=10033.

(0029412)
fman   
2020-01-14 13:18   
Your issue reporting has changed, it's not clear what do you expect.
Again: do you have configured Bulk execution?
standard config is nothing happens on exec if you click on a test suite
(0029413)
spirogov   
2020-01-15 11:46   
Sorry, I didn't understand your request a little.

1. I have configured row below in config.inc.php:
$tlCfg->exec_cfg->show_testsuite_contents = ENABLED;
2. Select Test Suite.
3. Select Passed radio button in Result section and click Save execution button (please see screen shot: Steps.png).
As a result I get errors (please see screen shot: Result.png).
I expect that all cases are marked as Passed without these error messages (please see screen shot: Expected result.png).
(0029444)
fman   
2020-01-21 22:04   
fixed here
https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/6301b1421619f0705efa815639f2a3d0a34842d9 [^]
(0029448)
spirogov   
2020-01-22 11:53   
Thanks a lot.