View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
06359Bug reportsInstallationpublic2012-07-22 04:10
Reporterfsando Assigned Tojcleeland  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00RC7 
Summary06359: Installations with postgres as database fails because of syntax error in create-pgsql.sql
Description

A missing comma in /installer/sql/create-pgsql.sql - line 342

Installation fails at the the "populate database" step which doesn't complete.

Steps To Reproduce

During install select postgresql, try to complete installation.

Additional Information

Current code:

CREATE TABLE prefix_survey_links (
"participant_id" character varying ( 50 ) NOT NULL,
"token_id" integer NOT NULL,
"survey_id" integer NOT NULL,
"date_created" timestamp,
"date_invited" timestamp,
"date_completed" timestamp
CONSTRAINT prefix_survey_links_pkey PRIMARY KEY (participant_id,token_id,survey_id)
);

should be (note the added comma after the last field definition)

CREATE TABLE prefix_survey_links (
"participant_id" character varying ( 50 ) NOT NULL,
"token_id" integer NOT NULL,
"survey_id" integer NOT NULL,
"date_created" timestamp,
"date_invited" timestamp,
"date_completed" timestamp,
CONSTRAINT prefix_survey_links_pkey PRIMARY KEY (participant_id,token_id,survey_id)
);

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)120721
I will donate to the project if issue is resolvedNo
Browserfirefox 13/14
Database type & versionpostgresql 9.1
Server OS (if known)Ubuntu 12.04
Webserver software & version (if known)Apache 2.2.22 (Ubuntu)
PHP Versionphp 5.3.10-1ubuntu3.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

jcleeland

jcleeland

2012-07-22 04:10

reporter   ~19904

Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9080

jcleeland

jcleeland

2012-07-22 04:10

reporter   ~19905

Fixed 20120722

Related Changesets

LimeSurvey: Yii fbc70dc9

2012-07-21 19:11:07

jcleeland

Details Diff
Fixed issue 06359 - installations with postgres as database fail because of syntax error Affected Issues
06359
mod - installer/sql/create-pgsql.sql Diff File

Issue History

Date Modified Username Field Change
2012-07-21 16:08 fsando New Issue
2012-07-21 17:52 c_schmitz Assigned To => jcleeland
2012-07-21 17:52 c_schmitz Status new => assigned
2012-07-22 04:10 jcleeland Changeset attached => LimeSurvey Yii fbc70dc9
2012-07-22 04:10 jcleeland Note Added: 19904
2012-07-22 04:10 jcleeland Resolution open => fixed
2012-07-22 04:10 jcleeland Note Added: 19905
2012-07-22 04:10 jcleeland Status assigned => closed