Umbraco.Cms.Core.Exceptions.BootFailedException after update to Umbraco Forms v9.3.0
Hi guys!
I just updated my Umbraco Forms from v9.2.2 to version v9.3.0.
Now suddenly I got an SQL error, I just updated trough Nuget so I'm not realy into SQL errors. This is what I get:
-> Umbraco.Cms.Core.Exceptions.BootFailedException: There are no primary or candidate keys in the referenced table 'UFFolders' that match the referencing column list in the foreign key 'FKUFUserStartFoldersUFFolders_FolderKey'.
Could not create constraint or index. See previous errors.
I'm working localy with Visual Studio and IIS and have a connection string to my SQL Server database at my website hosting. Before the update it worked, afterwards it didn't.
There should be a 'migration' script that runs when you install the upgraded Umbraco Forms to add these changes to your Umbraco site...
But it appears like they haven't run?
It might be worth trying to install again, or if you can install on a fresh umbraco site you may be able to work out what the changes are and migrate them manually, but if SQL is not your thing, and the reinstall doesn't work, then it will be worth raising this on the public issue tracker:
Umbraco.Cms.Core.Exceptions.BootFailedException after update to Umbraco Forms v9.3.0
Hi guys!
I just updated my Umbraco Forms from v9.2.2 to version v9.3.0. Now suddenly I got an SQL error, I just updated trough Nuget so I'm not realy into SQL errors. This is what I get:
-> Umbraco.Cms.Core.Exceptions.BootFailedException: There are no primary or candidate keys in the referenced table 'UFFolders' that match the referencing column list in the foreign key 'FKUFUserStartFoldersUFFolders_FolderKey'. Could not create constraint or index. See previous errors.
I'm working localy with Visual Studio and IIS and have a connection string to my SQL Server database at my website hosting. Before the update it worked, afterwards it didn't.
Does anybody know what to do?
Hi Bart
Umbraco Forms 9.3 has some new features https://umbraco.com/blog/umbraco-product-update-march-15-2022/ To support this, there are changes to the underlying umbraco database tables that forms uses to store information.
There should be a 'migration' script that runs when you install the upgraded Umbraco Forms to add these changes to your Umbraco site... But it appears like they haven't run?
It might be worth trying to install again, or if you can install on a fresh umbraco site you may be able to work out what the changes are and migrate them manually, but if SQL is not your thing, and the reinstall doesn't work, then it will be worth raising this on the public issue tracker:
https://github.com/umbraco/Umbraco.Forms.Issues/issues
regards
Marc
Thnx Marc!
I will get into that solution, I went back one version and it works for now. Thnx again for the reply
Best regards, Bart
is working on a reply...