Mantis Bugtracker 

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008657TestLinkDatabase Postgrespublic2019-05-06 11:492019-05-08 11:24
Assigned To 
Platformx64OSWindows ServerOS Version2019
Product Version1.9.18 (2018 Q3) 
Fixed in Version 
Summary0008657: Update from 1.9.17 to 1.9.18: unable to add column 'tcversion_id' to (non-empty) table 'testcase_keywords'.
DescriptionWhen executing the following command in 'testlink\install\sql\alter_tables\1.9.18\postgres\DB.1.9.18':
    psql.exe --username="testlink" --file="step1\db_schema_update.sql",
the following error occurs:
    psql:db_schema_update.sql:26: ERROR: column "tcversion_id" contains null values

...understandably, as no default value is provided when adding column 'tcversion_id' of type INTEGER NOT NULL to 'testcase_keywords', which is not empty.

Subsequently, when trying to access a test case specification, a DB Access error happens because of the missing column.
Steps To Reproduce- Download '' from github
- Rename folder 'testlink' to 'testlink-1.9.17'
- Extract '' to folder 'testlink'
- Copy '' and '' from 'testlink-1.9.17' to new 'testlink' directory
- Run the following command in a DOS box at 'testlink\install\sql\alter_tables\1.9.18\postgres\DB.1.9.18':

    psql.exe --username="testlink" --file="step1\db_schema_update.sql"
TagsNo tags attached.
Database (MySQL,Postgres,etc)Postgres
PHP Version7.2.13
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
fman (administrator)
2019-05-07 14:20

Thanks, probably MySQL as usual does not complain
grecht (reporter)
2019-05-08 11:24

I just took a look at the corresponding MySQL script and it seems like there are a lot more changes made to the schema. Also, the 'tcversion_id' column in table 'testcase_keywords' is filled with values (line 68-70).

- Issue History
Date Modified Username Field Change
2019-05-06 11:49 grecht New Issue
2019-05-07 14:20 fman Note Added: 0028814
2019-05-08 11:24 grecht Note Added: 0028816

Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker