Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008851TestLinkKeywordspublic2020-01-21 15:092020-01-21 20:39
Reporteratisne 
Assigned Tofman 
PrioritynormalSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.9.20_fixed 
Fixed in Version1.9.20_fixed 
Summary0008851: Create and Link an existing keywork fails with a DB error
DescriptionReproduced on Testlink 1.9.20 (github source @2020-01-21)

On a Test Case, if we use the action 'Create and Link' keyword, using an already existing keyword, the function fails displaying a DB error (see addition information).
Steps To Reproduce1- Create a keyword
2- Edit a Test Case
3- Create and Link a keyword using the same label used in step 1
-> DB error
Additional Information#0 database->exec_query() called at [/opt/testlink/lib/functions/testcase.class.php:3361]
#1 testcase->addKeywords() called at [/opt/testlink/lib/keywords/keywordsEdit.php:273]
0000002 do_cfl() called at [/opt/testlink/lib/keywords/keywordsEdit.php:45]

2020-01-20 09:13:38.350 CET [30962] testlink ERROR: insert or update on table "tltestcase_keywords" violates foreign key constraint "tltestcase_keywords_keyword_id_fkey"
2020-01-20 09:13:38.350 CET [30962] testlink DETAIL: Key (keyword_id)=(-1) is not present in table "tlkeywords".
2020-01-20 09:13:38.350 CET [30962] testlink STATEMENT: /* Class:testcase - Method: addKeywords */ INSERT INTO tltestcase_keywords (testcase_id,tcversion_id,keyword_id) VALUES (715,716,-1)
TagsNo tags attached.
Database (MySQL,Postgres,etc)Mysql / Postgresql
BrowserFirefox
PHP VersionPHP 7
TestCaseID
QA Team - Task Workflow StatusREADY FOR TESTING
Attached Files

- Relationships
child of 0008846assignedfman Availables hot-fixes for 1.9.20 & How To get full fixed package from GitHub 

-  Notes
(0029441)
atisne (reporter)
2020-01-21 15:16

Fix suggested https://github.com/TestLinkOpenSourceTRMS/testlink-code/pull/248 [^]
(0029443)
fman (administrator)
2020-01-21 20:37

thanks for the analysis and proposal.
I've solved it in a different way.

https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/570e5e7b5c4214c90c9aeaed4aff469ea2ccd9a9 [^]

- Issue History
Date Modified Username Field Change
2020-01-21 15:09 atisne New Issue
2020-01-21 15:16 atisne Note Added: 0029441
2020-01-21 20:37 fman Note Added: 0029443
2020-01-21 20:37 fman Relationship added child of 0008846
2020-01-21 20:38 fman QA Team - Task Workflow Status => TBD
2020-01-21 20:38 fman Product Version => 1.9.20_fixed
2020-01-21 20:38 fman Fixed in Version => 1.9.20_fixed
2020-01-21 20:39 fman QA Team - Task Workflow Status TBD => READY FOR TESTING
2020-01-21 20:39 fman Status new => resolved
2020-01-21 20:39 fman Resolution open => fixed
2020-01-21 20:39 fman Assigned To => fman



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker