Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008634TestLinkDatabase Postgrespublic2019-04-15 11:522019-04-21 09:02
Reporteratisne 
Assigned Tofman 
PrioritynormalSeverityblockReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSCentOS/RedHatOS Version7
Product Version1.9.19 (2019 Q1) 
Fixed in Version1.9.20 Raijing DEV 
Summary0008634: Syntax error on field type
DescriptionWhen installing the last version of Testlink (HEAD of branch Testlink_1_9) using a Postgresql database, the installer fails on step of creating DB.

PHP error:
#0 database->exec_query(CREATE TABLE tlexecution_tcsteps_wip (
   "id" BIGSERIAL NOT NULL ,
   "tcstep_id" INTEGER NOT NULL DEFAULT '0' REFERENCES tltcsteps (id),
   "testplan_id" int(10) INTEGER NOT NULL DEFAULT '0' REFERENCES tltestplans (id),
   "platform_id" int(10) INTEGER NOT NULL DEFAULT '0',
   "build_id" INTEGER NOT NULL DEFAULT '0',
   "tester_id" BIGINT NULL DEFAULT NULL,
   "creation_ts" TIMESTAMP NOT NULL DEFAULT now(),
   "notes" TEXT NULL DEFAULT NULL,
   "status" CHAR(1) NULL DEFAULT NULL,
  PRIMARY KEY ("id")
)) called at [/opt/testlink/install/sqlParser.class.php:98]
#1 SqlParser->process(sql/postgres/testlink_create_tables.sql) called at [/opt/testlink/install/installNewDB.php:459]

PG error:
syntax error at or near "(" at character 161

Steps To ReproduceInstall Testlink from github source (HEAD of branch testlink_1_9).
Run the installer.
Fill out the form about the database information and click on the button 'Process'.
Additional InformationI suspect a syntax error on integer type definition for some fields : 'int(10) INTEGER'.
TagsNo tags attached.
Database (MySQL,Postgres,etc)Postgresql 9.2
BrowserFirefox
PHP VersionPHP 7
TestCaseID
QA Team - Task Workflow StatusREADY FOR TESTING
Attached Files

- Relationships

-  Notes
(0028723)
atisne (reporter)
2019-04-15 11:57

Please consider the PR https://github.com/TestLinkOpenSourceTRMS/testlink-code/pull/192 [^]

- Issue History
Date Modified Username Field Change
2019-04-15 11:52 atisne New Issue
2019-04-15 11:57 atisne Note Added: 0028723
2019-04-21 09:02 fman QA Team - Task Workflow Status => READY FOR TESTING
2019-04-21 09:02 fman Status new => resolved
2019-04-21 09:02 fman Fixed in Version => 1.9.20 Raijing DEV
2019-04-21 09:02 fman Resolution open => fixed
2019-04-21 09:02 fman Assigned To => fman



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker