View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
06170Bug reportsInstallationpublic2012-06-05 11:222012-06-07 11:02
Reporteruser20235Assigned ToTMSWhite  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary06170: Cannot install in PostgreSQL due to error in the install script
Description

There's a typo in admin/install/create-postgres.sql script that causes a syntax error.

Steps To Reproduce

Install LimeSurvey on a server, use "postgres" as the database type in config.php and run the /admin/install steps.

You should get the following error:

SQL command failed:
CREATE TABLE participant_attribute ( "participant_id" character varying(50) NOT NULL, "attribute_id" integer NOT NULL, "value" value character varying(50) NOT NULL, CONSTRAINT participant_attribut_pkey PRIMARY KEY (participant_id,attribute_id))
Reason: ERROR: syntax error at or near "character"
LINE 1: ... "attribute_id" integer NOT NULL, "value" value character ...

Additional Information

I have fixed this and made a pull request on Github here:
https://github.com/LimeSurvey/LimeSurvey/pull/8

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)120311
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 8.3
Server OS (if known)Debian
Webserver software & version (if known)Apache
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-06-07 11:02

administrator   ~19098

New 1.91+ build released.

Related Changesets

LimeSurvey: master 799f44fa

2012-06-05 02:02:15

user20235

Details Diff 		Fixed issue: Error in PostgreSQL DB create script. Affected Issues
06170
mod - admin/install/create-postgres.sql Diff File

Issue History

Date Modified Username Field Change
2012-06-05 11:22 user20235 New Issue
2012-06-05 21:14 TMSWhite Status new => resolved
2012-06-05 21:14 TMSWhite Fixed in Version => 1.92+
2012-06-05 21:14 TMSWhite Resolution open => fixed
2012-06-05 21:14 TMSWhite Assigned To => TMSWhite
2012-06-05 21:15 TMSWhite Changeset attached => LimeSurvey master 799f44fa
2012-06-07 11:02 c_schmitz Note Added: 19098
2012-06-07 11:02 c_schmitz Status resolved => closed