Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008892TestLinkDatabase Postgrespublic2020-03-30 14:242020-04-08 07:23
Reporteratisne 
Assigned To 
PriorityhighSeverityblockReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Version
Product Version1.9.20 
Fixed in Version 
Summary0008892: Install fails when using Postgresql
DescriptionThe installation of the branch testlink_1_9_20_fixed fails using Postgresql database, during
Processing:sql/postgres/testlink_create_tables.sql
Steps To ReproduceInstall the branch testlink_1_9_20_fixed using Postgresql database.
Additional Information2020-03-30 14:29:22.888 CEST [8799] testlink-upstream ERROR: syntax error at or near "unsigned" at character 357
2020-03-30 14:29:22.888 CEST [8799] testlink-upstream STATEMENT: CREATE TABLE tlbaseline_l1l2_details (
          "id" BIGSERIAL NOT NULL ,
          "context_id" BIGINT NOT NULL DEFAULT '0' REFERENCES tlbaseline_l1l2_context (id),
          "top_tsuite_id" BIGINT NOT NULL DEFAULT '0' REFERENCES tltestsuites (id),
          "child_tsuite_id" BIGINT NOT NULL DEFAULT '0' REFERENCES tltestsuites (id),
          "status" char(1) DEFAULT NULL,
          "qty" INT unsigned NOT NULL DEFAULT '0',
          "total_tc" INT unsigned NOT NULL DEFAULT '0',
          PRIMARY KEY ("id")
        )

The 'unsigned' keyword is not supported by Postgresql.
TagsNo tags attached.
Database (MySQL,Postgres,etc)Postgresql 10
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
(0029557)
atisne (reporter)
2020-03-30 14:30

Suggested fix https://github.com/TestLinkOpenSourceTRMS/testlink-code/pull/259 [^]
(0029558)
fman (administrator)
2020-03-31 17:35

thanks, sorry for the mistakes
(0029572)
atisne (reporter)
2020-04-08 07:23

When do you plan to add the fix on the branch?

- Issue History
Date Modified Username Field Change
2020-03-30 14:24 atisne New Issue
2020-03-30 14:30 atisne Note Added: 0029557
2020-03-31 17:35 fman Note Added: 0029558
2020-04-08 07:23 atisne Note Added: 0029572



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker