View Issue Details

IDProjectCategoryView StatusLast Update
12065Development Installationpublic2017-01-19 18:38
ReporterDenisChenuAssigned To 
PrioritynoneSeverityfeature 
Status newResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary12065: Update step by step
Description

During upgrade process : all DB update are done in a try, and broke one rollback transaction (and in fact unsure if it work and where it break exactly.
But all part can be separate : all part do their job and update DB, we can do in X transaction .

Then upgrade can do 111 to 150 , broke but DB are already updated partially at 150.

Additional Information

The best are do all system in ajax, but start by separate each transation.
And allow in function a function db_upgrade_all($iOldDBVersion,$iNewDBVersion=null) maybe

TagsNo tags attached.

Activities

DenisChenu

DenisChenu

2017-01-18 22:55

developer   ~42763

Not exactly ComfortUpdate, then remove Louis Auto assign

LouisGac

LouisGac

2017-01-19 10:18

manager   ~42765

well, the best way to do that would be to use the Yii Migrations
http://www.yiiframework.com/doc/guide/1.1/en/database.migration

DenisChenu

DenisChenu

2017-01-19 10:19

developer   ~42766

And rewrite all existing update system ... not for me ....
For next update function : yes, but for existing function : no

LouisGac

LouisGac

2017-01-19 10:30

manager   ~42767

^^
That's for me ;-)

DenisChenu

DenisChenu

2017-01-19 11:33

developer   ~42768

You really want to rewrite more than 100 function ????

LouisGac

LouisGac

2017-01-19 11:38

manager   ~42771

not now, for sure

Also: we still have to think if we provide LS3 as an update for LS2.x (via comfortUpdate, etc)

If not, or if we provide an update to LS3 only for the very last build of LS2.50, then we could start with a clean updatedb.

DenisChenu

DenisChenu

2017-01-19 11:45

developer   ~42772

Update in 2 step (for 2.59.12 or less )
1st step : update to 2.60 (for example)
2nd step : update to 3.0

why not :)

DenisChenu

DenisChenu

2017-01-19 11:46

developer   ~42773

Moved to development

Related Changesets

LimeSurvey: master 248f940d

2017-01-19 16:45:09

c_schmitz

Details Diff
Dev Divided updates in smaller transactions so if something goes wrong it is more easy to recover manually
Dev See issue 12065
Affected Issues
12065
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2017-01-18 22:54 DenisChenu New Issue
2017-01-18 22:54 DenisChenu Status new => assigned
2017-01-18 22:54 DenisChenu Assigned To => LouisGac
2017-01-18 22:54 DenisChenu Assigned To LouisGac =>
2017-01-18 22:55 DenisChenu Status assigned => new
2017-01-18 22:55 DenisChenu Note Added: 42763
2017-01-19 10:18 LouisGac Note Added: 42765
2017-01-19 10:19 DenisChenu Note Added: 42766
2017-01-19 10:30 LouisGac Note Added: 42767
2017-01-19 11:33 DenisChenu Note Added: 42768
2017-01-19 11:38 LouisGac Note Added: 42771
2017-01-19 11:45 DenisChenu Note Added: 42772
2017-01-19 11:46 DenisChenu Project Feature requests => Development
2017-01-19 11:46 DenisChenu Note Added: 42773
2017-01-19 16:23 c_schmitz Category ComfortUpdate => Installation
2017-01-19 16:45 c_schmitz Changeset attached => LimeSurvey master 248f940d