Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007673TestLinkDatabase MS-SQLpublic2016-09-15 07:202016-09-15 16:45
Reportermatrix007 
Assigned To 
PrioritynormalSeverityblockReproducibilityhave not tried
StatusnewResolutionopen 
PlatformLinuxOSDebianOS Version8.1
Product Version1.9.15 (2015 Q4) 
Fixed in Version 
Summary0007673: testlink_create_tables.sql failed to create tables when install testlink 1.9.15
Descriptionwhen install testlink 1.9.15, the testlink_create_tables.sql failed to create tables with error messages like these:

TestLink setup will now attempt to setup the database:

Creating connection to Database Server:OK!


Database testlink does not exist.
Will attempt to create:
Creating database `testlink`:OK!
Creating Testlink DB user `testlink`:OK! (ok - user_exists ok - grant assignment)
Processing:sql/mysql/testlink_create_tables.sql

 ==============================================================================

 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(CREATE TABLE /*prefix*/attachments (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fk_id` int(10) unsigned NOT NULL default '0',
  `fk_table` varchar(250) default '',
  `title` varchar(250) default '',
  `description` varchar(250) default '',
  `file_name` varchar(250) NOT NULL default '',
  `file_path` varchar(250) default '',
  `file_size` int(11) NOT NULL default '0',
  `file_type` varchar(250) NOT NULL default '',
  `date_added` datetime NOT NULL default CURRENT_TIMESTAMP,
  `content` longblob,
  `compression_type` int(11) NOT NULL default '0',
  PRIMARY KEY (`id`),
  KEY /*prefix*/attachments_idx1(fk_id)
) DEFAULT CHARSET=utf8) called at [/var/www/testlink/install/sqlParser.class.php:103]
#1 SqlParser->process(sql/mysql/testlink_create_tables.sql) called at [/var/www/testlink/install/installNewDB.php:427]

and there are only 2 tables created in the database

+--------------------+
| Tables_in_testlink |
+--------------------+
| assignment_status |
| assignment_types |
+--------------------+

Steps To Reproduce1?fresh install testlink 1.9.15
2?click the "Process testlink Setup!"

result:
testlink_create_tables.sql failed to create tables with errors.

expected result
testlink_create_tables.sql successfully create all required tables.
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 Status
Attached Files

- Relationships
related to 0007672new upgrade to 1.9.15 failed with errror: DB Access Error 

-  Notes
(0025415)
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:20 matrix007 New Issue
2016-09-15 09:08 matrix007 Note Added: 0025415
2016-09-15 16:45 fman Relationship added related to 0007672



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker