Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008406TestLinkInstallerpublic2018-10-09 15:422018-10-09 16:48
Reportersalas 
Assigned Tofman 
PrioritynormalSeveritymajorReproducibilityalways
StatusfeedbackResolutionopen 
PlatformLinux/Lighttpd/Postgres/PHPOSLinux WheezyOS VersionDebian 7.11
Product Version1.9.18 (2018 Q3) 
Fixed in Version 
Summary0008406: Postgres DB script error
Description3 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 ReproduceTrying to launch the script in Testlink\install\sql\alter_tables\1.9.18\mysql\DB.1.9.17\step1\db_schema_update.sql
TagsNo tags attached.
Database (MySQL,Postgres,etc)Postgres 9.1.24
Browser
PHP Version5.3
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
(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"

- Issue History
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 - 2018 MantisBT Team
Powered by Mantis Bugtracker