View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 07229 | Bug reports | Survey editing | public | 2013-01-25 12:08 | 2013-02-12 10:58 |
| Reporter | estupendu | Assigned To | c_schmitz | ||
| Priority | urgent | Severity | partial_block | ||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 2.00+ | ||||
| Summary | 07229: 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!!" | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 130122 | ||||
| I will donate to the project if issue is resolved | Yes | ||||
| Browser | Firefox and IE | ||||
| Database type & version | PostgreSQL 8.4 | ||||
| Server OS (if known) | Linux | ||||
| Webserver software & version (if known) | Apache/2.2.3 (CentOS) | ||||
| PHP Version | PHP Version 5.2.17 | ||||
| Git branch / Pull Request URL | |||||
|
Sorry, I cannot reproduce. Please attach the survey as .lss file. |
|
|
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. |
|
|
We use a username with usercreatedb=t, usesuper=t, usecatupd=t. Is it not enough? |
|
|
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. |
|
| 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 |