Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008956TestLinkTest Executepublic2020-07-03 15:162020-07-30 06:31
Reporterarnadan 
Assigned Tofman 
PriorityurgentSeveritycrashReproducibilityalways
StatusresolvedResolutionno change required 
PlatformOSOS Version
Product Version1.9.20 
Fixed in Version 
Summary0008956: DB Access Error when clicking on "Execute Tests"
DescriptionAfter upgrading from 1.9.19 to 1.9.20
I can login to my TestLink installation
but when I click on "Execute Tests"
I get a DB access error.
Steps To Reproduce1. Login to TestLink
2. Click on "Execute Tests"
Additional InformationERROR MESSAGE 1


==============================================================================
 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:tlPlatform - Method: getLinkedToTestplanAsMap */ SELECT P.id, P.name FROM platforms P JOIN testplan_platforms TP ON P.id = TP.platform_id WHERE TP.testplan_id = 29
               AND enable_on_execution = 1 ORDER BY name , -1) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/functions/database.class.php:722]
#1 database->fetchColumnsIntoMap(/* Class:tlPlatform - Method: getLinkedToTestplanAsMap */ SELECT P.id, P.name FROM platforms P JOIN testplan_platforms TP ON P.id = TP.platform_id WHERE TP.testplan_id = 29
               AND enable_on_execution = 1 ORDER BY name , id, name) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/functions/tlPlatform.class.php:458]
0000002 tlPlatform->getLinkedToTestplanAsMap(29) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/functions/tlTestCaseFilterControl.class.php:1295]
0000003 tlTestCaseFilterControl->init_setting_platform() called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/functions/tlTestCaseFilterControl.class.php:546]
0000004 tlTestCaseFilterControl->init_settings() called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/functions/tlFilterControl.class.php:246]
0000005 tlFilterControl->__construct(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] => tl,[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] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[_errorMsg] => Unknown column 'enable_on_execution' in 'where clause',[_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)) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/functions/tlTestCaseFilterControl.class.php:328]
0000006 tlTestCaseFilterControl->__construct(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] => tl,[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] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[_errorMsg] => Unknown column 'enable_on_execution' in 'where clause',[_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), execution_mode) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/execute/execNavigator.php:29]


ERROR MESSAGE 2

==============================================================================
 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:tlPlatform - Method: getLinkedToTestplan */
            SELECT P.id, P.name, P.notes,
                   P.enable_on_design,
                   P.enable_on_execution
            FROM platforms P
            JOIN testplan_platforms TP
            ON P.id = TP.platform_id
            WHERE TP.testplan_id = 29
                    ORDER BY name , -1, -1) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/functions/database.class.php:763]
#1 database->get_recordset(/* Class:tlPlatform - Method: getLinkedToTestplan */
            SELECT P.id, P.name, P.notes,
                   P.enable_on_design,
                   P.enable_on_execution
            FROM platforms P
            JOIN testplan_platforms TP
            ON P.id = TP.platform_id
            WHERE TP.testplan_id = 29
                    ORDER BY name ) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/functions/tlPlatform.class.php:405]
0000002 tlPlatform->getLinkedToTestplan(29, Array ([outputFormat] => array)) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/functions/testplan.class.php:3412]
0000003 testplan->getPlatforms(29) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/execute/execDashboard.php:83]
0000004 init_args(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] => tl,[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] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[_errorMsg] => Unknown column 'P.enable_on_design' in 'field list',[_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), ) called at [/home/httpd/vhosts/dartecs.com/testlink.dartecs.com/testlink-1.9.20/lib/execute/execDashboard.php:24]

TagsNo tags attached.
Database (MySQL,Postgres,etc)MySql
BrowserChrome
PHP Version7.4
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships

-  Notes
(0029812)
fman (administrator)
2020-07-03 17:27

Dear user
1. please try the queries on a SQL client to get more information
2. upgrade your code to github branch testlink_1_9_20_fixed
(0029858)
arnadan (reporter)
2020-07-30 06:03

Problem solved. Something went wrong with my DB update. So as suggested I run the SQL manuelly and thus found the missing columns. Added them and the error disabbeared. Issue solved. Thanks for your support.
(0029859)
fman (administrator)
2020-07-30 06:31

great!

- Issue History
Date Modified Username Field Change
2020-07-03 15:16 arnadan New Issue
2020-07-03 17:27 fman Note Added: 0029812
2020-07-03 17:27 fman Assigned To => fman
2020-07-03 17:27 fman Status new => feedback
2020-07-30 06:03 arnadan Note Added: 0029858
2020-07-30 06:03 arnadan Status feedback => assigned
2020-07-30 06:31 fman Note Added: 0029859
2020-07-30 06:31 fman QA Team - Task Workflow Status => TBD
2020-07-30 06:31 fman Status assigned => resolved
2020-07-30 06:31 fman Resolution open => no change required



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker