Problems with LimeSurvey and PostgreSQL

Mehr
11 Monate 4 Tage her #162250 von matarancon
matarancon erstellte das Thema Problems with LimeSurvey and PostgreSQL
Hello, I have an new instance of LimeSurvey 2.72.5 With PostgreSQL 9.3, but I have some problems.

In database System do all tables in public schema, but table of single survey create on own schema.

I attach my error in search (ErrorSearch.docx).
These is the log on database:


ERROR: relation "lime_users" does not exist at character 15
STATEMENT: SELECT *
FROM "lime_users"
...
ERROR: operator does not exist: integer ~~ unknown at character 243
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT COUNT(*) FROM "lime_questions" "t" LEFT OUTER JOIN "lime_groups" "groups" ON ("t"."gid"="groups"."gid") AND ("t"."language"="groups"."language") WHERE ((((t.sid='691552') AND (t.language='es')) AND (t.parent_qid='0')) AND (groups.gid LIKE '%1%'))
...
ERROR: relation "lime_tokens_142367" already exists
STATEMENT: CREATE TABLE "lime_tokens_142367" (
"tid" serial NOT NULL PRIMARY KEY,
"participant_id" character varying (50) ,
"firstname" character varying (150) ,
"lastname" character varying (150) ,
"email" text,
"emailstatus" text,
"token" character varying (35) ,
"language" character varying (25) ,
"blacklisted" character varying (17) ,
"sent" character varying (17) DEFAULT 'N',
"remindersent" character varying (17) DEFAULT 'N',
"remindercount" integer DEFAULT 0,
"completed" character varying (17) DEFAULT 'N',
"usesleft" integer DEFAULT 1,
"validfrom" timestamp,
"validuntil" timestamp,
"mpid" integer
)



Maybe is a Bug! Someone could help me please?
Anhang:

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
11 Monate 3 Tage her #162366 von matarancon
matarancon antwortete auf das Thema: Problems with LimeSurvey and PostgreSQL
SOLVED

On DB:

ALTER ROLE myuser IN DATABASE dbname SET search_path = owscheme;


replace our files 'public' with 'owscheme':

limesurvey/installer/sql/create-pgsql.sql: línea 4
limesurvey/application/helpers/database_helper.php: línea 181
limesurvey/framework/db/schema/pgsql/CPgsqlSchema.php: línea 20

It´s work fine now.
Folgende Benutzer bedankten sich: LouisGac

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
11 Monate 2 Tage her #162427 von ollehar
ollehar antwortete auf das Thema: Problems with LimeSurvey and PostgreSQL
Thank you for sharing your solution!
Folgende Benutzer bedankten sich: LouisGac

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha