I'm upgrading an Umbraco cloud solution from v10.8.7 to v13.5.2, but it seems the forms upgrade is not possible directly.
Umbraco forms will try to execute all migrations from 10_0_0 to 13_4_0, but fails at 12_0_0 (screenshot attached) when calling "PopulateNodeTableAndNodeIdToForms".
This particular failing step generates a dynamic SQL query with columns that are not yet added until migration 13_4_0 (like CreatedBy, UpdatedBy).
So the data class definition contains the fields and would produce a specific sql query with corresponding columns, but the columns will only be added in migration 13_4_0. Not ideal.
Anyone else hit this problem?
I will try next to upgrade forms in 2 or 3 jumps to mitigate the steps that are generating sql queries to populate stuff. (Like upgrade first to 12_0_0, then to 13_4_0).
https://cdn.discordapp.com/attachments/1330174389865545890/1330174390037381192/image.png?ex=678d04f0&is=678bb370&hm=0bca410d4121c178d2694f9c432bf654792a6e997f16da16e92560bc6e512445&
andrei8351
01/18/2025, 2:22 PM
Seems to work if I upgrade forms to 13.3.0 (which does not include yet the naughty columns coming in 13.4.0 and so migration 12_0_0 will go through fine). So the workaround is upgrade forms in two steps, first to 13.3.0, then to 13.4.0 or higher.
And side note - forms migration only gets triggered at second umbraco boot. Seen this before, but still happening? 😯
d
Damiaan
02/18/2025, 10:15 PM
Just got the exactly the same issue. Thanks for sharing 🙂