View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|15679||Feature requests||[All Projects] Installation||public||2019-12-19 13:30||2020-01-14 16:14|
|Target Version||Fixed in Version|
|Summary||15679: Creation of database migration scripts|
we currently are migrating some old LS 1.9 installations to LS 3. Because of missing tables it's a pretty long and rough way.
|Tags||No tags attached.|
So just to give an insight of the currently faced issues: We tried updating a large Limesurvey system (DB size: 4.5GB) from 1.92 to the latest 3.21.2 version and totally failed. We wasted some hours trying to debug errors before going from version to version in small steps which finally worked fine.
This is what happened:
That took several hours including yelling at the PC and searching documentation for possible solutions.
Assuming that there will be huge DB adjustments when going from LS 4 to LS 5 (more object oriented question models, new DB schema for strong responses in a non-flat-table system, ...) we should find better ways to run such updates.
Feel free to ping us/David if you want to discuss using Yii migration classes.
@DenisChenu, have you ever faced similar problems when updating stone-old systems?
What do you suggest to provide better updating features?
I think it was managed in previous system ?
I already say we need update $to : then we can upgrade really step by step.
Using Yii system seem great too, but REALLY need more work (we need to create whole update system from 1.80 …)
Did you clear cache after update?
@ollehar: I do not really remember if I cleared the cache but at other updates I noticed that not clearing cache can indeed cause weird issues like being unable to log in.
@Mazi, to be precise, I'm talking about the Yii runtime cache. Hm, wait, I remember someone else talking about that problem. Strange.
|2019-12-19 13:30||dschirge||New Issue|
|2019-12-19 14:37||Mazi||Note Added: 55081|
|2019-12-19 14:39||Mazi||Note Added: 55082|
|2019-12-19 14:40||Mazi||Note Added: 55083|
|2019-12-19 14:48||DenisChenu||Note Added: 55084|
|2020-01-14 15:15||ollehar||Note Added: 55233|
|2020-01-14 15:27||Mazi||Note Added: 55236|
|2020-01-14 16:14||ollehar||Note Added: 55242|