Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008496TestLinkTest Plan - Add/Remove Test Casespublic2018-11-30 12:072018-11-30 22:56
Reporternoliveira 
Assigned Tofman 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusassignedResolutionopen 
PlatformOSOS Version
Product Version1.9.18 (2018 Q3) 
Fixed in Version 
Summary0008496: Error while add a test or multiple tests to a test plan
DescriptionI am receiving the error at the screen shot and the txt file while adding a test or multiple tests to a test plan
Steps To ReproduceAdd a test or multiple tests to a testplan
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Filestxt file icon DBaccess_testlink.txt [^] (1,978,539 bytes) 2018-11-30 12:07
png file icon Screenshot 2018-11-30 at 11.59.01.png [^] (981,483 bytes) 2018-11-30 12:07

- Relationships

-  Notes
(0028287)
fman (administrator)
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 (administrator)
2018-11-30 13:59

As usual get latest code from github, do fresh install, retest and provide feedback
(0028289)
noliveira (reporter)
2018-11-30 14:01

To do a fresh install only need to do a mysqldump and copy config.inc.php?
(0028292)
fman (administrator)
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 (reporter)
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 (administrator)
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 (reporter)
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 (administrator)
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 (reporter)
2018-11-30 22:56

Ok. Thanks.
Can you please send me the part of the error that I should look at?

- Issue History
Date Modified Username Field Change
2018-11-30 12:07 noliveira New Issue
2018-11-30 12:07 noliveira File Added: DBaccess_testlink.txt
2018-11-30 12:07 noliveira File Added: Screenshot 2018-11-30 at 11.59.01.png
2018-11-30 13:58 fman Note Added: 0028287
2018-11-30 13:59 fman Note Added: 0028288
2018-11-30 14:01 noliveira Note Added: 0028289
2018-11-30 14:50 fman Note Added: 0028292
2018-11-30 15:21 noliveira Note Added: 0028293
2018-11-30 19:32 fman Note Added: 0028294
2018-11-30 19:32 fman Assigned To => fman
2018-11-30 19:32 fman Status new => feedback
2018-11-30 19:59 noliveira Note Added: 0028295
2018-11-30 19:59 noliveira Status feedback => assigned
2018-11-30 22:54 fman Note Added: 0028296
2018-11-30 22:56 noliveira Note Added: 0028297



Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker