Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008922TestLinkInstallerpublic2020-05-19 15:242020-05-20 07:29
Reportertexis 
Assigned Tofman 
PrioritynormalSeveritymajorReproducibilityN/A
StatusassignedResolutionopen 
PlatformLinuxOSUbuntuOS Version18.04
Product Version1.9.20 
Fixed in Version 
Summary0008922: Installer won't finish due to DB issues
DescriptionInstaller 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]
Steps To ReproduceAll 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).
Additional InformationTL 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]
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySql 7.2
BrowserFirefox
PHP Version7.2.24
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
(0029708)
fman (administrator)
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 (reporter)
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)?

- Issue History
Date Modified Username Field Change
2020-05-19 15:24 texis New Issue
2020-05-19 19:35 fman Note Added: 0029708
2020-05-19 19:35 fman Assigned To => fman
2020-05-19 19:35 fman Status new => feedback
2020-05-20 07:29 texis Note Added: 0029709
2020-05-20 07:29 texis Status feedback => assigned



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker