Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008595TestLinkReq Overviewpublic2019-03-12 18:302019-03-12 22:38
Reporterhguilherme66 
Assigned Tofman 
PriorityhighSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.9.19 (2019 Q1) 
Fixed in Version 
Summary0008595: SQL error when accessing Requirements Overview
DescriptionA DB Access Error appeared when I accessed Requirements Overview in a project having Requirements Specifications defined.
Steps To ReproduceClicked Requirements Overview in a project having Requirements Specifications (and also executed Tests with coverage), and the following error appears:
 ==============================================================================
 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(/* Class:requirement_mgr - Method: getLatestReqVersionCoverageCounterSet */ SELECT RCOV.req_id, COUNT(0) AS qty FROM req_coverage RCOV JOIN latest_req_version_id LRQV ON LRQV.req_version_id = RCOV.req_version_id WHERE LRQV.req_version_id IN (5747,5749) AND is_active = 1 GROUP BY RCOV.req_id , -1) called at [(removed)/testlink/lib/functions/database.class.php:637]
#1 database->fetchRowsIntoMap(/* Class:requirement_mgr - Method: getLatestReqVersionCoverageCounterSet */ SELECT RCOV.req_id, COUNT(0) AS qty FROM req_coverage RCOV JOIN latest_req_version_id LRQV ON LRQV.req_version_id = RCOV.req_version_id WHERE LRQV.req_version_id IN (5747,5749) AND is_active = 1 GROUP BY RCOV.req_id , req_id) called at [(removed)/testlink/lib/functions/requirement_mgr.class.php:4775]
0000002 requirement_mgr->getLatestReqVersionCoverageCounterSet(Array ([0] => 5747,[1] => 5749)) called at [/var/www/qa/public_html/testlink/lib/requirements/reqOverview.php:77]
Additional InformationThis was a first time installation of TL.

During Installation there was no report of failure to create the Views (or I did not notice any).

There was no Views created in DB.
I successful created the missing Views by running that part of the SQL script.

The problem became solved.
TagsNo tags attached.
Database (MySQL,Postgres,etc)MariaDB 10.3.12
BrowserChrome
PHP Version5.5.38
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships

-  Notes
(0028587)
hguilherme66 (reporter)
2019-03-12 18:34

This is related with 0008480
(0028589)
fman (administrator)
2019-03-12 22:36

Just tested using branch 1.9.19.01 on OSX, using MAMP Pro, no issues
(0028590)
fman (administrator)
2019-03-12 22:36
edited on: 2019-03-12 22:38

unable to reproduce on 1.9.19.01, when NO TABLE PREFIX is used


- Issue History
Date Modified Username Field Change
2019-03-12 18:30 hguilherme66 New Issue
2019-03-12 18:34 hguilherme66 Note Added: 0028587
2019-03-12 22:36 fman Note Added: 0028589
2019-03-12 22:36 fman QA Team - Task Workflow Status => TBD
2019-03-12 22:36 fman Note Added: 0028590
2019-03-12 22:36 fman Status new => resolved
2019-03-12 22:36 fman Resolution open => fixed
2019-03-12 22:36 fman Assigned To => fman
2019-03-12 22:38 fman Note Edited: 0028590 View Revisions



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker