LimeSurvey issue tracker
Registration

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
06750Bug reports[All Projects] Survey takingpublic2012-10-22 16:122012-10-23 17:21
Reporterriqcles 
Assigned Toc_schmitz 
PrioritynormalSeveritycrash 
StatusclosedResolutionunable to reproduce 
Product Version2.00+ 
Target VersionFixed in Version 
Summary06750: PostgreSQL 9.1 - Problems with installing the limesuvey 2.00
DescriptionHi,
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.

Attachments:
- Video-capture wink (see link : http://dl.free.fr/rm.pl?h=m0Nj7bdgM&i=51716581&s=LcC6Givotjw9LZDrUpsgG2o3qUnXTp1f [^] )
- 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
I will donate to the project if issue is resolved within 48 hrsNo
LimeSurvey build number OR git commit ID121017
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
Attached Filespng file icon apres_modif_nom_shema.png [^] (51,373 bytes) 2012-10-22 16:12


png file icon modif_proprietaire_et_fichier_config.png [^] (176,070 bytes) 2012-10-22 16:12
zip file icon sql.zip [^] (35,251 bytes) 2012-10-22 16:12

- Relationships

-  Notes
User avatar (21565)
DenisChenu (developer)
2012-10-23 17:08

Hello,

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/
User avatar (21567)
c_schmitz (administrator)
2012-10-23 17:21

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: sql.zip
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


Copyright © 2000 - 2014 MantisBT Team
Powered by Mantis Bugtracker