Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008714TestLinkInstallerpublic2019-07-04 12:272019-07-13 08:24
ReporterSmallSeedBox 
Assigned Tofman 
PrioritynormalSeveritycrashReproducibilityalways
StatusclosedResolutionfixed 
PlatformDebianOSDebianOS VersionDebian
Product Version1.9.19 (2019 Q1) 
Fixed in Version1.9.20 Raijing DEV 
Summary0008714: At table creation for testlink database, an sql error is returned (For 1.9.20)
DescriptionWeb 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


Steps To ReproduceEvery new installation and using the browser back option/resend data from previous step.
Additional InformationMay I advise using "CREATE TABLE IF NOT EXISTS " option?
TagsNo tags attached.
Database (MySQL,Postgres,etc)Mysql/MariaDB
BrowserFirefox/Chrome
PHP Version
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships

-  Notes
(0028987)
fman (administrator)
2019-07-04 15:14

going to check and fix removing duplicated code
(0029016)
fman (administrator)
2019-07-13 08:24

https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/cf6903d5e90c03ab6be033219a5905a764669d0b [^]

- Issue History
Date Modified Username Field Change
2019-07-04 12:27 SmallSeedBox New Issue
2019-07-04 15:14 fman Note Added: 0028987
2019-07-13 08:24 fman Note Added: 0029016
2019-07-13 08:24 fman QA Team - Task Workflow Status => TBD
2019-07-13 08:24 fman Status new => resolved
2019-07-13 08:24 fman Fixed in Version => 1.9.20 Raijing DEV
2019-07-13 08:24 fman Resolution open => fixed
2019-07-13 08:24 fman Assigned To => fman
2019-07-13 08:24 fman Status resolved => closed



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker