U4-3291 - Umbraco 6.1.6 to Umbraco 7 nightly build 10/31 FK_cmsMacroProperty_cmsMacroPropertyType_id

Created by David Dimmer 31 Oct 2013, 22:57:23 Updated by Shannon Deminick 26 Nov 2013, 03:18:16

Error dropping constraint FK_cmsMacroProperty_cmsMacroPropertyType_id - is there a way to ignore database errors?

2013-10-31 17:09:35,937 [5] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 14] Executing sql statement 55: ALTER TABLE [cmsMacroProperty] DROP CONSTRAINT [FK_cmsMacroProperty_cmsMacroPropertyType_id] 2013-10-31 17:09:35,939 [5] INFO Umbraco.Core.Persistence.UmbracoDatabase - [Thread 14] at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor) at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.b__0() in f:\TeamCity\buildAgent\work\e1a0ddf7a1349eaf\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 56 at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in f:\TeamCity\buildAgent\work\e1a0ddf7a1349eaf\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 172 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) in f:\TeamCity\buildAgent\work\e1a0ddf7a1349eaf\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 50 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy) in f:\TeamCity\buildAgent\work\e1a0ddf7a1349eaf\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 33 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command) in f:\TeamCity\buildAgent\work\e1a0ddf7a1349eaf\src\Umbraco.Core\Persistence\PetaPocoCommandExtensions.cs:line 21 at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) in f:\TeamCity\buildAgent\work\e1a0ddf7a1349eaf\src\Umbraco.Core\Persistence\PetaPoco.cs:line 528

2 Attachments

Download Schema.sql

Download UmbracoTraceLog.txt

Comments

Shannon Deminick 02 Nov 2013, 01:59:59

Lol, well you definitely don't want to ignore database errors! :P

---

Shannon Deminick 02 Nov 2013, 03:01:26

I've just performed a 6.1.3 to Umbraco 7 without issue on sqlce.

Any chance you can attach your 6.1.6 SQLCE db so i can test against it ? You can attach it and specify "visible to HQ" which means only Umbraco HQ will have access to it.

---

David Dimmer 07 Nov 2013, 06:44:23

I just tried with the release candidate same errors. I cannot hand off this database, but you can contact me, http://Fyin.com/David

The following columns were found in the database, but are not in the current schema: cmsContentTypeAllowedContentType,sortOrder,cmsDataType,controlId,cmsMacroProperty,macroPropertyHidden,cmsMacroProperty,macroPropertyType,cmsMacroPropertyType,id,cmsMacroPropertyType,macroPropertyTypeAlias,cmsMacroPropertyType,macroPropertyTypeRenderAssembly,cmsMacroPropertyType,macroPropertyTypeRenderType,cmsMacroPropertyType,macroPropertyTypeBaseType,cmsTags,parentId,umbracoUser,userDefaultPermissions,umbracoUser,defaultToLiveEditing

The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: FK_cmsContent_umbracoNode,FK_cmsContentType_umbracoNode,FK_cmsDocument_umbracoNode,FK_cmsPropertyData_umbracoNode,FK_cmsPropertyType_cmsPropertyTypeGroup,FK_cmsPropertyTypeGroup_cmsPropertyTypeGroup,FK_cmsTask_cmsTaskType,FK_umbracoMacroProperty_umbracoMacroPropertyType,FK_umbracoNode_umbracoNode,FK_umbracoUser2app_umbracoUser,FK_user_userType,PK__cmsContentVersion__00000000000001BB,PK_cmsTab,PK_domains,PK_language,PK_macro,PK_macroProperty,PK_macroPropertyType,PK_templates,PK_userType

---

Shannon Deminick 07 Nov 2013, 06:59:15

Was fixed today, there were a couple areas that needed changing, just didn't catch the latter one till today

---