View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
07115Bug reportsInstallationpublic2012-12-21 10:152013-01-08 22:32
Reportermomas33 Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07115: PostgreSQL update in 2.0 failed
Description

Hello,

When i tried to update from Limesurvey 1.92 to 2.0 the postgreSQL database faile with the erro r :

CDbCommand failed to execute the SQL statement: SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)121213
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 8.4
Server OS (if known)windows 7
Webserver software & version (if known)WAMP
PHP Version5.2.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2012-12-23 16:13

reporter   ~23374

Maybe it is missing a table. please try manually adding the table before running the upgrade:
replace the prefix part to match that of your other tables

CREATE TABLE prefix_survey_links (
"participant_id" character varying ( 50 ) NOT NULL,
"token_id" integer NOT NULL,
"survey_id" integer NOT NULL,
"date_created" date NOT NULL,
CONSTRAINT prefix_survey_links_pkey PRIMARY KEY (participant_id,token_id,survey_id)
);
momas33

momas33

2013-01-02 08:43

reporter   ~23394

The table already exist with the same column and constraints.
c_schmitz

c_schmitz

2013-01-03 15:10

administrator   ~23440

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

c_schmitz

2013-01-03 15:38

administrator   ~23443

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

c_schmitz

2013-01-08 22:32

administrator   ~23564

2.00+ Build 130108 released.

Related Changesets

LimeSurvey: master c9e9c989

2012-12-24 10:38

mdekker


Details Diff		 Fixed Possible failure on upgrade due to missing survey_links table Affected Issues
07115
mod - application/helpers/update/updatedb_helper.php Diff File

LimeSurvey: master a57dc0f2

2012-12-24 10:55

mdekker


Details Diff		 dev: removed two chars that gave error on utf-8 Affected Issues
07115
mod - application/helpers/update/updatedb_helper.php Diff File

LimeSurvey: master 92d26bae

2013-01-03 15:10

c_schmitz


Details Diff		 Fixed issue 07115: PostgreSQL update to 2.0 failes with blocked transaction error Affected Issues
07115
mod - application/helpers/update/updatedb_helper.php Diff File

LimeSurvey: 2.1 478e08a7

2013-01-03 15:35

c_schmitz


Details Diff		 Fixed issue 07115: PostgreSQL update to 2.0 fails with blocked transaction error Affected Issues
07115
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-12-21 10:15 momas33 New Issue
2012-12-23 16:13 mdekker Note Added: 23374
2012-12-24 10:50 mdekker Changeset attached => LimeSurvey master c9e9c989
2012-12-24 10:56 mdekker Changeset attached => LimeSurvey master a57dc0f2
2012-12-24 11:00 mdekker Assigned To => mdekker
2012-12-24 11:00 mdekker Status new => assigned
2013-01-02 08:43 momas33 Note Added: 23394
2013-01-03 15:08 c_schmitz Assigned To mdekker => c_schmitz
2013-01-03 15:10 c_schmitz Status assigned => resolved
2013-01-03 15:10 c_schmitz Fixed in Version => 2.00+
2013-01-03 15:10 c_schmitz Resolution open => fixed
2013-01-03 15:10 c_schmitz Changeset attached => LimeSurvey master 92d26bae
2013-01-03 15:10 c_schmitz Note Added: 23440
2013-01-03 15:38 c_schmitz Changeset attached => LimeSurvey 2.1 478e08a7
2013-01-03 15:38 c_schmitz Note Added: 23443
2013-01-08 22:32 c_schmitz Note Added: 23564
2013-01-08 22:32 c_schmitz Status resolved => closed