Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008960TestLinkInstallerpublic2020-07-10 20:312020-07-10 20:31
Reporterenderlen 
Assigned To 
PriorityhighSeverityblockReproducibilityalways
StatusnewResolutionopen 
PlatformscalewayOSLinuxOS Version5.5.53-0ubuntu0
Product Version1.9.20 
Fixed in Version 
Summary0008960: Blocking error while installing "there can be only one TIMESTAMP column with CURRENT_TIMESTAMP"
DescriptionHere are the logs when installing, it always fails while trying to create tables:

[>>][5f08cb93340c1454859038][DEFAULT][/install/installNewDB.php][20/Jul/10 20:12:03]
    [20/Jul/10 20:13:12][ERROR][<nosession>][DATABASE]
        ERROR ON exec_query() - database.class.php
1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause - CREATE TABLE /*prefix*/inventory (
  id int(10) unsigned NOT NULL auto_increment,
    `testproject_id` INT( 10 ) UNSIGNED NOT NULL ,
    `owner_id` INT(10) UNSIGNED NOT NULL ,
    `name` VARCHAR(255) NOT NULL ,
    `ipaddress` VARCHAR(255) NOT NULL ,
    `content` TEXT NULL ,
    `creation_ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modification_ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY /*prefix*/inventory_idx1 (`testproject_id`)
) DEFAULT CHARSET=utf8
THE MESSAGE : CREATE TABLE /*prefix*/inventory (
  id int(10) unsigned NOT NULL auto_increment,
    `testproject_id` INT( 10 ) UNSIGNED NOT NULL ,
    `owner_id` INT(10) UNSIGNED NOT NULL ,
    `name` VARCHAR(255) NOT NULL ,
    `ipaddress` VARCHAR(255) NOT NULL ,
    `content` TEXT NULL ,
    `creation_ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modification_ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY /*prefix*/inventory_idx1 (`testproject_id`)
) DEFAULT CHARSET=utf8
Query failed: errorcode[1293]
    errormsg:Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
[<<][5f08cb93340c1454859038][DEFAULT][/install/installNewDB.php][20/Jul/10 20:12:03][20/Jul/10 20:13:12][took 69.606053 secs]
TagsNo tags attached.
Database (MySQL,Postgres,etc)mysqlnd 5.0.12
BrowserOpera
PHP Version7.3.16
TestCaseID
QA Team - Task Workflow Status
Attached Fileslog file icon testlinklog.log [^] (1,589 bytes) 2020-07-10 20:31

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2020-07-10 20:31 enderlen New Issue
2020-07-10 20:31 enderlen File Added: testlinklog.log



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker