View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
06090Bug reportsOtherpublic2012-05-13 14:332012-05-28 15:12
Reportermars99 Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00RC1 
Fixed in Version2.00RC2 
Summary06090: Activating a survey ends with a database (SQL) error on PostgreSQL
Description

Activating a survey ends with an error on PostgreSQL while copying the questionaire to it's own table.
The problem is that a MySQL statement is used ("id" INT (10) AUTO_INCREMENT PRIMARY) instead of the more SQL-Standard conform PostgreSQL version (id SERIAL PRIMARY KEY).

Here the original error message:
CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "(" LINE 2: "id" INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, ^. The SQL statement executed was: CREATE TABLE "lime_survey_874652" ( "id" INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, "submitdate" DATETIME, "lastpage" INT(10), "startlanguage" VARCHAR(20) NOT NULL, "token" VARCHAR(36), "startdate" DATETIME NOT NULL, "datestamp" DATETIME NOT NULL, "874652X1X1SQ008" VARCHAR(5), "874652X1X1SQ009" VARCHAR(5), "874652X1X1SQ001" VARCHAR(5), "874652X1X1SQ002" VARCHAR(5), "874652X1X1SQ004" VARCHAR(5), "874652X1X1SQ010" VARCHAR(5), "874652X1X1SQ011" VARCHAR(5), "874652X1X1SQ005" VARCHAR(5), "874652X1X1SQ007" VARCHAR(5), "874652X1X1SQ017" VARCHAR(5), "874652X1X1SQ018" VARCHAR(5), "874652X1X1SQ012" VARCHAR(5), "874652X1X1SQ025" VARCHAR(5), "874652X1X1SQ013" VARCHAR(5), "874652X1X1SQ014" VARCHAR(5), "874652X1X1SQ015" VARCHAR(5), "874652X1X1SQ021" VARCHAR(5), "874652X1X1SQ016" VARCHAR(5), "874652X1X1SQ019" VARCHAR(5), "874652X1X1SQ027" VARCHAR(5), "874652X1X1SQ028" VARCHAR(5), "874652X1X1SQ029" VARCHAR(5), "874652X1X1SQ022" VARCHAR(5), "874652X1X1SQ023" VARCHAR(5), "874652X1X1SQ024" VARCHAR(5), "874652X1X1SQ026" VARCHAR(5), "874652X1X1SQ003" VARCHAR(5), "874652X1X1SQ006" VARCHAR(5), "874652X1X1SQ020" VARCHAR(5), "874652X1X31SQ021" VARCHAR(5), "874652X1X31SQ023" VARCHAR(5), "874652X1X31SQ033" VARCHAR(5), "874652X1X31SQ013" VARCHAR(5), "874652X1X31SQ015" VARCHAR(5), "874652X1X31SQ017" VARCHAR(5), "874652X1X31SQ025" VARCHAR(5), "874652X1X31SQ035" VARCHAR(5), "874652X1X31SQ037" VARCHAR(5), "874652X1X31SQ039" VARCHAR(5), "874652X1X31SQ047" VARCHAR(5), "874652X1X31SQ019" VARCHAR(5), "874652X1X31SQ001" VARCHAR(5), "874652X1X31SQ027" VARCHAR(5), "874652X1X31SQ029" VARCHAR(5), "874652X1X31SQ041" VARCHAR(5), "874652X1X31SQ031" VARCHAR(5), "874652X1X31SQ045" VARCHAR(5), "874652X1X31SQ009" VARCHAR(5), "874652X1X31SQ043" VARCHAR(5), "874652X1X31SQ011" VARCHAR(5), "874652X1X31SQ018" VARCHAR(5), "874652X1X31SQ026" VARCHAR(5), "874652X1X31SQ007" VARCHAR(5), "874652X1X31SQ034" VARCHAR(5), "874652X1X31SQ004" VARCHAR(5), "874652X1X31SQ046" VARCHAR(5), "874652X1X31SQ012" VARCHAR(5), "874652X1X31SQ036" VARCHAR(5), "874652X1X31SQ005" VARCHAR(5), "874652X1X31SQ006" VARCHAR(5), "874652X1X31SQ010" VARCHAR(5), "874652X1X31SQ030" VARCHAR(5), "874652X1X31SQ032" VARCHAR(5), "874652X1X31SQ016" VARCHAR(5), "874652X1X31SQ022" VARCHAR(5), "874652X1X31SQ020" VARCHAR(5), "874652X1X31SQ044" VARCHAR(5), "874652X1X31SQ028" VARCHAR(5), "874652X1X31SQ008" VARCHAR(5), "874652X1X31SQ038" VARCHAR(5), "874652X1X31SQ002" VARCHAR(5), "874652X1X31SQ014" VARCHAR(5), "874652X1X31SQ003" VARCHAR(5), "874652X1X31SQ024" VARCHAR(5), "874652X1X31SQ040" VARCHAR(5), "874652X1X31SQ042" VARCHAR(5), "874652X1X79" VARCHAR(5), "874652X1X80" VARCHAR(5), "874652X1X81" VARCHAR(5), "874652X1X82" VARCHAR(5), "874652X1X83SQ003" VARCHAR(5), "874652X1X83SQ001" VARCHAR(5), "874652X1X83SQ002" VARCHAR(5), "874652X1X83SQ004" VARCHAR(5), "874652X1X88" VARCHAR(5), "874652X1X892" VARCHAR(5), "874652X1X891" VARCHAR(5), "874652X1X93" VARCHAR(5), "874652X1X94" VARCHAR(5) )

[..]
Survey could not be activated.

Database error!!

Steps To Reproduce

I created a survey of 10 questions (using Array, multiple choice,...) with lots of subquestions which took some time because I had to work around Bug 06088
As it's a general problem I don't think I have to attach an export of my questionaire.

1.) Login in to Limesurvey Admin backend
2.) Create a simple survey (with one question should be sufficiant).
3.) Active the survey.
On the first page before the actual activation (survey copy operation) the I changed 'Date stamp?' to 'yes' then I press 'Save / Activate survey' with the error shown above.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)120510
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 9.1.3
Server OS (if known)Ubuntu 12.04 LTS (ARM)
Webserver software & version (if known)lighttpd/1.4.28
PHP VersionPHP5 (5.3.10-1*)

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-05-16 15:48

administrator   ~18781

Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8490
c_schmitz

c_schmitz

2012-05-28 15:12

administrator   ~18958

Version 2.00RC2 released.

Related Changesets

LimeSurvey: Yii ca586fd4

2012-05-16 06:39:45

c_schmitz

Details Diff 		Fixed issue 06090: Activating a survey gives a database error on PostgreSQL Affected Issues
06090
mod - application/helpers/admin/activate_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-05-13 14:33 mars99 New Issue
2012-05-16 15:48 c_schmitz Assigned To => c_schmitz
2012-05-16 15:48 c_schmitz Status new => assigned
2012-05-16 15:48 c_schmitz Changeset attached => LimeSurvey Yii ca586fd4
2012-05-16 15:48 c_schmitz Note Added: 18781
2012-05-16 15:48 c_schmitz Resolution open => fixed
2012-05-16 15:48 c_schmitz Status assigned => resolved
2012-05-16 15:48 c_schmitz Fixed in Version => 2.00RC2
2012-05-28 15:12 c_schmitz Note Added: 18958
2012-05-28 15:12 c_schmitz Status resolved => closed