Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007671TestLinkDatabase MySQLpublic2016-09-15 06:492016-10-04 11:04
Reportermatrix007 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformLinuxOSDebianOS Version8.1
Product Version1.9.15 (2015 Q4) 
Fixed in Version 
Summary0007671: db_schema_update.sql produce error messages: ERROR 1067 (42000) at line 22: Invalid default value for 'creation_ts'
Descriptionwhen upgrade from 1.9.14 to 1.9.15, and execute ...../DB.1.9.15/step1/db_schema_update.sql?an error message shows up like this:

ERROR 1067 (42000) at line 22: Invalid default value for 'creation_ts'

I think the problem was caused by this line:

`creation_ts` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

Steps To Reproduce1?a working installation of testlink 1.9.14
2?follow the upgrade section in README to upgrade to 1.9.15
3?execute db_schema_update.sql to upgrade data structure.

result:
a error message shows up:
ERROR 1067 (42000) at line 22: Invalid default value for 'creation_ts'

expected result:
no error when updating the table.
Additional Informationmysql:Server version: 5.5.43-0+deb8u1 (Debian)
apache2:Version: 2.4.10-10
php:PHP 5.6.9-0+deb8u1 (cli) (built: Jun 5 2015 11:03:27)
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
(0025414)
matrix007 (reporter)
2016-09-15 09:07

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.
(0025482)
schoenrock (reporter)
2016-10-04 08:05

I changed datatype from "datetime" to "timestamp" as the other creation_ts fields in db and it worked on debian jessie
(0025483)
fman (administrator)
2016-10-04 11:04

@schoenrock: thanks for hint

- Issue History
Date Modified Username Field Change
2016-09-15 06:49 matrix007 New Issue
2016-09-15 09:07 matrix007 Note Added: 0025414
2016-09-15 16:45 fman Relationship added related to 0007672
2016-10-04 08:05 schoenrock Note Added: 0025482
2016-10-04 11:04 fman Note Added: 0025483



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker