View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
09359Bug reportsInstallationpublic2014-11-12 23:46
ReporterCrystalBlood Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionduplicate 
Product Version2.05+ 
Summary09359: Database error during migration from 1.90+ Build 9642 to 2.05+ Build 141110
Description

Migration from 1.90+ to 2.05+ throws some database errors:

From the PostgreSQL log:

ERROR: column "surveyls_survey_id" is in a primary key
STATEMENT: ALTER TABLE lime_surveys_languagesettings ALTER COLUMN surveyls_survey_id DROP NOT NULL
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: ALTER TABLE lime_surveys_languagesettings ALTER COLUMN surveyls_survey_id SET NOT NULL
ERROR: relation "questions_idx3" already exists
STATEMENT: CREATE INDEX "questions_idx3" ON "lime_questions" ("gid")
ERROR: index "user_in_groups_idx1" does not exist
STATEMENT: DROP INDEX "user_in_groups_idx1"
ERROR: index "lime_user_name_key" does not exist
STATEMENT: DROP INDEX "lime_user_name_key"
ERROR: column "attribute_type" is in a primary key
STATEMENT: ALTER TABLE lime_participant_attribute_names ALTER COLUMN attribute_type DROP NOT NULL
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: ALTER TABLE lime_participant_attribute_names ALTER COLUMN attribute_type SET NOT NULL
ERROR: column "id" of relation "lime_participant_attribute_names_lang" does not exist
STATEMENT: ALTER TABLE "lime_participant_attribute_names_lang" DROP COLUMN "id"
ERROR: column "shared_uid" does not exist
STATEMENT: ALTER TABLE "lime_participant_shares" RENAME COLUMN "shared_uid" TO "share_uid"
ERROR: index "assessments_idx" does not exist
STATEMENT: DROP INDEX "assessments_idx"
ERROR: relation "assessments_idx3" already exists
STATEMENT: CREATE INDEX "assessments_idx3" ON "lime_assessments" ("gid")
ERROR: index "ixcode" does not exist
STATEMENT: DROP INDEX "ixcode"
ERROR: syntax error at or near "PRIMARY" at character 32
STATEMENT: ALTER TABLE lime_questions DROP PRIMARY KEY, ADD PRIMARY KEY (qid,language)

Steps To Reproduce

Following the instructions of: http://manual.limesurvey.org/Upgrading_from_a_previous_version#Upgrading_from_version_1.50_or_later_to_any_later_1.xx_version
Issue is raised during the database update from the webpage.

Additional Information

At the webpage, when the error arise, throws this output:

CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "PRIMARY" LINE 1: ALTER TABLE una_questions DROP PRIMARY KEY, ADD PRIMARY KEY ... ^. The SQL statement executed was: ALTER TABLE lime_questions DROP PRIMARY KEY, ADD PRIMARY KEY (qid,language)

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)141110
I will donate to the project if issue is resolvedNo
BrowserChromium
Database type & versionPostgreSQL 8.4
Server OS (if known)Centos 6.6
Webserver software & version (if known)Apache/2.2.15
PHP VersionPHP 5.3.3

Relationships

duplicate of 09351 closedc_schmitz Database error during update 

Users monitoring this issue

There are no users monitoring this issue.

Issue History

Date Modified Username Field Change
2014-11-12 20:23 CrystalBlood New Issue
2014-11-12 20:26 CrystalBlood Note Added: 30953
2014-11-12 20:36 CrystalBlood Note Edited: 30953
2014-11-12 23:46 c_schmitz Relationship added duplicate of 09351
2014-11-12 23:46 c_schmitz Status new => closed
2014-11-12 23:46 c_schmitz Assigned To => c_schmitz
2014-11-12 23:46 c_schmitz Resolution open => duplicate