Anonymous | Login | Signup for a new account | 2019-02-16 20:26 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 | ||||||||
0008406 | TestLink | Installer | public | 2018-10-09 15:42 | 2018-10-09 16:48 | ||||||||
Reporter | salas | ||||||||||||
Assigned To | fman | ||||||||||||
Priority | normal | Severity | major | Reproducibility | always | ||||||||
Status | feedback | Resolution | open | ||||||||||
Platform | Linux/Lighttpd/Postgres/PHP | OS | Linux Wheezy | OS Version | Debian 7.11 | ||||||||
Product Version | 1.9.18 (2018 Q3) | ||||||||||||
Fixed in Version | |||||||||||||
Summary | 0008406: Postgres DB script error | ||||||||||||
Description | 3 SQL lines for upgrading the DB shows "not null" errors. We should replace : ALTER TABLE tlkreq_coverage ADD COLUMN req_version_id INTEGER NOT NULL; ALTER TABLE tlkreq_coverage ADD COLUMN tcversion_id INTEGER NOT NULL; ... ALTER TABLE tlktestcase_keywords ADD COLUMN tcversion_id INTEGER NOT NULL; by ALTER TABLE tlkreq_coverage ADD COLUMN req_version_id INTEGER NOT NULL DEFAULT 0; ALTER TABLE tlkreq_coverage ADD COLUMN tcversion_id INTEGER NOT NULL DEFAULT 0; ... ALTER TABLE tlktestcase_keywords ADD COLUMN tcversion_id INTEGER NOT NULL DEFAULT 0; | ||||||||||||
Steps To Reproduce | Trying to launch the script in Testlink\install\sql\alter_tables\1.9.18\mysql\DB.1.9.17\step1\db_schema_update.sql | ||||||||||||
Tags | No tags attached. | ||||||||||||
Database (MySQL,Postgres,etc) | Postgres 9.1.24 | ||||||||||||
Browser | |||||||||||||
PHP Version | 5.3 | ||||||||||||
TestCaseID | |||||||||||||
QA Team - Task Workflow Status | |||||||||||||
Attached Files | |||||||||||||
![]() |
|
(0027974) fman (administrator) 2018-10-09 16:48 |
I will retest because on my postgres installation I've got no errors I'm using: "PostgreSQL 9.5.1 on x86_64-apple-darwin14.5.0, compiled by Apple LLVM version 7.0.0 (clang-700.1.76), 64-bit" |
![]() |
|||
Date Modified | Username | Field | Change |
2018-10-09 15:42 | salas | New Issue | |
2018-10-09 16:48 | fman | Note Added: 0027974 | |
2018-10-09 16:48 | fman | Assigned To | => fman |
2018-10-09 16:48 | fman | Status | new => feedback |
Copyright © 2000 - 2019 MantisBT Team |