Trying to do some upgrades and hitting problems with the database upgrade, specifically in regards to the 'umbracouser2usergroup' table.

I'm trying to upgrade 7.6.13 to, well, anything. I've tried 7.7.0, 7.7.1, 7.7.13, and 7.11.1 so far with the same results.

This is a SQL CE install, but on another installation I'm seeing similar errors with a standard SQL Server install.

The error is as follows:

[P8620/D3/T13] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (c4be183d).
System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ umbracoUser2UserGroup ]
   at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
   at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
   at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
   at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()

I've seen this specific table error referenced in the following places:

• http://issues.umbraco.org/issue/U4-10472
• https://our.umbraco.com/forum/using-umbraco-and-getting-started/88380-upgrade-764-to-771
• https://our.umbraco.com/forum/using-umbraco-and-getting-started/91641-umbraco-upgrade-never-updates-database
• https://our.umbraco.com/forum/using-umbraco-and-getting-started/89324-ugrading-to-776-invalid-object-name-umbracouser2usergroup
• https://our.umbraco.com/forum/using-umbraco-and-getting-started/89898-log-errors-during-upgrade-invalid-object-name-umbracouser2usergroup
• https://our.umbraco.com/forum/using-umbraco-and-getting-started/91038-upgrade-to-792-resulted-in-error-invalid-object-name-umbracouser2usergroup
• https://our.umbraco.com/forum/using-umbraco-and-getting-started/89032-umbraco-upgradation-error-table-umbracouser2usergroup-doesnt-exist
• https://our.umbraco.com/forum/using-umbraco-and-getting-started/89580-unable-to-upgrade-from-735
• https://our.umbraco.com/forum/using-umbraco-and-getting-started/88501-umbraco-765-to-772-nuget-upgrade-issue
• https://our.umbraco.com/forum/extending-umbraco-and-using-the-api/91540-upgrade-issues
• https://our.umbraco.com/forum/using-umbraco-and-getting-started/90948-cannot-log-in-after-trying-to-upgrade-716-to-77

Is there a fix for this for SQL CE?

Any chance we can get a fix for this integrated into the upgrade process? This seems to have hit enough people and may even have a possible solution in U4-10472 so it would make upgrading a lot less painful if the migration could succeed more frequently.

Thanks!