View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 12
IDProjectCategoryView StatusDate SubmittedLast Update
05710Bug reportsInstallationpublic2012-01-27 22:472012-02-14 14:10
Reporterjhubbs Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.92RC3 
Fixed in Version1.92RC4 
Summary05710: Installation of limesurvey fails for postgresql database.
Description

Env: Fedora 16; PHP 5.3.9; PostgreSQL 9.1.2
limesurvey192RC3-build12204-20120125

There are errors in the database setup files for postgresql.

create-postgresql.sql

lime_expression_errors:
id integer NOT NULL AUTO_INCREMENT
should probably be
id SERIAL

lime_groups:
randomization_group varying(20) DEFAULT
should probably be
randomization_group character varying(20) DEFAULT

lime_users:
participant_panel integer NOT NULL DEFAULT '0
should not be in there.

Below is the error output

. . . . . . . . . .
SQL command failed: CREATE TABLE lime_expression_errors ( id integer NOT NULL AUTO_INCREMENT, errortime varchar(50) DEFAULT NULL, sid integer DEFAULT NULL, gid integer DEFAULT NULL, qid integer DEFAULT NULL, gseq integer DEFAULT NULL, qseq integer DEFAULT NULL, "type" character varying(50) , eqn text, prettyprint text, CONSTRAINT lime_expression_errors_pkey PRIMARY KEY (id)) Reason: ERROR: syntax error at or near "AUTO_INCREMENT" LINE 1: ...BLE lime_expression_errors ( id integer NOT NULL AUTO_INCRE... ^

SQL command failed: CREATE TABLE lime_groups ( gid serial, sid integer DEFAULT 0 NOT NULL, group_name character varying(100) DEFAULT ''::character varying NOT NULL, group_order integer DEFAULT 0 NOT NULL, description text, "language" character varying(20) DEFAULT 'en'::character varying NOT NULL, randomization_group varying(20) DEFAULT ''::character varying NOT NULL, grelevance text DEFAULT NULL, CONSTRAINT lime_groups_pkey PRIMARY KEY (gid, "language")) Reason: ERROR: type "varying" does not exist LINE 1: ...haracter varying NOT NULL, randomization_group varying(20... ^
. . . . . . . . . . . . . . . . . . . .
SQL command failed: CREATE TABLE lime_users ( uid serial PRIMARY KEY NOT NULL, users_name character varying(64) DEFAULT ''::character varying UNIQUE NOT NULL, "password" bytea NOT NULL, full_name character varying(50) NOT NULL, parent_id integer NOT NULL, lang character varying(20), email character varying(320) NOT NULL, create_survey integer DEFAULT 0 NOT NULL, create_user integer DEFAULT 0 NOT NULL, participant_panel integer DEFAULT 0 NOT NULL, delete_user integer DEFAULT 0 NOT NULL, superadmin integer DEFAULT 0 NOT NULL, configurator integer DEFAULT 0 NOT NULL, manage_template integer DEFAULT 0 NOT NULL, manage_label integer DEFAULT 0 NOT NULL, htmleditormode character(7) DEFAULT 'default'::bpchar, templateeditormode character(7) DEFAULT 'default'::bpchar, questionselectormode character(7) DEFAULT 'default'::bpchar, one_time_pw bytea, "dateformat" integer DEFAULT 1 NOT NULL, participant_panel integer NOT NULL DEFAULT '0') Reason: ERROR: column "participant_panel" specified more than once
. . . . . . . . . . . . .
SQL command failed: create index groups_idx2 on lime_groups (sid) Reason: ERROR: relation "lime_groups" does not exist

. . . . . . . . . .
SQL command failed: INSERT INTO lime_users( users_name, "password", full_name, parent_id, lang, email, create_survey, create_user, delete_user, superadmin, configurator, manage_template, manage_label,htmleditormode) VALUES ('admin', '20d7aa53cde449eab19b510b5c276e5923b622dbc381d20944153785d09b9973', 'Your Name', 0, 'en', ' your-email@example.net',1,1,1,1,1,1,1,'default') Reason: ERROR: relation "lime_users" does not exist LINE 1: INSERT INTO lime_users( users_name, "password", f... ^
Error

Steps To Reproduce

attempt to run install script

TagsNo tags attached.
Attached Files
db-change.patch (1,370 bytes)    
diff -rupN limesurvey-orig/admin/install/create-postgres.sql limesurvey/admin/install/create-postgres.sql
--- limesurvey-orig/admin/install/create-postgres.sql	2012-01-10 15:28:22.000000000 -0500
+++ limesurvey/admin/install/create-postgres.sql	2012-01-27 16:33:53.499296593 -0500
@@ -71,7 +71,7 @@ CREATE TABLE prefix_defaultvalues (
 --
 
 CREATE TABLE prefix_expression_errors (
-  id integer NOT NULL AUTO_INCREMENT,
+  id SERIAL,
   errortime varchar(50) DEFAULT NULL,
   sid integer DEFAULT NULL,
   gid integer DEFAULT NULL,
@@ -95,7 +95,7 @@ CREATE TABLE prefix_groups (
     group_order integer DEFAULT 0 NOT NULL,
     description text,
     "language" character varying(20) DEFAULT 'en'::character varying NOT NULL,
-    randomization_group varying(20) DEFAULT ''::character varying NOT NULL,
+    randomization_group character varying(20) DEFAULT ''::character varying NOT NULL,
     grelevance text DEFAULT NULL,
     CONSTRAINT prefix_groups_pkey PRIMARY KEY (gid, "language")
 );
@@ -419,8 +419,7 @@ CREATE TABLE prefix_users (
     templateeditormode character(7) DEFAULT 'default'::bpchar,
     questionselectormode character(7) DEFAULT 'default'::bpchar,
 	one_time_pw bytea,
-    "dateformat" integer DEFAULT 1 NOT NULL,
-    participant_panel integer NOT NULL DEFAULT '0'
+    "dateformat" integer DEFAULT 1 NOT NULL
 );
db-change.patch (1,370 bytes)   
Bug heat12
Complete LimeSurvey version number (& build)12204
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionPostgresql 9.1.2
Server OS (if known)Fedora 16
Webserver software & version (if known)Apache 2.2.21
PHP Version5.3.9

Relationships

Relationship GraphDependency Graph
has duplicate 05721 closedc_schmitz Login with admin and deafault password doesn't work 

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-02-14 14:10

administrator   ~17441

1.92RC4 released

Issue History

Date Modified Username Field Change
2012-01-27 22:47 jhubbs New Issue
2012-01-27 23:12 c_schmitz Assigned To => c_schmitz
2012-01-27 23:12 c_schmitz Status new => assigned
2012-01-29 20:44 jhubbs File Added: db-change.patch
2012-01-30 18:39 c_schmitz Status assigned => resolved
2012-01-30 18:39 c_schmitz Fixed in Version => 1.92RC4
2012-01-30 18:39 c_schmitz Resolution open => fixed
2012-01-30 18:39 c_schmitz Relationship added has duplicate 05721
2012-02-14 14:10 c_schmitz Note Added: 17441
2012-02-14 14:10 c_schmitz Status resolved => closed