LimeSurvey issue tracker
Registration

View Issue Details Jump to Notes ] Related Changesets ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
08675Bug reports[All Projects] Installationpublic2014-02-06 17:072014-02-12 21:20
Reporteratisne 
Assigned Toc_schmitz 
PrioritynormalSeverityminor 
StatusclosedResolutionfixed 
Product Version2.05+ 
Target VersionFixed in Version2.05+ 
Summary08675: Migration issue from 1.90 to 2.05
DescriptionI've experienced issues during the migration of limesurvey 1.90 to 2.05 with the postgresql DB update. (It seems to be the same as CrystalBlood [https://www.limesurvey.com/en/forum/installation-a-update-issues/95371-possible-bug-on-migrating-database-to-2-05 [^]].)
Steps To ReproduceInstructions of http://manual.limesurvey.org/Upgrading_from_a_previous_version [^]
We use the admin web pages.
Issues are raised during the database update.
Additional InformationI fix the three errors as follow :

1- I deleted (and restore) primary key for the table 'labels' before alter column (because column 'language' is part of primary key).

+ dropPrimaryKey('labels');
             alterColumn('{{labels}}','language',"{$sVarchar}(20)",false , 'en');
+ addPrimaryKey('labels', array('lid', 'sortorder', 'language'));

2- I added TransactionBookmark when dropping index 'email' on table 'users' (because postgresql does not suffer failing during a transaction).

             try{
+ setTransactionBookmark();
                 $oDB->createCommand()->dropIndex('email','{{users}}');
             }
             catch(Exception $e)
             {
                 // do nothing
+ rollBackToTransactionBookmark();
             }

3- 1- I deleted primary key for the table 'user_in_groups' before alter column (because columns 'ugid' and 'uid' are part of primary key). Primary key are created some lines after.

+ dropPrimaryKey('user_in_groups');
             alterColumn('{{user_in_groups}}','ugid',"integer",false);
             alterColumn('{{user_in_groups}}','uid',"integer",false);

It works for me, but, as I am not sure this fix is relevant in all cases, I just provide a patch and not a pull request.
I will donate to the project if issue is resolved within 48 hrsNo
LimeSurvey build number OR git commit ID140204
BrowserFireFox
Database & DB-VersionPostgresql 8.3
Operating System (Server)centOS
Webserver software & versionapache 2.2.3
PHP Version5.4.24
Attached Files? file icon patch [^] (1,805 bytes) 2014-02-06 17:07 [Show Content]

- Relationships

-  Notes
User avatar (28552)
c_schmitz (administrator)
2014-02-07 15:08

Thank you very much!
User avatar (28553)
c_schmitz (administrator)
2014-02-07 15:09

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13857 [^]
User avatar (28684)
c_schmitz (administrator)
2014-02-12 21:20

2.05+ Build 140212 released

- Related Changesets
LimeSurvey: master fc74fd2c
Timestamp: 2014-02-07 14:08:33
Author: c_schmitz
Committer: Carsten Schmitz
Details ] Diff ]
Fixed issue 08675: Migration issue from 1.90 to 2.05 if using Postgres - patch by atisne
mod - application/helpers/update/updatedb_helper.php Diff ] File ]

- Issue History
Date Modified Username Field Change
2014-02-06 17:07 atisne New Issue
2014-02-06 17:07 atisne File Added: patch
2014-02-07 15:08 c_schmitz Assigned To => c_schmitz
2014-02-07 15:08 c_schmitz Status new => assigned
2014-02-07 15:08 c_schmitz Status assigned => resolved
2014-02-07 15:08 c_schmitz Fixed in Version => 2.05+
2014-02-07 15:08 c_schmitz Resolution open => fixed
2014-02-07 15:08 c_schmitz Note Added: 28552
2014-02-07 15:09 c_schmitz Changeset attached => LimeSurvey master fc74fd2c
2014-02-07 15:09 c_schmitz Note Added: 28553
2014-02-12 21:20 c_schmitz Note Added: 28684
2014-02-12 21:20 c_schmitz Status resolved => closed


Copyright © 2000 - 2014 MantisBT Team
Powered by Mantis Bugtracker