We have moved to GitHub Issues
You are viewing the read-only archive of Umbraco's issue tracker. To create new issues, please head over to GitHub Issues.
Make sure to read the blog posts announcing the move for more information.
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.
2 Attachments
Lol, well you definitely don't want to ignore database errors! :P
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.
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
Was fixed today, there were a couple areas that needed changing, just didn't catch the latter one till today
Priority: Normal
Type: Bug
State: Closed
Assignee: Shannon Deminick
Difficulty: Normal
Category:
Backwards Compatible: True
Fix Submitted:
Affected versions: 7.0.0
Due in version: 7.0.0
Sprint:
Story Points:
Cycle: