Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008605TestLinkMigration/Upgrade Testlinkpublic2019-03-18 18:492019-03-18 19:24
Reporterpepamdf2 
Assigned Tofman 
PriorityhighSeveritycrashReproducibilityalways
StatusresolvedResolutionwon't fix 
PlatformPCOSWindowsOS VersionWinServer2008
Product Version1.9.19 (2019 Q1) 
Fixed in Version 
Summary0008605: Migration 1.9.15 to 1.9.19 ERROR while accessing Test Project Management
DescriptionERROR while accessing Test Project Management
Steps To ReproduceERROR:
============================================================================== 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:testproject - Method: get_accessible_for_user */
 
 SELECT TPROJ.*,NHTPROJ.name,COALESCE(UTR.role_id,U.role_id) AS effective_role ,ITMD.name AS itname,ITMD.type AS ittype ,CTMD.name AS ctname,CTMD.type AS cttype ,RMSMD.name AS rmsname,RMSMD.type AS rmstype FROM nodes_hierarchy NHTPROJ JOIN testprojects TPROJ ON NHTPROJ.id=TPROJ.id JOIN users U ON U.id = 8 LEFT OUTER JOIN user_testproject_roles UTR ON TPROJ.id = UTR.testproject_id AND UTR.user_id =8 LEFT OUTER JOIN testproject_issuetracker AS TIT ON TIT.testproject_id = TPROJ.id LEFT OUTER JOIN issuetrackers AS ITMD ON ITMD.id = TIT.issuetracker_id LEFT OUTER JOIN testproject_codetracker AS TCT ON TCT.testproject_id = TPROJ.id LEFT OUTER JOIN codetrackers AS CTMD ON CTMD.id = TCT.codetracker_id LEFT OUTER JOIN testproject_reqmgrsystem AS TRMS ON TRMS.testproject_id = TPROJ.id LEFT OUTER JOIN reqmgrsystems AS RMSMD ON RMSMD.id = TRMS.reqmgrsystem_id WHERE 1=1 ORDER BY name , -1, -1

 called at [C:\xampp\htdocs\testlink\lib\functions\database.class.php:759]
#1 database->get_recordset( /* Class:testproject - Method: get_accessible_for_user */ SELECT TPROJ.*,NHTPROJ.name,COALESCE(UTR.role_id,U.role_id) AS effective_role ,ITMD.name AS itname,ITMD.type AS ittype ,CTMD.name AS ctname,CTMD.type AS cttype ,RMSMD.name AS rmsname,RMSMD.type AS rmstype FROM nodes_hierarchy NHTPROJ JOIN testprojects TPROJ ON NHTPROJ.id=TPROJ.id JOIN users U ON U.id = 8 LEFT OUTER JOIN user_testproject_roles UTR ON TPROJ.id = UTR.testproject_id AND UTR.user_id =8 LEFT OUTER JOIN testproject_issuetracker AS TIT ON TIT.testproject_id = TPROJ.id LEFT OUTER JOIN issuetrackers AS ITMD ON ITMD.id = TIT.issuetracker_id LEFT OUTER JOIN testproject_codetracker AS TCT ON TCT.testproject_id = TPROJ.id LEFT OUTER JOIN codetrackers AS CTMD ON CTMD.id = TCT.codetracker_id LEFT OUTER JOIN testproject_reqmgrsystem AS TRMS ON TRMS.testproject_id = TPROJ.id LEFT OUTER JOIN reqmgrsystems AS RMSMD ON RMSMD.id = TRMS.reqmgrsystem_id WHERE 1=1 ORDER BY name ) called at [C:\xampp\htdocs\testlink\lib\functions\testproject.class.php:679]
0000002 testproject->get_accessible_for_user(8, Array ([output] => array_of_map,[order_by] => ORDER BY name ,[add_issuetracker] => 1,[add_codetracker] => 1,[add_reqmgrsystem] => 1), ) called at [C:\xampp\htdocs\testlink\lib\project\projectView.php:136]
0000003 initializeGui(database Object ([db] => ADODB_mysqli Object ([databaseType] => mysqli,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SELECT
            TABLE_NAME,
            CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
        FROM INFORMATION_SCHEMA.TABLES
        WHERE TABLE_SCHEMA=,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] =>
Additional InformationHere is the error when executing Query directly in MySQL

Erro
Query SQL:

SELECT TPROJ.*,NHTPROJ.name,COALESCE(UTR.role_id,U.role_id) AS effective_role ,ITMD.name AS itname,ITMD.type AS ittype ,CTMD.name AS ctname,CTMD.type AS cttype ,RMSMD.name AS rmsname,RMSMD.type AS rmstype FROM nodes_hierarchy NHTPROJ JOIN testprojects TPROJ ON NHTPROJ.id=TPROJ.id JOIN users U ON U.id = 8 LEFT OUTER JOIN user_testproject_roles UTR ON TPROJ.id = UTR.testproject_id AND UTR.user_id =8 LEFT OUTER JOIN testproject_issuetracker AS TIT ON TIT.testproject_id = TPROJ.id LEFT OUTER JOIN issuetrackers AS ITMD ON ITMD.id = TIT.issuetracker_id LEFT OUTER JOIN testproject_codetracker AS TCT ON TCT.testproject_id = TPROJ.id LEFT OUTER JOIN codetrackers AS CTMD ON CTMD.id = TCT.codetracker_id LEFT OUTER JOIN testproject_reqmgrsystem AS TRMS ON TRMS.testproject_id = TPROJ.id LEFT OUTER JOIN reqmgrsystems AS RMSMD ON RMSMD.id = TRMS.reqmgrsystem_id WHERE 1=1 ORDER BY name , -1, -1 LIMIT 0, 25

Mensagem do MySQL:
0001932 - Table 'testlink.testproject_codetracker' doesn't exist in engine
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
BrowserGoogle ChromeVersão 73.0.3683.75 (Versão oficial) 64 bits
PHP Version5.6.24
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships

-  Notes
(0028619)
fman (administrator)
2019-03-18 19:24

it will be impossible to cope with lot of issues related this kind of migration
please check operations AT EACH Migration

- Issue History
Date Modified Username Field Change
2019-03-18 18:49 pepamdf2 New Issue
2019-03-18 19:24 fman Note Added: 0028619
2019-03-18 19:24 fman QA Team - Task Workflow Status => TBD
2019-03-18 19:24 fman Status new => resolved
2019-03-18 19:24 fman Resolution open => won't fix
2019-03-18 19:24 fman Assigned To => fman



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker