View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
09120Bug reportsInstallationpublic2014-06-27 18:272014-07-30 16:18
Reporteratisne Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary09120: Migration issue from 1.90 to 2.05
Description

The migration process stop with the following error:

CDbCommand failed to execute the SQL statement: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block

In postgres log:

2014-06-27 16:11:51 CEST [29693]: [12-1] db=limesurvey ERREUR: l'index « questions_idx4 » n'existe pas
2014-06-27 16:11:51 CEST [29693]: [13-1] db=limesurvey INSTRUCTION : DROP INDEX "questions_idx4"

Steps To Reproduce

Instructions of http://manual.limesurvey.org/Upgrading_from_a_previous_version
We use the admin web pages.
Issues are raised during the database update.

Additional Information

I fix it changing the line 512 of application/helpers/update/updatedb_helper.php

512c512
< try{ $oDB->createCommand()->dropIndex('questions_idx4','{{questions}}');} catch(Exception $e){};

        try{ setTransactionBookmark(); $oDB->createCommand()->dropIndex('questions_idx4','{{questions}}');} catch(Exception $e){rollBackToTransactionBookmark();};

I'm wondering if such thing should not be done for each try/catch in this file because postgresql does not suffer failing during a transaction.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)140618
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgresql 8.3
Server OS (if known)CentOS
Webserver software & version (if known)apache 2.2.3
PHP Version5.4.29
Git branch / Pull Request URL

Users monitoring this issue

atisne

Activities

c_schmitz

c_schmitz

2014-07-25 09:29

administrator   ~30348

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

c_schmitz

2014-07-25 09:29

administrator   ~30349

Thank you!
c_schmitz

c_schmitz

2014-07-30 16:18

administrator   ~30372

2.05+ Build 140730 released

Related Changesets

LimeSurvey: master eaee705d

2014-07-25 09:29

c_schmitz


Details Diff		 Fixed issue 09120: Migration issue from 1.90 to 2.05 when using Postgres Affected Issues
09120
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-06-27 18:27 atisne New Issue
2014-06-27 18:30 atisne Issue Monitored: atisne
2014-07-25 09:28 c_schmitz Assigned To => c_schmitz
2014-07-25 09:28 c_schmitz Status new => assigned
2014-07-25 09:29 c_schmitz Changeset attached => LimeSurvey master eaee705d
2014-07-25 09:29 c_schmitz Note Added: 30348
2014-07-25 09:29 c_schmitz Resolution open => fixed
2014-07-25 09:29 c_schmitz Note Added: 30349
2014-07-25 09:29 c_schmitz Status assigned => resolved
2014-07-25 09:29 c_schmitz Fixed in Version => 2.05+
2014-07-30 16:18 c_schmitz Note Added: 30372
2014-07-30 16:18 c_schmitz Status resolved => closed
2021-08-03 12:38 guest Bug heat 2 => 4