View Issue Details

This issue affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
07229Bug reportsSurvey editingpublic2013-02-12 10:58
Reporterestupendu Assigned Toc_schmitz  
PriorityurgentSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary07229: Survey table could not be created
Description

We have installed limesurvey in a postgresql-8.4 database. Apararently the installation was ok. We have designed a very simple survey (only one group and one question) to test it but when we try to activate it this message appears: "Survey table could not be created. Database error!!"

TagsNo tags attached.
Attached Files
Database Error.jpg (9,032 bytes)   
Database Error.jpg (9,032 bytes)   
Limesurvey_username.jpg (9,322 bytes)   
Limesurvey_username.jpg (9,322 bytes)   
Database_limesurvey.jpg (12,051 bytes)   
Database_limesurvey.jpg (12,051 bytes)   
Limesurvey_tables.jpg (6,343 bytes)   
Limesurvey_tables.jpg (6,343 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)130122
I will donate to the project if issue is resolvedYes
BrowserFirefox and IE
Database type & versionPostgreSQL 8.4
Server OS (if known)Linux
Webserver software & version (if known)Apache/2.2.3 (CentOS)
PHP VersionPHP Version 5.2.17
Git branch / Pull Request URL

Users monitoring this issue

estupendu

Activities

c_schmitz

c_schmitz

2013-01-25 13:06

administrator   ~23811

Sorry, I cannot reproduce. Please attach the survey as .lss file.

c_schmitz

c_schmitz

2013-01-29 10:50

administrator   ~23869

I can activate your survey just fine - tested on 8.4 and latest 9.x . I can only assume that the permissions on the database user might be wrong. It needs to be able to create/modify/delete/index tables.

estupendu

estupendu

2013-01-29 11:51

reporter   ~23873

We use a username with usercreatedb=t, usesuper=t, usecatupd=t. Is it not enough?

c_schmitz

c_schmitz

2013-02-12 10:58

administrator   ~24029

I am sorry, but I don't know. All I can say is that it works here using the postgres user and nobody else working on PostgreSQL seems to have the problem so it is a problem with your server, somehow. Anway, it is not a bug in LimeSurvey.

Issue History

Date Modified Username Field Change
2013-01-25 12:08 estupendu New Issue
2013-01-25 12:08 estupendu File Added: Database Error.jpg
2013-01-25 13:06 c_schmitz Note Added: 23811
2013-01-25 13:06 c_schmitz Assigned To => c_schmitz
2013-01-25 13:06 c_schmitz Status new => feedback
2013-01-28 11:49 estupendu File Added: limesurvey_survey_653284.lss
2013-01-29 10:50 c_schmitz Note Added: 23869
2013-01-29 10:50 c_schmitz Status feedback => closed
2013-01-29 10:50 c_schmitz Resolution open => unable to reproduce
2013-01-29 11:46 estupendu Issue Monitored: estupendu
2013-01-29 11:51 estupendu Note Added: 23873
2013-01-29 11:51 estupendu Status closed => feedback
2013-01-29 11:51 estupendu Resolution unable to reproduce => reopened
2013-01-29 11:52 estupendu File Added: Limesurvey_username.jpg
2013-01-29 11:53 estupendu File Added: Database_limesurvey.jpg
2013-01-29 12:14 estupendu File Added: Limesurvey_tables.jpg
2013-02-12 10:58 c_schmitz Note Added: 24029
2013-02-12 10:58 c_schmitz Status feedback => closed
2013-02-12 10:58 c_schmitz Resolution reopened => unable to reproduce
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing
2021-08-30 09:28 guest Bug heat 4 => 6