Dependency Graph
View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
05710 | Bug reports | Installation | public | 2012-01-27 22:47 | 2012-02-14 14:10 |
Reporter | jhubbs | Assigned To | c_schmitz | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.92RC3 | ||||
Fixed in Version | 1.92RC4 | ||||
Summary | 05710: Installation of limesurvey fails for postgresql database. | ||||
Description | Env: Fedora 16; PHP 5.3.9; PostgreSQL 9.1.2 There are errors in the database setup files for postgresql. create-postgresql.sql lime_expression_errors: lime_groups: lime_users: Below is the error output . . . . . . . . . . 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... ^ . . . . . . . . . . | ||||
Steps To Reproduce | attempt to run install script | ||||
Tags | No 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 ); | ||||
Bug heat | 12 | ||||
Complete LimeSurvey version number (& build) | 12204 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chrome | ||||
Database type & version | Postgresql 9.1.2 | ||||
Server OS (if known) | Fedora 16 | ||||
Webserver software & version (if known) | Apache 2.2.21 | ||||
PHP Version | 5.3.9 | ||||
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 |