MantisBT - TestLink
View Issue Details
0008922TestLinkInstallerpublic2020-05-19 15:242020-05-20 07:29
texis 
fman 
normalmajorN/A
assignedopen 
LinuxUbuntu18.04
1.9.20 
 
MySql 7.2
Firefox
7.2.24
0008922: Installer won't finish due to DB issues
Installer failed with following:
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() called at [/var/www/html/install/sqlParser.class.php:98]
#1 SqlParser->process() called at [/var/www/html/install/installNewDB.php:469]
All preparation shows success:
PHP version OK ( 5.5.0 [minimum version] <= 7.2.24-0ubuntu0.18.04.4 [your version] )
Your system is prepared for TestLink configuration (no fatal problem found).
TL log file contains:

[20/May/19 15:19:44][WARNING][<nosession>][GUI]
                E_WARNING
Creating default object from empty value - in /var/www/html/install/installUtils.php - Line 559
        [20/May/19 15:19:52][ERROR][<nosession>][DATABASE]
                ERROR ON exec_query() - database.class.php
1067 - Invalid default value for 'end_exec_ts' - CREATE TABLE /*prefix*/baseline_l1l2_context (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  testplan_id int(10) unsigned NOT NULL DEFAULT '0',
  platform_id int(10) unsigned NOT NULL DEFAULT '0',
  begin_exec_ts timestamp NOT NULL,
  end_exec_ts timestamp NOT NULL,
  creation_ts timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  UNIQUE KEY udx1_context (testplan_id,platform_id,creation_ts)
) DEFAULT CHARSET=utf8
THE MESSAGE : CREATE TABLE /*prefix*/baseline_l1l2_context (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  testplan_id int(10) unsigned NOT NULL DEFAULT '0',
  platform_id int(10) unsigned NOT NULL DEFAULT '0',
  begin_exec_ts timestamp NOT NULL,
  end_exec_ts timestamp NOT NULL,
  creation_ts timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  UNIQUE KEY udx1_context (testplan_id,platform_id,creation_ts)
) DEFAULT CHARSET=utf8
Query failed: errorcode[1067]
        errormsg:Invalid default value for 'end_exec_ts'
[<<][5ec3f910d5b28146825566][DEFAULT][/install/installNewDB.php][20/May/19 15:19:44][20/May/19 15:19:52][took 7.585269 secs]
No tags attached.
Issue History
2020-05-19 15:24texisNew Issue
2020-05-19 19:35fmanNote Added: 0029708
2020-05-19 19:35fmanAssigned To => fman
2020-05-19 19:35fmanStatusnew => feedback
2020-05-20 07:29texisNote Added: 0029709
2020-05-20 07:29texisStatusfeedback => assigned

Notes
(0029708)
fman   
2020-05-19 19:35   
problem is related to your MySQL /MariaDB DBMS configuration related to
  begin_exec_ts timestamp NOT NULL,
  end_exec_ts timestamp NOT NULL,

without defaults
(0029709)
texis   
2020-05-20 07:29   
Hi,
Not sure if I understood correctly but does it mean I need to someho re-configure my DB? I thought this is being done by the TL installation script(s)?