Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008588TestLinkKeywordspublic2019-03-07 04:142019-04-02 20:39
ReporterHenry_Zhang 
Assigned Tofman 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformLinuxOSCentos 7.4OS Version
Product Version1.9.19 (2019 Q1) 
Fixed in Version 
Summary0008588: Failed to delete the keywords
DescriptionFailed 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
Steps To Reproduce1. 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

Additional InformationV1.9.18 works good on keywords management. no issue occur.
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
BrowserChrome
PHP Version
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Filespng file icon Delete_Keyword_Failed.png [^] (46,078 bytes) 2019-03-07 04:14

- Relationships

-  Notes
(0028577)
fman (administrator)
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 (administrator)
2019-03-07 20:52

please apply fix and provide feedback
(0028645)
fman (administrator)
2019-04-02 20:39

no more user feedback

- Issue History
Date Modified Username Field Change
2019-03-07 04:14 Henry_Zhang New Issue
2019-03-07 04:14 Henry_Zhang File Added: Delete_Keyword_Failed.png
2019-03-07 20:50 fman Note Added: 0028577
2019-03-07 20:51 fman Note Edited: 0028577 View Revisions
2019-03-07 20:52 fman Note Added: 0028578
2019-03-07 20:52 fman Assigned To => fman
2019-03-07 20:52 fman Status new => feedback
2019-04-02 20:39 fman QA Team - Task Workflow Status => TBD
2019-04-02 20:39 fman Note Added: 0028645
2019-04-02 20:39 fman Status feedback => resolved
2019-04-02 20:39 fman Resolution open => fixed



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker