Anonymous | Login | Signup for a new account | 2019-12-15 16:06 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 | ||||||||
0008500 | TestLink | Installer | public | 2018-12-10 17:54 | 2018-12-10 23:15 | ||||||||
Reporter | cyuste | ||||||||||||
Assigned To | fman | ||||||||||||
Priority | normal | Severity | minor | Reproducibility | always | ||||||||
Status | resolved | Resolution | fixed | ||||||||||
Platform | OS | OS Version | |||||||||||
Product Version | 1.9.18 (2018 Q3) | ||||||||||||
Fixed in Version | 1.9.19 (2019 Q1) | ||||||||||||
Summary | 0008500: Postgresql installation script fails | ||||||||||||
Description | I am trying to install the Testlink database using the web installer but it fails in the table creation(see additional information for the error log). I am using a AWS RDS Postgre DB v10.5, tried to run manually the sql script but also failed with this error: psql:testlink_create_tables.sql:986: ERROR: relation "testcase_keywords" does not exist LINE 6: AND NOT(EXISTS(SELECT 1 FROM /*prefix*/testcase_keywords T... | ||||||||||||
Additional Information | Processing:sql/postgres/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*/keywords( "id" BIGSERIAL NOT NULL , "keyword" VARCHAR(100) NOT NULL DEFAULT '', "testproject_id" BIGINT NOT NULL DEFAULT '0' REFERENCES /*prefix*/testprojects (id) ON DELETE CASCADE, "notes" TEXT NULL DEFAULT NULL, PRIMARY KEY ("id"), )) called at [/var/www/testlink/install/sqlParser.class.php:98] #1 SqlParser->process(sql/postgres/testlink_create_tables.sql) called at [/var/www/testlink/install/installNewDB.php:459] | ||||||||||||
Tags | No tags attached. | ||||||||||||
Database (MySQL,Postgres,etc) | Postgres v10.5 | ||||||||||||
Browser | |||||||||||||
PHP Version | v7.2.13 | ||||||||||||
TestCaseID | |||||||||||||
QA Team - Task Workflow Status | TBD | ||||||||||||
Attached Files | |||||||||||||
![]() |
||||||
|
![]() |
|
(0028310) fman (administrator) 2018-12-10 18:24 |
please get latest code from github, do fresh install & provide feedback |
(0028311) cyuste (reporter) 2018-12-10 20:21 |
Tested again, same result git show commit 4920b7b8b7f94328646cc281cfa190367d1d7461 (HEAD -> testlink_1_9, origin/testlink_1_9, origin/HEAD) Author: fmancardi <francisco.mancardi@gmail.com> Date: Mon Dec 10 19:17:02 2018 +0100 Tested now using Docker, I can change to a specific version of PostgreSQL if you think it's convenient but I have also tested in AWS RDS v9.6 and got the same result |
(0028312) fman (administrator) 2018-12-10 23:13 |
"id" BIGSERIAL NOT NULL , "keyword" VARCHAR(100) NOT NULL DEFAULT '', "testproject_id" BIGINT NOT NULL DEFAULT '0' REFERENCES /*prefix*/testprojects (id) ON DELETE CASCADE, "notes" TEXT NULL DEFAULT NULL, PRIMARY KEY ("id"), this has to be changed to PRIMARY KEY ("id") |
(0028313) fman (administrator) 2018-12-10 23:14 |
https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/2604cd1650e2316d83c3936fc8ca318d6ee67d9d [^] |
![]() |
|||
Date Modified | Username | Field | Change |
2018-12-10 17:54 | cyuste | New Issue | |
2018-12-10 18:24 | fman | Note Added: 0028310 | |
2018-12-10 18:24 | fman | Assigned To | => fman |
2018-12-10 18:24 | fman | Status | new => feedback |
2018-12-10 20:21 | cyuste | Note Added: 0028311 | |
2018-12-10 20:21 | cyuste | Status | feedback => assigned |
2018-12-10 23:13 | fman | Note Added: 0028312 | |
2018-12-10 23:14 | fman | QA Team - Task Workflow Status | => TBD |
2018-12-10 23:14 | fman | Note Added: 0028313 | |
2018-12-10 23:14 | fman | Status | assigned => resolved |
2018-12-10 23:14 | fman | Fixed in Version | => 1.9.19 (2019 Q1) |
2018-12-10 23:14 | fman | Resolution | open => fixed |
2018-12-10 23:15 | fman | Relationship added | child of 0008397 |
2018-12-10 23:15 | fman | Product Version | => 1.9.18 (2018 Q3) |
Copyright © 2000 - 2019 MantisBT Team |