Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007672TestLinkDatabase MySQLpublic2016-09-15 07:032016-09-15 16:45
Reportermatrix007 
Assigned To 
PrioritynormalSeverityblockReproducibilityalways
StatusnewResolutionopen 
PlatformLinuxOSDebianOS Version8.1
Product Version1.9.15 (2015 Q4) 
Fixed in Version 
Summary0007672: upgrade to 1.9.15 failed with errror: DB Access Error
Descriptionupgrade testlink from 1.9.14 to 1.9.15, then visit the main page, an error message shows up like this after login:
 ==============================================================================

 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(/* debugMsg */ SELECT basename FROM plugins WHERE enabled=1 ) called at [/var/www/testlink/lib/functions/plugin_api.php:495]
#1 plugin_register_installed() called at [/var/www/testlink/lib/functions/plugin_api.php:514]
0000002 plugin_init_installed() called at [/var/www/testlink/lib/functions/common.php:481]
0000003 testlinkInitPage(database Object ([db] => ADODB_mysqli Object ([databaseType] => mysqli,[dataProvider] => native,[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=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] => ,[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 %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %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] => ,[_errorCode] => ,[_queryID] => 1,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 0,[overallDuration] => 0,[dbType] => mysqli,[] => 0,[] => 0), 1) called at [/var/www/testlink/lib/general/mainPage.php:28]
Steps To Reproduce1?a working testlin 1.9.14 installation
2?follow the upgrade section in README to upgrade to 1.9.15
3?visit the main page after upgradation and login

result:
DB Access Error

expected result:
show main working page.
TagsNo tags attached.
Database (MySQL,Postgres,etc)Mysql 5.5.43
Browserfirefox 48.0.2
PHP Version5.6.9-0+deb8u1
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships
related to 0007673new testlink_create_tables.sql failed to create tables when install testlink 1.9.15 
related to 0007671new db_schema_update.sql produce error messages: ERROR 1067 (42000) at line 22: Invalid default value for 'creation_ts' 

-  Notes
(0025416)
matrix007 (reporter)
2016-09-15 09:08

well it seems that the 1.9.15 require a mysql at least 5.6.x, unlike previous version, which only require 5.x.

and the "DEFAULT CURRENT_TIMESTAMP" is a feature of mysql 5.6
ALthough the install program says "Checking MySQL Database OK", it will fail when execute sql scripts with this feature.

but currently mysql 5.5.x is the only option in jessie stable pool.

either try to install a mysql 5.6 or wait for mysql 5.6 to be the candidate in jessie stable.

- Issue History
Date Modified Username Field Change
2016-09-15 07:03 matrix007 New Issue
2016-09-15 09:08 matrix007 Note Added: 0025416
2016-09-15 16:45 fman Relationship added related to 0007673
2016-09-15 16:45 fman Relationship added related to 0007671
2016-09-15 16:45 fman QA Team - Task Workflow Status => TBD
2016-09-15 16:45 fman Product Version => 1.9.15 (2015 Q4)



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker