View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
08339Bug reportsOtherpublic2013-11-06 09:402013-11-25 15:39
Reporterwehr Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.05 RC 
Target Version2.05+Fixed in Version2.05+ 
Summary08339: Some schema fixes for PostgreSQL based installations
Description

diff --git a/installer/sql/create-pgsql.sql b/installer/sql/create-pgsql.sql
index 0c488e3..cef7a51 100644
--- a/installer/sql/create-pgsql.sql
+++ b/installer/sql/create-pgsql.sql
@@ -216,7 +216,7 @@ CREATE TABLE prefix_participants (
CREATE TABLE prefix_permissions (
id serial NOT NULL,
entity character varying(50) NOT NULL,

  • entity_id character varying(100) NOT NULL,

  • entity_id integer DEFAULT 0 NOT NULL,
    uid integer NOT NULL,
    permission character varying(100) NOT NULL,
    create_p integer DEFAULT 0 NOT NULL,
    @@ -233,17 +233,17 @@ CREATE TABLE prefix_permissions (
    -- Table structure for table plugins

    CREATE TABLE prefix_plugins (

  • id integer PRIMARY KEY NOT NULL,
  • id serial PRIMARY KEY NOT NULL,
    name character varying(50) NOT NULL,
    active integer NOT NULL default '0'
    );
TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)18c535165da195f9f6c4db3aa8a8
I will donate to the project if issue is resolvedNo
BrowserFirefox 25
Database type & versionPostgreSQL 9.1.9
Server OS (if known)Debian 7.1
Webserver software & version (if known)Apache 2.2
PHP Version5.4.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-11-08 10:55

administrator   ~27155

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

c_schmitz

2013-11-08 10:55

administrator   ~27156

entity_id is supposed to be varchar.
wehr

wehr

2013-11-08 11:45

reporter   ~27157

Hi,

Just want to note that on latest PostgreSQL versions (it think > 8.3) you will get a
"Error: operator does not exist: character varying = integer"
for
entity_id character varying(100) NOT NULL

For example it happens if you enter the plugin manager for the first time where the default plugins get added.
c_schmitz

c_schmitz

2013-11-20 13:23

administrator   ~27247

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

c_schmitz

2013-11-20 13:23

administrator   ~27248

Thank you!
c_schmitz

c_schmitz

2013-11-25 15:39

administrator   ~27384

2.05RC7 released.

Related Changesets

LimeSurvey: 2.05 099428d7

2013-11-08 10:55

c_schmitz


Details Diff		 Fixed issue 08339: Schema fix for PostgreSQL based installations Affected Issues
08339
mod - installer/sql/create-pgsql.sql Diff File

LimeSurvey: 2.05 8b6a5910

2013-11-20 13:23

c_schmitz


Details Diff		 Fixed issue 08339: Some schema fixes for PostgreSQL based installations Affected Issues
08339
mod - application/config/version.php Diff File
mod - application/helpers/update/updatedb_helper.php Diff File
mod - installer/sql/create-mssql.sql Diff File
mod - installer/sql/create-mysql.sql Diff File
mod - installer/sql/create-pgsql.sql Diff File

Issue History

Date Modified Username Field Change
2013-11-06 09:40 wehr New Issue
2013-11-07 11:50 c_schmitz Assigned To => c_schmitz
2013-11-07 11:50 c_schmitz Status new => assigned
2013-11-08 10:55 c_schmitz Changeset attached => LimeSurvey 2.05 099428d7
2013-11-08 10:55 c_schmitz Note Added: 27155
2013-11-08 10:55 c_schmitz Resolution open => fixed
2013-11-08 10:55 c_schmitz Note Added: 27156
2013-11-08 10:55 c_schmitz Status assigned => resolved
2013-11-08 10:55 c_schmitz Fixed in Version => 2.05+
2013-11-08 11:45 wehr Note Added: 27157
2013-11-08 11:45 wehr Status resolved => feedback
2013-11-08 11:45 wehr Resolution fixed => reopened
2013-11-20 13:23 c_schmitz Changeset attached => LimeSurvey 2.05 8b6a5910
2013-11-20 13:23 c_schmitz Note Added: 27247
2013-11-20 13:23 c_schmitz Note Added: 27248
2013-11-20 13:23 c_schmitz Status feedback => resolved
2013-11-20 13:23 c_schmitz Resolution reopened => fixed
2013-11-22 11:28 c_schmitz Target Version => 2.05+
2013-11-25 15:39 c_schmitz Note Added: 27384
2013-11-25 15:39 c_schmitz Status resolved => closed