MantisBT - TestLink
View Issue Details
0008960TestLinkInstallerpublic2020-07-10 20:312020-07-10 20:31
enderlen 
 
highblockalways
newopen 
scalewayLinux5.5.53-0ubuntu0
1.9.20 
 
mysqlnd 5.0.12
Opera
7.3.16
0008960: Blocking error while installing "there can be only one TIMESTAMP column with CURRENT_TIMESTAMP"
Here 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]
No tags attached.
log testlinklog.log (1,589) 2020-07-10 20:31
http://mantis.testlink.org/file_download.php?file_id=5374&type=bug
Issue History
2020-07-10 20:31enderlenNew Issue
2020-07-10 20:31enderlenFile Added: testlinklog.log

There are no notes attached to this issue.