MantisBT - TestLink
View Issue Details
0008714TestLinkInstallerpublic2019-07-04 12:272019-07-13 08:24
SmallSeedBox 
fman 
normalcrashalways
closedfixed 
DebianDebianDebian
1.9.19 (2019 Q1) 
1.9.20 Raijing DEV 
Mysql/MariaDB
Firefox/Chrome
TBD
0008714: At table creation for testlink database, an sql error is returned (For 1.9.20)
Web output :
-----
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.

 ==============================================================================

#0 database->exec_query(CREATE TABLE /*prefix*/testcase_platforms (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  testcase_id int(10) unsigned NOT NULL DEFAULT '0',
  tcversion_id int(10) unsigned NOT NULL DEFAULT '0',
  platform_id int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id),
  UNIQUE KEY idx01_testcase_platform (testcase_id,tcversion_id,platform_id),
  KEY idx02_testcase_platform (tcversion_id)
) DEFAULT CHARSET=utf8) called at [/mnt/Applications/www/gpontools.rdsnet.ro/public/testlink/install/sqlParser.class.php:98]
#1 SqlParser->process(sql/mysql/testlink_create_tables.sql) called at [/mnt/Applications/www/gpontools.rdsnet.ro/public/testlink/install/installNewDB.php:459]

-----
It seems the sql file is trying to create 'testcase_platforms' twice :
 cat testlink_create_tables.sql | grep -n testcase_platforms
443:CREATE TABLE /*prefix*/testcase_platforms (
793:CREATE TABLE /*prefix*/testcase_platforms (
899:NOT(EXISTS(SELECT 1 FROM /*prefix*/testcase_platforms TCPL

md5sum testlink_create_tables.sql
8037314ee34562267744930d56cac6e8 testlink_create_tables.sql


Every new installation and using the browser back option/resend data from previous step.
May I advise using "CREATE TABLE IF NOT EXISTS " option?
No tags attached.
Issue History
2019-07-04 12:27SmallSeedBoxNew Issue
2019-07-04 15:14fmanNote Added: 0028987
2019-07-13 08:24fmanNote Added: 0029016
2019-07-13 08:24fmanQA Team - Task Workflow Status => TBD
2019-07-13 08:24fmanStatusnew => resolved
2019-07-13 08:24fmanFixed in Version => 1.9.20 Raijing DEV
2019-07-13 08:24fmanResolutionopen => fixed
2019-07-13 08:24fmanAssigned To => fman
2019-07-13 08:24fmanStatusresolved => closed

Notes
(0028987)
fman   
2019-07-04 15:14   
going to check and fix removing duplicated code
(0029016)
fman   
2019-07-13 08:24   
https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/cf6903d5e90c03ab6be033219a5905a764669d0b [^]