Anonymous | Login | Signup for a new account | 2019-12-15 15:41 UTC | ![]() |
Main | My View | View Issues | Change Log | My Account |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | 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 | 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 | |||||||||
![]() |
|
(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 [^] |
![]() |
|||
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 |