Keywords: TestLink - Windows - Technical issue - Other
Using Windows10, installed RedminePlusAgile stack (remineplusagile-4.1.0-8-windows-x64-installer.exe) and successfully logged in to see it was working.
Tried installing Testlink Windows Module (bitnami-testlink-1.9.20-1-module-windows-x64-installer.exe) but received error popup message:
Problem running post-install step. Installation may not complete correctly
ERROR 1067 (42000) at line 801 in file: 'C:\apps\testlink\htdocs\install\sql\mysql\TESTLI~1.SQL': Invalid default value for 'end_exec_ts'
After the first failed installation, I completely uninstalled Testlink Module, restarted computer then repeated the installation with the same result.
Searching on the error message, I located the following page that desribes the same (or similar?) error with 'end_exec_ts' and how they fixed it but I'm not sure how to apply the fix in the context of the Bitnami Testlink Module installer.
Search in the page for ID "8876" or "end_exec_ts"
Additional Information: * install/sql/mysql/testlink_create_tables.sql :
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 (testplan_id,platform_id,creation_ts)
) DEFAULT CHARSET=utf8;
==> I changed "end_exec_ts timestamp NOT NULL," to "end_exec_ts timestamp NOT NULL DEFAULT '2038-01-01 00:00:01'," and the issue was fixed.
==> My primary guess here is, default value for end_exec_ts field is either zero-date or invalid format since MySql 5.7~ does not allow zero-date for timestamp field.
==> I found github commits that might be related to this issue: https://github.com/TestLinkOpenSourceTRMS/testlink-code/pull/253/commits/9f25ed4429f14dc4f5d22caa261abeb9711d68e3 [^]
After the second failed installation, I did not close the error popup window, which allowed me to find the SQL statement in the "testlink_create_tables.sql" file within the /install/sql/mysql path contained in the error message. Now I'm not sure how to proceed.
Please advise. Thanks in advance.