求助:无法完成Testlink安装

Testlink 安装程序无法将默认站点安装到选定的数据库中,最后一个错误是在执行 SQL 语句INSERT INTO /prefix/db_version (version,notes,upgrade_ts) VALUES('DB 1.9.14', 'TestLink 1.9.14',CURRENT_TIMESTAMP())时报出的。

Processing:sql/mysql/testlink_create_tables.sql

============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ============================================================================== ============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ============================================================================== ============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ============================================================================== ============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ============================================================================== ============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ============================================================================== ============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ============================================================================== ============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ============================================================================== ============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ============================================================================== ============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ==============================================================================

============================================================================== DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) Having this additional Information could be useful for reporting issue to development TEAM. ============================================================================== ============================================================================== Failed! - Installation failed!

I resolved the issues using following steps.

  1. Navigate to the \testlink-code-testlink_1_9\install\sql\mysql folder and open file testlink_create_tables.sql
  2. Modify creation_ts datetime NOT NULL default 'CURRENT_TIMESTAMP' as creation_ts` datetime NOT NULL default '2016-11-30 11:26:36'.
  3. There should not be two column with default 'CURRENT_TIMESTAMP'. If available change the default value '2016-11-30 11:26:36' instead of 'CURRENT_TIMESTAMP'
  4. Provide proper database credential and proceed. Hope it will work!

One way to fix this is to install mysql 5.6 or newer. This happens in older versions of mysql such as 5.5 that don't support multiple default values for CURRENT_TIMESTAMP.

请问一下你这个问题后面解决了吗?为什么修改了CURRENT_TIMESTAMP的多个默认值怎么还是报错呢?