Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008614TestLinkTest Plan - Add/Remove Test Casespublic2019-04-02 14:362019-04-02 20:33
Reporterdmitryplotnikov 
Assigned Tofman 
PrioritynormalSeverityblockReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.9.19 (2019 Q1) 
Fixed in Version1.9.20 Raijing DEV 
Summary0008614: When I want to add a testcase, click the requirement - db access error is shown
Descriptionwhen I want to add a testcase and click the requirement - database error is always shown, it's a critical problem for my company.
Steps To Reproduceadd requirement, go to "add testcases" and select this requirement for testcase adding => db access error is shown.
Additional Information ==============================================================================

 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( SELECT NH_TC.id,NH_TC.name,NH_TC.parent_id, NH_TC.node_type_id,NH_TC.node_order FROM nodes_hierarchy AS NH_TC JOIN req_coverage RC ON RC.testcase_id = id WHERE RC.req_id = 4 AND node_type_id NOT IN (5,6,7) ORDER BY node_order,id) called at [/var/www/html/lib/functions/tree.class.php:948]
#1 tree->_get_subtree(4, Array (), Array ([exclude_node_types] => Array ([testplan] => exclude_me,[requirement_spec] => exclude_me,[requirement] => exclude_me),[exclude_children_of] => Array ([testcase] => exclude_my_children,[requirement_spec] => exclude_my_children),[exclude_branches] => ,[additionalWhereClause] => AND node_type_id NOT IN (5,6,7),[family] => ), Array ([recursive] => ,[order_cfg] => Array ([type] => req_order),[output] => full,[key_type] => std,[addJoin] => ,[addFields] => ,[exclude_testcases] => )) called at [/var/www/html/lib/functions/tree.class.php:859]
0000002 tree->get_subtree(4, Array ([exclude_node_types] => Array ([testplan] => exclude_me,[requirement_spec] => exclude_me,[requirement] => exclude_me),[exclude_children_of] => Array ([testcase] => exclude_my_children,[requirement_spec] => exclude_my_children),[exclude_branches] => ,[additionalWhereClause] => ), Array ([recursive] => ,[exclude_testcases] => ,[output] => full,[order_cfg] => Array ([type] => req_order))) called at [/var/www/html/lib/functions/testproject.class.php:764]
0000003 testproject->get_subtree(4, , Array ([order_cfg] => Array ([type] => req_order))) called at [/var/www/html/lib/functions/specview.php:698]
0000004 getTestSpecFromNode(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] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => 1,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[port] => 3306,[socket] => ,[_bindInputArray] => ,[nameQuote] => `,[optionFlags] => Array ([0] => Array ([0] => 5,[1] => 0)),[arrayClass] => ADORecordSet_array_mysqli,[multiQuery] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table if not exists %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table if exists %s,[database] => testlink,[host] => localhost,[user] => testlink,[password] => not stored,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[bulkBind] => ,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => mysqli Object ([affected_rows] => ,[client_info] => ,[client_version] => ,[connect_errno] => ,[connect_error] => ,[errno] => ,[error] => ,[error_list] => ,[field_count] => ,[host_info] => ,[info] => ,[insert_id] => ,[server_info] => ,[server_version] => ,[stat] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[_errorMsg] => Column 'id' in on clause is ambiguous,[_errorCode] => ,[_queryID] => 1,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[*connectionParameters] => Array (),[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 0,[overallDuration] => 0,[dbType] => mysqli,[databaselogEnabled] => 0,[databaselogQueries] => 0), testcase Object ([db] => 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] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => 1,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[port] => 3306,[socket] => ,[_bindInputArray] => ,[nameQuote] => `,[optionFlags] => Array ([0] => Array ([0] => 5,[1] => 0)),[arrayClass] => ADORecordSet_array_mysqli,[multiQuery] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table if not exists %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table if exists %s,[database] => testlink,[host] => localhost,[user] => testlink,[password] => not stored,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[bulkBind] => ,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => mysqli Object ([affected_rows] => ,[client_info] => ,[client_version] => ,[connect_errno] => ,[connect_error] => ,[errno] => ,[error] => ,[error_list] => ,[field_count] => ,[host_info] => ,[info] => ,[insert_id] => ,[server_info] => ,[server_version] => ,[stat] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[_errorMsg] => Column 'id' in on clause is ambiguous,[_errorCode] => ,[_queryID] => 1,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[*connectionParameters] => Array (),[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 0,[overallDuration] => 0,[dbType] => mysqli,[databaselogEnabled] => 0,[databaselogQueries] => 0),[tree_manager] => tree Object ([node_types] => Array ([1] => testproject,[2] => testsuite,[3] => testcase,[4] => tcversion,[5] => testplan,[6] => requirement_spec,[7] => requirement,[8] => req_version,[9] => testcase_step,[10] => req_revision,[11] => requirement_spec_revision,[12] => build),[class_name] => Array ([1] => testproject,[2] => testsuite,[3] => testcase,[4] => ,[5] => testplan,[6] => requirement_spec_mgr,[7] => requirement_mgr,[8] => ,[9] => ,[10] => ,[11] => ,[12] => ),[nodeWithoutClass] => Array ([11] => deleted when reqspec is deleted),[node_descr_id] => Array ([testproject] => 1,[testsuite] => 2,[testcase] => 3,[tcversion] => 4,[testplan] => 5,[requirement_spec] => 6,[requirement] => 7,[req_version] => 8,[testcase_step] => 9,[req_revision] => 10,[requirement_spec_revision] => 11,[build] => 12),[node_tables_by] => Array ([id] => Array ([1] => testprojects,[2] => testsuites,[5] => testplans,[3] => testcases,[4] => tcversions,[6] => req_specs,[7] => requirements,[8] => req_versions,[10] => req_versions,[11] => req_specs_revisions),[name] => Array ([testproject] => testprojects,[testsuite] => testsuites,[testplan] => testplans,[testcase] => testcases,[tcversion] => tcversions,[requirement_spec] => req_specs,[requirement] => requirements,[req_version] => req_versions,[req_revision] => req_versions,[requirement_spec_revision] => req_specs_revisions)),[node_tables] => Array ([testproject] => testprojects,[testsuite] => testsuites,[testplan] => testplans,[testcase] => testcases,[tcversion] => tcversions,[requirement_spec] => req_specs,[requirement] => requirements,[req_version] => req_versions,[req_revision] => req_versions,[requirement_spec_revision] => req_specs_revisions),[ROOT_NODE_TYPE_ID] => 1,[ROOT_NODE_PARENT_ID] => ,[db] => 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
TagsNo tags attached.
Database (MySQL,Postgres,etc)mysql - 5.7.25
BrowserFF
PHP Version7.2.15
TestCaseID
QA Team - Task Workflow StatusREADY FOR TESTING
Attached Files

- Relationships

-  Notes
(0028636)
dmitryplotnikov (reporter)
2019-04-02 14:42

OS - Ubuntu 18.04
(0028637)
dmitryplotnikov (reporter)
2019-04-02 16:30

Info from testlink log:

        [19/Apr/2 16:16:30][WARNING][4fdn51d2la8m9v1ir92u43ort0][GUI - ID : 1]
                E_NOTICE
Undefined index: setting_platform - in /var/www/html/lib/functions/specview.php - Line 488
        [19/Apr/2 16:16:30][WARNING][4fdn51d2la8m9v1ir92u43ort0][GUI - ID : 1]
                E_WARNING
count(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/plan/planAddTC.php - Line 259
        [19/Apr/2 16:16:30][WARNING][4fdn51d2la8m9v1ir92u43ort0][GUI - ID : 1]
                E_NOTICE
Undefined index: filter_testcase_name - in /var/www/html/lib/plan/planAddTC.php - Line 266
        [19/Apr/2 16:16:30][ERROR][4fdn51d2la8m9v1ir92u43ort0][DATABASE]
                ERROR ON exec_query() - database.class.php
1052 - Column 'id' in on clause is ambiguous - SELECT NH_TC.id,NH_TC.name,NH_TC.parent_id, NH_TC.node_type_id,NH_TC.node_order FROM nod$
Query failed: errorcode[1052]
        errormsg:Column 'id' in on clause is ambiguous
[<<][5ca38adeb0617741902854][DEFAULT][/lib/plan/planAddTC.php][19/Apr/2 16:16:30][19/Apr/2 16:16:30][took 0.114473 secs]
(0028638)
fman (administrator)
2019-04-02 18:51

1. issue steps to reproduce are not enough to reproduce the issue.
more detailed step by step procedure is neede

2. get latest stable code, do fresh install in sandbox, retest & provide feedback
(0028639)
fman (administrator)
2019-04-02 20:32

fix next stable release
https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/fa91d6acbf54145fb356c3933e3f0032e9f27316 [^]

- Issue History
Date Modified Username Field Change
2019-04-02 14:36 dmitryplotnikov New Issue
2019-04-02 14:42 dmitryplotnikov Note Added: 0028636
2019-04-02 16:30 dmitryplotnikov Note Added: 0028637
2019-04-02 18:49 fman QA Team - Task Workflow Status => TBD
2019-04-02 18:49 fman Additional Information Updated View Revisions
2019-04-02 18:49 fman Priority immediate => normal
2019-04-02 18:51 fman Note Added: 0028638
2019-04-02 20:32 fman Note Added: 0028639
2019-04-02 20:33 fman QA Team - Task Workflow Status TBD => READY FOR TESTING
2019-04-02 20:33 fman Status new => resolved
2019-04-02 20:33 fman Fixed in Version => 1.9.20 Raijing DEV
2019-04-02 20:33 fman Resolution open => fixed
2019-04-02 20:33 fman Assigned To => fman



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker