MantisBT - TestLink
View Issue Details
0008588TestLinkKeywordspublic2019-03-07 04:142019-04-02 20:39
Henry_Zhang 
fman 
normalmajoralways
resolvedfixed 
LinuxCentos 7.4
1.9.19 (2019 Q1) 
 
MySQL
Chrome
TBD
0008588: Failed to delete the keywords
Failed to delete the keywords on the keyword management page with below error?SELECT DISTINCT keyword_id,keyword, CASE WHEN TCV.is_open=0 THEN 'FROZEN' ELSE 'FRESH' END AS freeze_status FROM keywords KW JOIN testcase_keywords TCKW ON TCKW.keyword_id = KW.id JOIN tcversions TCV ON TCV.id = TCKW.tcversion_id WHERE KW.id = 3
1. Deploy testlink V1.9.19 on VM
2. Create a new keyword on the keyword management page
3. Delete the keyword created at step2
4.Failed with error:
SELECT DISTINCT keyword_id,keyword, CASE WHEN TCV.is_open=0 THEN 'FROZEN' ELSE 'FRESH' END AS freeze_status FROM keywords KW JOIN testcase_keywords TCKW ON TCKW.keyword_id = KW.id JOIN tcversions TCV ON TCV.id = TCKW.tcversion_id WHERE KW.id = 3
5. prompted : update fails

V1.9.18 works good on keywords management. no issue occur.
No tags attached.
png Delete_Keyword_Failed.png (46,078) 2019-03-07 04:14
http://mantis.testlink.org/file_download.php?file_id=5111&type=bug
png
Issue History
2019-03-07 04:14Henry_ZhangNew Issue
2019-03-07 04:14Henry_ZhangFile Added: Delete_Keyword_Failed.png
2019-03-07 20:50fmanNote Added: 0028577
2019-03-07 20:51fmanNote Edited: 0028577bug_revision_view_page.php?bugnote_id=28577#r5760
2019-03-07 20:52fmanNote Added: 0028578
2019-03-07 20:52fmanAssigned To => fman
2019-03-07 20:52fmanStatusnew => feedback
2019-04-02 20:39fmanQA Team - Task Workflow Status => TBD
2019-04-02 20:39fmanNote Added: 0028645
2019-04-02 20:39fmanStatusfeedback => resolved
2019-04-02 20:39fmanResolutionopen => fixed

Notes
(0028577)
fman   
2019-03-07 20:50   
(edited on: 2019-03-07 20:51)
fixed in branch 1.9.19.01 =>
 https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/7f07e1af4a08fb7b090e17f0fe0b180d4017d094 [^]

fixed in latest dev version
https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/ee7b552aad95e52fc39166fa4cdda57fd4d58e42 [^]

(0028578)
fman   
2019-03-07 20:52   
please apply fix and provide feedback
(0028645)
fman   
2019-04-02 20:39   
no more user feedback