View Issue Details

IDProjectCategoryView StatusLast Update
06750Bug reports[All Projects] Survey takingpublic2012-10-23 17:21
ReporterriqclesAssigned Toc_schmitz 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Target VersionFixed in Version 
Summary06750: PostgreSQL 9.1 - Problems with installing the limesuvey 2.00
I encountered several problems during installation.
1. Language
During installation, select the language is French cause display bugs (after choosing the language from the beginning, select the [Back] button to see symptoms). This is visible in the video capture. (Mysql idem)

2. pg_dump and pg_restore
To dump no problem, cons after restore, care must be taken to restore the bytea parameter (for passwords) otherwise impossible to connect (see video).
If I change the schema name I have an error message (see attachments)

3. Changing the dump to compensate for a missing selection in the installation script.
I modified the dump to be able to choose:
- The postgres user (superuser) to create the database limesurvey_2_0
- Limesurvey_adm user (power user: CreateDB and CreateRole) to create the schema and populate the limesurvey base.

The scripts are properly conducted, but after not connect to the database:
The table "{{}} settings_global" for active record class "Settings_global" can not be found in the database.
This is the same mistake that changing the schema name.

4. Questions
Is it possible to choose the installation schema for postgres? (Provided in a new role?)
Is limesurvey combines schema name with a parameter in the database (I have not found anything in the config file)?

Should I make a Mantis?

5. nothing to do, but you never know.
To translate limesurvey the elements are present to translate the old version? -> If yes, I would take the missing elements to reach 100% (although there are words that I can not easily translate).

PS: The installation script is only a small part of the iceberg that I set up for my instances LimeSurvey.

- Video-capture wink (see link : )
- 0.sql 1.sql and-file creation and database users
- Dump in tar format
- Plain-dump format (equivalent 1.sql before modification)
- Image of the error to change schema name
Steps To ReproduceSee video
TagsNo tags attached.
Complete LimeSurvey version number (& build)121017
I will donate to the project if issue is resolvedNo
BrowserInternet explorer 8 8.0.6001.18702IC / Firefox 10.0.0
Database & DB-VersionPostgreSql 9.1
Operating System (Server)Windows XP SP3 / CentOS 5.x
Webserver software & versionWamp 2.2 / Apache 2.2.4
PHP Version5.1.13




2012-10-22 16:12


apres_modif_nom_shema.png (51,373 bytes)
apres_modif_nom_shema.png (51,373 bytes)


2012-10-22 16:12


modif_proprietaire_et_fichier_config.png (176,070 bytes)


2012-10-22 16:12

reporter (35,251 bytes)


2012-10-23 17:08

developer   ~21565


I just install a LS with pg db.
1: sorry, i don't look at instruction, don't get back. But this one is not the same bug than after.

2: My user have for the db:
CREATE to yes and CONNECT to yes. User need to create table for survey.

And i don't have problem . my limesurvey user don't have acces to schema.

3. Did you want a parameter more (for mysql it can be done too) give the postgre for database creation and user creation. And give a user/pass for cretaion. It's more a feature request than a bug report.

4. Don't think

5 : FR is already at 100% \o/


2012-10-23 17:21

administrator   ~21567

about 1.) I can't see the video, link shows 'Fichier perimé ou déjà supprimé'. Where is the installation messed up translation-wise?

about 2.) You are responsible for creating a backup and restoring with all parameters properly set.

I cannot reproduce the remaining issues and your screenshots are pretty non-saying to me. This is not a discussion board - if you have general question please use the forums. Please also only post one issue per bug report bug report.
Thank you.

Issue History

Date Modified Username Field Change
2012-10-22 16:12 riqcles New Issue
2012-10-22 16:12 riqcles File Added: apres_modif_nom_shema.png
2012-10-22 16:12 riqcles File Added: modif_proprietaire_et_fichier_config.png
2012-10-22 16:12 riqcles File Added:
2012-10-23 17:08 DenisChenu Note Added: 21565
2012-10-23 17:21 c_schmitz Note Added: 21567
2012-10-23 17:21 c_schmitz Status new => closed
2012-10-23 17:21 c_schmitz Assigned To => c_schmitz
2012-10-23 17:21 c_schmitz Resolution open => unable to reproduce