MantisBT - TestLink
View Issue Details
0008496TestLinkTest Plan - Add/Remove Test Casespublic2018-11-30 12:072018-12-17 20:58
normalminorhave not tried
closedunable to reproduce 
1.9.18 (2018 Q3) 
0008496: Error while add a test or multiple tests to a test plan
I am receiving the error at the screen shot and the txt file while adding a test or multiple tests to a test plan
Add a test or multiple tests to a testplan
No tags attached.
txt DBaccess_testlink.txt (1,978,539) 2018-11-30 12:07
png Screenshot 2018-11-30 at 11.59.01.png (981,483) 2018-11-30 12:07
Issue History
2018-11-30 12:07noliveiraNew Issue
2018-11-30 12:07noliveiraFile Added: DBaccess_testlink.txt
2018-11-30 12:07noliveiraFile Added: Screenshot 2018-11-30 at 11.59.01.png
2018-11-30 13:58fmanNote Added: 0028287
2018-11-30 13:59fmanNote Added: 0028288
2018-11-30 14:01noliveiraNote Added: 0028289
2018-11-30 14:50fmanNote Added: 0028292
2018-11-30 15:21noliveiraNote Added: 0028293
2018-11-30 19:32fmanNote Added: 0028294
2018-11-30 19:32fmanAssigned To => fman
2018-11-30 19:32fmanStatusnew => feedback
2018-11-30 19:59noliveiraNote Added: 0028295
2018-11-30 19:59noliveiraStatusfeedback => assigned
2018-11-30 22:54fmanNote Added: 0028296
2018-11-30 22:56noliveiraNote Added: 0028297
2018-12-17 20:58fmanQA Team - Task Workflow Status => TBD
2018-12-17 20:58fmanStatusassigned => closed
2018-12-17 20:58fmanResolutionopen => unable to reproduce

2018-11-30 13:58   
Please provide better detailed steps to reproduce. The details are needed to be sure we are using same scenario.
You can find an example here on mantis.
2018-11-30 13:59   
As usual get latest code from github, do fresh install, retest and provide feedback
2018-11-30 14:01   
To do a fresh install only need to do a mysqldump and copy
2018-11-30 14:50   
1) fresh install means as you nevet have ibstalled testljnk.
2) if you give a look to the error message you are going to find some issue exists with your data, that's why sql with In clayse fails trying to get audit data.
2018-11-30 15:21   
Steps to reproduce:
1. open Testlink and select Add/Remove Test cases in Desktop page
2. Click in one of the available suites on the left side of the screen
3. select the suites/test cases (manually or by selecting sdding button) on the right side of the screen
4. click in add/remove selected button

Expected recult: The selected suite(s)/test cases should be added to the test plan/build

Actual result: An error occurs, informing the user that the access to the DB is not possible
2018-11-30 19:32   
Please read carefully my previous note, issue is generated by your DATA, something is wrong in your DB.
You can see in the error message that the IN CLAUSE has a missing value.
With a fresh install with a new db issue will not be reproduced.

Please always provide info about if you are doing a Testlink upgrade or a new/fresh install. This info is CRITIC
2018-11-30 19:59   
We do an upgrade with your documentation. How do we solve this problem? We are not a Testlink experts.
2018-11-30 22:54   
We do not know if issue with your data was present there before the upgrade.
Unfortunately I will not have time to help till 15/12.
But you can try to find the wrong data by youself addind one of testcases at a time and find what is creating the issue.
Looking for the available documentation on db schema it will help.
2018-11-30 22:56   
Ok. Thanks.
Can you please send me the part of the error that I should look at?