Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008733TestLinkInstallerpublic2019-08-02 13:292019-10-17 06:12
Reporterevans 
Assigned Tofman 
PriorityimmediateSeverityblockReproducibilityalways
StatusresolvedResolutionfixed 
Platformx64OSWindows 10OS Version
Product Version1.9.19 (2019 Q1) 
Fixed in Version1.9.19.01 (1.9.19 fixes) 
Summary0008733: Database error on installation.
DescriptionWhen you click "Process TestLink Setup" an error occurs and installation is not continued.

The MySql data is correct as I installed Mantis with the same database data and everything went well.
Steps To ReproduceStart the installation process.
Enter MySql login and password data
Click on Process TestLink Setup
Additional InformationTestLink setup will now attempt to setup the database:

Creating connection to Database Server:OK!

Connecting to database `testlink`:OK!

 ==============================================================================
 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(GRANT SELECT, UPDATE, DELETE, INSERT ON `testlink`.* TO 'root'@'localhost' IDENTIFIED BY 'root') called at [C:\inetpub\wwwroot\testlink-1.9.19\install\installUtils.php:501]
#1 _mysql_make_user(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] => mysql,[host] => localhost,[user] => root,[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] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'root'' at line 1,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[*connectionParameters] => Array (),[databaseName] => mysql),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 0,[overallDuration] => 0,[dbType] => mysqli,[databaselogEnabled] => 0,[databaselogQueries] => 0), localhost, testlink, root, root) called at [C:\inetpub\wwwroot\testlink-1.9.19\install\installUtils.php:544]
0000002 _mysql_assign_grants(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] => mysql,[host] => localhost,[user] => root,[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] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'root'' at line 1,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[*connectionParameters] => Array (),[databaseName] => mysql),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 0,[overallDuration] => 0,[dbType] => mysqli,[databaselogEnabled] => 0,[databaselogQueries] => 0), localhost, testlink, root, root) called at [C:\inetpub\wwwroot\testlink-1.9.19\install\installUtils.php:310]
0000003 create_user_for_db(mysql, testlink, localhost, root, root, root, root) called at [C:\inetpub\wwwroot\testlink-1.9.19\install\installNewDB.php:408]
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL - 8.0.17 Community Server - GPL
BrowserChrome - 75.0.3770.142 - 64 bits
PHP Version7.3.7
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Filespng file icon testlink.png [^] (50,025 bytes) 2019-08-02 13:29


pdf file icon TestLink setup will now attempt to setup the database.pdf [^] (590,220 bytes) 2019-08-02 13:31

- Relationships

-  Notes
(0029065)
fman (administrator)
2019-08-02 14:19

please search for similar issues, can be related to mysql version
(0029068)
evans (reporter)
2019-08-05 13:32

I downloaded the version with fix and it worked, without making any changes to Mysql.

Can you close the bug, please.

Thanks for all the help, ever.
(0029069)
fman (administrator)
2019-08-05 15:03

good!
(0029102)
rlobos (reporter)
2019-08-14 20:03

I got the same error using PHP 7.2.21 and MySQL 5.5.60, I have downloaded the Testlink 1.9.19 from SourceForge and the problem is the same. How Can I solve it? How can I get the 1.9.19-1 or later?
(0029103)
evans (reporter)
2019-08-14 20:07

@rlobos All new versions are on the mantis tickets homepage:

http://mantis.testlink.org/view.php?id=8549 [^]

The specific version with the mentioned patch (1.9.19-1) is at this link:

https://github.com/TestLinkOpenSourceTRMS/testlink-code/archive/tl1.9.19.01.zip [^]
(0029106)
fman (administrator)
2019-08-15 18:04

@evans: thanks for providing indications
(0029252)
lukekratochvil (reporter)
2019-10-14 12:22

I have the same error. I've downloaded latest version from the link above but nothing changed. Additional info: Apache/2.4.41 (Win64); PHP/7.2.23; MySQL 8.0.17.
(0029258)
lukekratochvil (reporter)
2019-10-17 06:12

So I solved this problem by downgrading MySQL server version from 8.0 to 5.7.

- Issue History
Date Modified Username Field Change
2019-08-02 13:29 evans New Issue
2019-08-02 13:29 evans File Added: testlink.png
2019-08-02 13:31 evans File Added: TestLink setup will now attempt to setup the database.pdf
2019-08-02 14:19 fman Note Added: 0029065
2019-08-02 14:21 fman Assigned To => fman
2019-08-02 14:21 fman Status new => feedback
2019-08-05 13:32 evans Note Added: 0029068
2019-08-05 13:32 evans Status feedback => assigned
2019-08-05 15:03 fman Note Added: 0029069
2019-08-05 15:03 fman QA Team - Task Workflow Status => TBD
2019-08-05 15:03 fman Status assigned => resolved
2019-08-05 15:03 fman Fixed in Version => 1.9.19.01 (1.9.19 fixes)
2019-08-05 15:03 fman Resolution open => fixed
2019-08-14 20:03 rlobos Note Added: 0029102
2019-08-14 20:07 evans Note Added: 0029103
2019-08-15 18:04 fman Note Added: 0029106
2019-10-14 12:22 lukekratochvil Note Added: 0029252
2019-10-17 06:12 lukekratochvil Note Added: 0029258



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker