MantisBT - TestLink
View Issue Details
0008634TestLinkDatabase Postgrespublic2019-04-15 11:522019-04-21 09:02
atisne 
fman 
normalblockalways
resolvedfixed 
CentOS/RedHat7
1.9.19 (2019 Q1) 
1.9.20 Raijing DEV 
Postgresql 9.2
Firefox
PHP 7
READY FOR TESTING
0008634: Syntax error on field type
When 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

Install 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'.
I suspect a syntax error on integer type definition for some fields : 'int(10) INTEGER'.
No tags attached.
Issue History
2019-04-15 11:52atisneNew Issue
2019-04-15 11:57atisneNote Added: 0028723
2019-04-21 09:02fmanQA Team - Task Workflow Status => READY FOR TESTING
2019-04-21 09:02fmanStatusnew => resolved
2019-04-21 09:02fmanFixed in Version => 1.9.20 Raijing DEV
2019-04-21 09:02fmanResolutionopen => fixed
2019-04-21 09:02fmanAssigned To => fman

Notes
(0028723)
atisne   
2019-04-15 11:57   
Please consider the PR https://github.com/TestLinkOpenSourceTRMS/testlink-code/pull/192 [^]