Mantis Bugtracker 

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008173TestLinkDatabase MySQLpublic2018-01-02 23:492018-01-03 21:58
Assigned To 
PlatformLinuxOSRHEL OS Version6.7
Product Version1.9.16 (2016 Q4) 
Fixed in Version 
Summary0008173: Invalid default value for 'modification_ts'
DescriptionMYSQL 5.7.20
PHP 5.6.32


Does anyone know how to resolve the following error when trying to create the tables?

mysql -uroot -p testlink < /opt/testlink/install/sql/mysql/testlink_create_tables.sql
Enter password:
ERROR 1067 (42000) at line 239: Invalid default value for 'modification_ts'
Steps To ReproduceCan be reproduced by:

1. Dropping any current testlink DB's
2. Recreating a clean testlink DB with all the correct user permissions etc.
3. Re-running the mysql command to create the tables for the testlink DB from the testlink install/sql/mysql/testlink_create_tables.sql file

Produces the error for me every time.
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
PHP Version5.6.32
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
BRCM (reporter)
2018-01-03 21:58

Please close the Issue.

- Issue History
Date Modified Username Field Change
2018-01-02 23:49 BRCM New Issue
2018-01-03 20:11 BRCM Note Added: 0027134
2018-01-03 21:55 BRCM Note Deleted: 0027134
2018-01-03 21:58 BRCM Note Added: 0027135

Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker