0008714: At table creation for testlink database, an sql error is returned (For 1.9.20)

testlink.org

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0008714

TestLink

Installer

public

2019-07-04 12:27

2019-07-13 08:24

Reporter

SmallSeedBox

Assigned To

fman

Priority

normal

Severity

crash

Reproducibility

always

Status

closed

Resolution

fixed

Platform

Debian

OS Version

Debian

Product Version

1.9.19 (2019 Q1)

Fixed in Version

1.9.20 Raijing DEV

Summary

0008714: At table creation for testlink database, an sql error is returned (For 1.9.20)

Description

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

Steps To Reproduce

Every new installation and using the browser back option/resend data from previous step.

Additional Information

May I advise using "CREATE TABLE IF NOT EXISTS " option?

Tags

No tags attached.

Database (MySQL,Postgres,etc)

Mysql/MariaDB

Browser

Firefox/Chrome

PHP Version

TestCaseID

QA Team - Task Workflow Status

TBD

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