I have a site running Umbraco v13 which I have upgraded from v8 via v10. I am now trying to install the latest version of Umbraco Forms - I have installed the package via Nuget and can load the Forms section in the backend, however doing so shows this error: Invalid column name 'DeleteEntries'. On checking the Installed Packages view I can see there are Pending migrations for the Umbraco Forms package, selecting the option to Run them shows a "successfully completed" message in the front-end but the console the site was run from shows the following errors: [10:35:00 INF] Create Foreign Key: ALTER TABLE [UFUserGroupFormSecurity] ADD CONSTRAINT [FK_UFUserGroupFormSecurity_UFForms_Key] FOREIGN KEY ([Form]) REFERENCES [UFForms] ([Key]) [10:35:00 ERR] Exception (9b7b8baf). Microsoft.Data.SqlClient.SqlException (0x80131904): There are no primary or candidate keys in the referenced table 'UFForms' that match the referencing column list in the foreign key 'FK_UFUserGroupFormSecurity_UFForms_Key'. Could not create constraint or index. See previous errors. Plan failed at step 7c7bc5ee-4c5b-42dc-9576-5ce6dfbddb8e Has anybody encountered this error or similar before, or has any advice on resolving it?

Yip, I've ran in to this doing a similar upgrade. I manually added the Delete Entries table in to the database.

Ideal, thanks very much @Owain - I've been trying to find the migration code myself. Will see if I can re-run some upgrade steps against another database copy..

I think it's somewhere around Umbraco Forms 8.11 that has the new tables added.

I've hit this and wondered if there is a reliable way to ensure the database matches the required schema because the shipped migration does not seem to do that because even after running it again the missing fields are not present. I've just has some success by tacking this on the end of my custom migration plan...

From("MYSTATE").To<AddDeleteEntriesPermissions>("FormsAddDeleteEntriesPermissions");
From("FormsAddDeleteEntriesPermissions").To<AddCreatedAndUpdatedByToEntities>("FormsAddCreatedAndUpdatedByToEntities");
From("FormsAddCreatedAndUpdatedByToEntities").To<AddRecordAdditionalDataColumn>("AddRecordAdditionalDataColumn");

I am hoping to do something similar if I come across any other missing fields but it still does not ensure a correct schema at the end.

Good luck @ProNotion - for what it's worth we ended up just starting from scratch with Forms, as tracking down every migration was taking too much time

@weedroid I think you might be right. I have a lot of forms to get in there - how did you handle that?

It was all manual I'm afraid, just recreating the forms and their fields via the back office

OK, that's not an option for me, it would be a painful experience as we have over 70 forms some of which are multi-step 😞

Sounds like a good plan, I hope it gets you further!

https://jumoo.co.uk/usync/forms/ might be very helpful here

Thanks, I have a feeling I am using that but from memory it is only supported in v8+ and my migration bypasses v8 completely so I couldn't use it until later on in my migration.