-
Type:
Bug Report
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 5.1.0-B2
-
Fix Version/s: 5.1.0-RC1
-
Component/s: Install / Upgrages
-
Labels:
-
External issue URL:
-
Additional information:
-
External issue ID:779
-
Copy Issue Key:
-
Patch Instructions:
I have all modules (even paid) installed and I was trying to upgrade from 4.3.9 to 5.1.0-RC1. This all failed with large SQL error, that LanguageId column was missing in Phrase table, when upgrade script was trying to set index on it.
That's how we are performing upgrade through 2 or more versions now (e.g. from 5.0.0 to 5.0.2):
1. run "before" php upgrade script for 5.0.1 version
2. run "before" php upgrade script for 5.0.2 version
3. run sqls from 5.0.1 to 5.0.2 version
4. run "after" php upgrade script for 5.0.1 version
5. run "after" php upgrade script for 5.0.2 version
This process is repeated for each upgradeable module.
I thought at first, that wrapping version upgrade scripts (php + sql) together will solve the problem:
1. run "before" php upgrade script for 5.0.1 version
2. run 5.0.1 version sqls
3. run "after" php upgrade script for 5.0.1 version
4. run "before" php upgrade script for 5.0.2 version
5. run 5.0.2 version sqls
6. run "after" php upgrade script for 5.0.2 version
But this wasn't helping. Because when 1st module upgrade scripts will delete column, that is used by 2nd module upgrade script, then we also got sql error.
And so another idea approached my mind: you all know, that don't have problems, when we upgrade for 1 version only (e.g. from 5.0.0 to 5.0.1 or from 5.0.1 to 5.0.2). I've created dependency list for each module, where I've listed what "Core" module version is required to perform successful upgrade to each of given module versions.