MantisBT - TestLink
View Issue Details
0008496TestLinkTest Plan - Add/Remove Test Casespublic2018-11-30 12:072018-11-30 22:56
noliveira 
fman 
normalminorhave not tried
assignedopen 
1.9.18 (2018 Q3) 
 
MySQL
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
http://mantis.testlink.org/file_download.php?file_id=5051&type=bug
png Screenshot 2018-11-30 at 11.59.01.png (981,483) 2018-11-30 12:07
http://mantis.testlink.org/file_download.php?file_id=5052&type=bug
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

Notes
(0028287)
fman   
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.
(0028288)
fman   
2018-11-30 13:59   
As usual get latest code from github, do fresh install, retest and provide feedback
(0028289)
noliveira   
2018-11-30 14:01   
To do a fresh install only need to do a mysqldump and copy config.inc.php?
(0028292)
fman   
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.
(0028293)
noliveira   
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
(0028294)
fman   
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
(0028295)
noliveira   
2018-11-30 19:59   
We do an upgrade with your documentation. How do we solve this problem? We are not a Testlink experts.
(0028296)
fman   
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.
(0028297)
noliveira   
2018-11-30 22:56   
Ok. Thanks.
Can you please send me the part of the error that I should look at?