Anonymous | Login | Signup for a new account | 2019-12-12 13:49 UTC | ![]() |
Main | My View | View Issues | Change Log | My Account |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
0008627 | TestLink | Keywords | public | 2019-04-09 09:46 | 2019-04-18 14:04 | ||||
Reporter | mshishodia | ||||||||
Assigned To | fman | ||||||||
Priority | high | Severity | major | Reproducibility | always | ||||
Status | closed | Resolution | unable to reproduce | ||||||
Platform | OS | OS Version | |||||||
Product Version | 1.9.19 (2019 Q1) | ||||||||
Fixed in Version | |||||||||
Summary | 0008627: AFTER UPGRADE TP 1.9.19 - DB access error while filter test cases with keywords. | ||||||||
Description | When user try to filter test case with keyword and hit apply button . DB access error display. | ||||||||
Steps To Reproduce | Login in testlink. go to Test Specification now expand filter . now selelect filter from keyword field. now hit apply button. DB access error display " ============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== #0 database->exec_query( /* Filter Type = OR */ SELECT TK.testcase_id FROM testcase_keywords TK JOIN latest_tcase_version_id LTVC ON LTVC.tcversion_id = TK.tcversion_id JOIN keywords KW ON KW.id = TK.keyword_id WHERE keyword_id IN (72) AND KW.testproject_id=387334, -1) called at [C:\Apache24\htdocs\testlink\lib\functions\database.class.php:637] #1 database->fetchRowsIntoMap( /* Filter Type = OR */ SELECT TK.testcase_id FROM testcase_keywords TK JOIN latest_tcase_version_id LTVC ON LTVC.tcversion_id = TK.tcversion_id JOIN keywords KW ON KW.id = TK.keyword_id WHERE keyword_id IN (72) AND KW.testproject_id=387334, testcase_id) called at [C:\Apache24\htdocs\testlink\lib\functions\testproject.class.php:3469] 0000002 testproject->getTCLatestVersionFilteredByKeywords(387334, Array ([0] => 72), Or) called at [C:\Apache24\htdocs\testlink\lib\functions\treeMenu.inc.php:2488] | ||||||||
Tags | No tags attached. | ||||||||
Database (MySQL,Postgres,etc) | MYSQL 5.7 | ||||||||
Browser | FF | ||||||||
PHP Version | 7.2.17 | ||||||||
TestCaseID | |||||||||
QA Team - Task Workflow Status | TBD | ||||||||
Attached Files | ![]() | ||||||||
![]() |
|
(0028689) fman (administrator) 2019-04-09 18:18 edited on: 2019-04-09 18:19 |
details to reproduce are not enough. complete scenario is needed starting from test project creation give a look to http://mantis.testlink.org/view.php?id=7042 [^] to understand the details needed |
(0028691) mshishodia (reporter) 2019-04-10 09:02 |
1. I Upgrade testlink-1.9.19 . 2. login in Testlink . 3. Go to Test Specification 4. Now filter test case with existing Keywords . 5. Hit apply button. |
(0028692) fman (administrator) 2019-04-10 09:16 |
The IMPORTANT fact is I Upgrade testlink-1.9.19, then issue can be in how you have executed the upgrading process. Only way to have a chance to provide help => a copy of your db in the initial state is needed. |
(0028699) mshishodia (reporter) 2019-04-11 07:03 |
Config DB file copied to new testlink, still DB access error display |
(0028703) fman (administrator) 2019-04-11 21:01 |
without having a copy of YOUR database BEFORE migration I can not provide help and will be forced to close the issue |
(0028729) gnustavo (reporter) 2019-04-16 17:56 |
Hi. I had a similar issue after upgrading to version 1.9.19. I'm going to open another issue, but I guess it's the same root cause. By the error message you got, the SQL was generated at https://github.com/TestLinkOpenSourceTRMS/testlink-code/blob/1.9.19/lib/functions/testproject.class.php#L3456. [^] The variable $kwFilter, expanded on line 3463, is defined in line 3412 like this: " keyword_id IN (" . implode(',',$keySet) . ")" I guess the problem is that the field "keyword_id" is ambiguous in the SQL. In line 3462, for example, it's prefixed with "TK". I think it probably should be prefixed also in line 3412. But since the variable $kwFilter is expanded in more than one SQL expressions you have to unify the prefix in all of them. |
(0028730) fman (administrator) 2019-04-16 18:04 |
1. it's important to try the guessings using a sql client, this way we can be sure issue is the missing alias. 2. it's important that everyone do tests on 1.9.19.01 branch that can be downloads from github, because this branch has been used to provide only fixes. 3. It's also important to search in this mantis for similar issues. regards |
(0028737) fman (administrator) 2019-04-18 14:04 |
no more user feedback |
![]() |
|||
Date Modified | Username | Field | Change |
2019-04-09 09:46 | mshishodia | New Issue | |
2019-04-09 18:17 | fman | QA Team - Task Workflow Status | => TBD |
2019-04-09 18:17 | fman | Steps to Reproduce Updated | View Revisions |
2019-04-09 18:18 | fman | Note Added: 0028689 | |
2019-04-09 18:19 | fman | Note Edited: 0028689 | View Revisions |
2019-04-10 09:02 | mshishodia | Note Added: 0028691 | |
2019-04-10 09:03 | mshishodia | File Added: Testlink_Keyword.jpg | |
2019-04-10 09:16 | fman | Note Added: 0028692 | |
2019-04-10 09:17 | fman | Summary | DB access error while filter test cases with keywords. => AFTER UPGRADE TP 1.9.19 - DB access error while filter test cases with keywords. |
2019-04-11 07:03 | mshishodia | Note Added: 0028699 | |
2019-04-11 21:01 | fman | Note Added: 0028703 | |
2019-04-16 17:56 | gnustavo | Note Added: 0028729 | |
2019-04-16 18:04 | fman | Note Added: 0028730 | |
2019-04-18 14:04 | fman | Note Added: 0028737 | |
2019-04-18 14:04 | fman | Status | new => closed |
2019-04-18 14:04 | fman | Assigned To | => fman |
2019-04-18 14:04 | fman | Resolution | open => unable to reproduce |
Copyright © 2000 - 2019 MantisBT Team |