Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007819TestLinkInstallerpublic2017-01-24 15:512017-03-20 20:45
Reporternoe 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOSubuntuOS Version16.10
Product Version1.9.16 (2016 Q4) 
Fixed in Version 
Summary0007819: POSTGRESQL - error while upgrading from 1.9.14 to 1.9.16
Descriptionafter having passed successfully the two sql scripts for the upgrade from 1.9.14 to 1.9.15
we have an error on this script DB.1.9.16/step1/db_schema_update.sql
The error is :
psql:testlink-1.9.16/install/sql/alter_tables/1.9.16/postgres/DB.1.9.16/step1/db_schema_update.sql:7: ERREUR: erreur de syntaxe sur ou près de « DATA »
LIGNE 1 : ...prefix*/execution_bugs ADD COLUMN "tcstep_id" SET DATA TYPE ...
                                                               ^
psql:testlink-1.9.16/install/sql/alter_tables/1.9.16/postgres/DB.1.9.16/step1/db_schema_update.sql:8: ERREUR: la contrainte « execution_bugs_pkey » de la relation « execution_bugs » n'existe pas
psql:testlink-1.9.16/install/sql/alter_tables/1.9.16/postgres/DB.1.9.16/step1/db_schema_update.sql:10: ERREUR: identifiant entre guillemets non terminé sur ou près de « "tcstep_id);
); »
LIGNE 1 : ...ion_bugs ADD PRIMARY KEY ("execution_id","bug_id","tcstep_id...
Steps To Reproduceinstall testlink 1.9.14
upgrade to 1.9.16
apply the sql scripts 1.9.14 to 1.9.15 and then 1.9.15 to 1.9.16
Additional Informationthe script DB.1.9.16/step1/db_schema_update.sql has errors :

- alter table add column : need to remove "set data type"
- there is no constraint named execution_bugs_pkey
- ALTER TABLE /*prefix*/execution_bugs ADD PRIMARY KEY ("execution_id","bug_id","tcstep_id); : the last quote is missing
- ); : remove this at the end of the file

But after these corrections and applying stepZ/z_final_step.sql we have an error on the login page :
1.9.16 (Moka pot)
You need to proceed with Manual upgrade of your DB scheme to DB 1.9.16 - Read README file!
TagsNo tags attached.
Database (MySQL,Postgres,etc)postgres
Browserfirefox
PHP Version5.6
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships
has duplicate 0007893new Upgrade TL 1.9.15 to TL 1.9.16 fails on PostgreSQL - syntax failures in db_schema_update.sql 

-  Notes
(0025918)
noe (reporter)
2017-01-24 17:11

Sorry, my mistake, after having corrected DB.1.9.16/step1/db_schema_update.sql, I can log in Testlink succesfully.
(0025933)
noe (reporter)
2017-01-27 13:37

I think this correction is the good one :

In testlink-1.9.16/install/sql/alter_tables/1.9.16/postgres/DB.1.9.16/step1/db_schema_update.sql

ALTER TABLE /*prefix*/execution_bugs ADD COLUMN "tcstep_id" SET DATA TYPE BIGINT NOT NULL DEFAULT '0';
ALTER TABLE /*prefix*/execution_bugs DROP CONSTRAINT /*prefix*/execution_bugs_pkey;
ALTER TABLE /*prefix*/execution_bugs ADD PRIMARY KEY ("execution_id","bug_id","tcstep_id);
);


must be changed with

ALTER TABLE /*prefix*/execution_bugs ADD COLUMN "tcstep_id" BIGINT NOT NULL DEFAULT '0';
ALTER TABLE /*prefix*/execution_bugs DROP CONSTRAINT /*prefix*/execution_bugs_pkey;
ALTER TABLE /*prefix*/execution_bugs ADD PRIMARY KEY ("execution_id","bug_id","tcstep_id");

- Issue History
Date Modified Username Field Change
2017-01-24 15:51 noe New Issue
2017-01-24 17:11 noe Note Added: 0025918
2017-01-24 20:30 fman QA Team - Task Workflow Status => TBD
2017-01-24 20:30 fman Summary error while upgrading from 1.9.14 to 1.9.16 => POSTGRESQL - error while upgrading from 1.9.14 to 1.9.16
2017-01-27 13:37 noe Note Added: 0025933
2017-03-20 20:45 fman Relationship added has duplicate 0007893



Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker