I have a site currently on v3.0.6 and I have been trying to get it to 7.1 but I'm stuck at v6.2.1 due to db migration issues.
After resolving issues that other experienced.
I tried everything I can think of and got nowhere. Even tried using SQL Schema/Data Compare tools.
It would be too much work with a fresh install and manually setting content and everything back up.
The database failed to upgrade. ERROR: The database configuration failed with the following message: Column names in each table must be unique. Column name 'propertyEditorAlias' in table 'cmsDataType' is specified more than once. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_umbracoRelation_umbracoNode1". The conflict occurred in database "umbVYT2", table "dbo.umbracoNode", column 'id'.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Incorrect syntax near ')'.
Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
2014-10-06 10:45:09,209 [8] ERROR Umbraco.Web.Install.Controllers.InstallApiController - [Thread 21] An error occurred during installation step DatabaseUpgrade
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Incorrect syntax near ')'.
Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
I managed to fix the contraint issue for relations.
I checked to see if the id or parent id exists in the node table. If one of the ids cannot be found in the node table, then I removed the row from the relations table.
That fixed adding the contraint. Now I have
The ALTER TABLE statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "umbVYT2", table "dbo.umbracoNode", column 'id'
Edit: I fixed this by checking for a null id with a left join and deleting the rows. I ran into more contraint issues with the delete script. So I modified the cascade on delete for the foreign keys that had contraint errors.
I used this example from SO to find bad contraint data. Changed the tables/column names.
DELETE items FROM items leftjoin items as parent on items.parentID = parent.itemID WHERE parent.itemID isNULL
Now I'm back to this error: The database failed to upgrade. ERROR: The database configuration failed with the following message: Incorrect syntax near ')'. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
I used the mostly schema matched 6.22. And Manually did the schema changes to cmstagrelationships (I don't think I had any), described in the ticket I posted above.
Then I started with a fresh 7.18 db. Used redgate to schema compare, move everything I can over.
I had to setup macroproperty types (all of them were "choose" textbox.
Then I had to drop and recreate my document types table. When I did that, document types were showing (got an error in Developer > doc types before).
Then I had to delete App_Data\Temp and App_Data\Umbraco.config.
I dropped and recreated the contextxml and previewxml tables.
Reset the app pool.
Everything looks published. Now getting navigation error and a weird publish error in the log.
v3.0.6 to v7
I have a site currently on v3.0.6 and I have been trying to get it to 7.1 but I'm stuck at v6.2.1 due to db migration issues.
After resolving issues that other experienced.
I tried everything I can think of and got nowhere. Even tried using SQL Schema/Data Compare tools.
It would be too much work with a fresh install and manually setting content and everything back up.
The database failed to upgrade. ERROR: The database configuration failed with the following message: Column names in each table must be unique. Column name 'propertyEditorAlias' in table 'cmsDataType' is specified more than once. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
I am also getting
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_umbracoRelation_umbracoNode1". The conflict occurred in database "umbVYT2", table "dbo.umbracoNode", column 'id'.
ALTER TABLE [dbo].[umbracoRelation] ADD CONSTRAINT [FK_umbracoRelation_umbracoNode1] FOREIGN KEY ([childId]) REFERENCES [dbo].[umbracoNode] ([id])
ALTER TABLE [dbo].[umbracoRelation] ADD CONSTRAINT [FK_umbracoRelation_umbracoNode] FOREIGN KEY ([parentId]) REFERENCES [dbo].[umbracoNode] ([id])
2014-10-06 10:45:06,397 [8] INFO Umbraco.Core.ApplicationContext - [Thread 21] CurrentVersion different from configStatus: '7.1.7','6.2.2'
2014-10-06 10:45:06,397 [8] INFO Umbraco.Core.ApplicationContext - [Thread 21] CurrentVersion different from configStatus: '7.1.7','6.2.2'
2014-10-06 10:45:06,397 [8] INFO Umbraco.Web.Install.Controllers.InstallApiController - [Thread 21] Executing installation step: DatabaseUpgrade
2014-10-06 10:45:06,397 [8] INFO Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep - [Thread 21] Running 'Upgrade' service
2014-10-06 10:45:06,397 [8] INFO Umbraco.Core.DatabaseContext - [Thread 21] Database upgrade started
2014-10-06 10:45:06,397 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Initializing database migrations
2014-10-06 10:45:06,397 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AddPropertyEditorAliasColumn' to context
2014-10-06 10:45:06,459 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'UpdateControlIdToPropertyEditorAlias' to context
2014-10-06 10:45:06,459 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'DropControlIdColumn' to context
2014-10-06 10:45:06,459 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AlterUserTable' to context
2014-10-06 10:45:08,350 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AddIndexToCmsMacroTable' to context
2014-10-06 10:45:08,381 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AddIndexToCmsMacroPropertyTable' to context
2014-10-06 10:45:08,397 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AlterCmsMacroPropertyTable' to context
2014-10-06 10:45:08,397 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'RemoveCmsMacroPropertyTypeTable' to context
2014-10-06 10:45:08,428 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AlterTagRelationsTable' to context
2014-10-06 10:45:08,444 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AlterTagsTable' to context
2014-10-06 10:45:08,444 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'UpdateRelatedLinksData' to context
2014-10-06 10:45:08,444 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AssignMissingPrimaryForMySqlKeys' to context
2014-10-06 10:45:08,475 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AdditionalIndexesAndKeys' to context
2014-10-06 10:45:08,475 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'ChangePasswordColumn' to context
2014-10-06 10:45:08,475 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'AddChangeDocumentTypePermission' to context
2014-10-06 10:45:08,475 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Added UPGRADE migration 'UpdateToNewMemberPropertyAliases' to context
2014-10-06 10:45:08,475 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 1: ALTER TABLE [cmsDataType] ADD [propertyEditorAlias] NVARCHAR(255) NOT NULL CONSTRAINT [DF_cmsDataType_propertyEditorAlias] DEFAULT ('')
2014-10-06 10:45:08,522 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 2: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.TrueFalse' WHERE [pk] = '4'
2014-10-06 10:45:08,537 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 3: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.Integer' WHERE [pk] = '6'
2014-10-06 10:45:08,537 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 4: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.TinyMCEv3' WHERE [pk] = '8'
2014-10-06 10:45:08,537 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 5: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.Textbox' WHERE [pk] = '9'
2014-10-06 10:45:08,537 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 6: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.TextboxMultiple' WHERE [pk] = '10'
2014-10-06 10:45:08,537 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 7: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.UploadField' WHERE [pk] = '11'
2014-10-06 10:45:08,537 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 8: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.NoEdit' WHERE [pk] = '13'
2014-10-06 10:45:08,537 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 9: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.DateTime' WHERE [pk] = '14'
2014-10-06 10:45:08,537 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 10: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.ColorPickerAlias' WHERE [pk] = '15'
2014-10-06 10:45:08,553 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 11: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.FolderBrowser' WHERE [pk] = '16'
2014-10-06 10:45:08,553 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 12: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.DropDownMultiple' WHERE [pk] = '17'
2014-10-06 10:45:08,553 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 13: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.RadioButtonList' WHERE [pk] = '18'
2014-10-06 10:45:08,553 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 14: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.Date' WHERE [pk] = '19'
2014-10-06 10:45:08,553 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 15: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.DropDown' WHERE [pk] = '20'
2014-10-06 10:45:08,553 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 16: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.CheckBoxList' WHERE [pk] = '21'
2014-10-06 10:45:08,553 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 17: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.ContentPickerAlias' WHERE [pk] = '31'
2014-10-06 10:45:08,569 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 18: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.MediaPicker' WHERE [pk] = '32'
2014-10-06 10:45:08,569 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 19: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.MemberPicker' WHERE [pk] = '33'
2014-10-06 10:45:08,569 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 20: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.NoEdit' WHERE [pk] = '34'
2014-10-06 10:45:08,569 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 21: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.MarkdownEditor' WHERE [pk] = '35'
2014-10-06 10:45:08,569 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 22: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.NoEdit' WHERE [pk] = '36'
2014-10-06 10:45:08,569 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 23: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.NoEdit' WHERE [pk] = '37'
2014-10-06 10:45:08,584 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 24: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.NoEdit' WHERE [pk] = '38'
2014-10-06 10:45:08,584 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 25: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.NoEdit' WHERE [pk] = '39'
2014-10-06 10:45:08,584 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 26: UPDATE [cmsDataType] SET [propertyEditorAlias] = 'Umbraco.NoEdit' WHERE [pk] = '40'
2014-10-06 10:45:08,584 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 27: ALTER TABLE [cmsDataType] DROP COLUMN [controlId]
2014-10-06 10:45:08,615 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 28: ALTER TABLE [cmsDataType] DROP CONSTRAINT [DF_cmsDataType_propertyEditorAlias]
2014-10-06 10:45:08,709 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 29: ALTER TABLE [umbracoUser] DROP COLUMN [userDefaultPermissions]
2014-10-06 10:45:08,709 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 30: ALTER TABLE [umbracoUser] DROP CONSTRAINT [DF_umbracoUser_defaultToLiveEditing]
2014-10-06 10:45:08,725 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 31: ALTER TABLE [umbracoUser] DROP COLUMN [defaultToLiveEditing]
2014-10-06 10:45:08,725 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 32: CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsMacro_Alias] ON [cmsMacro] ([macroAlias])
2014-10-06 10:45:08,944 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 33: CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsMacroProperty_Alias] ON [cmsMacroProperty] ([macro],[macroPropertyAlias])
2014-10-06 10:45:08,959 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 34: ALTER TABLE [cmsMacroProperty] DROP CONSTRAINT [DF_cmsMacroProperty_macroPropertyHidden]
2014-10-06 10:45:08,959 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 35: ALTER TABLE [cmsMacroProperty] DROP COLUMN [macroPropertyHidden]
2014-10-06 10:45:08,959 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 36: ALTER TABLE [cmsMacroProperty] DROP CONSTRAINT [FK_cmsMacroProperty_cmsMacroPropertyType_id]
2014-10-06 10:45:08,959 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 37: ALTER TABLE [cmsMacroProperty] ADD [editorAlias] NVARCHAR(255) NOT NULL CONSTRAINT [DF_cmsMacroProperty_editorAlias] DEFAULT ('')
2014-10-06 10:45:08,975 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 38: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.MediaPicker' WHERE [macroPropertyType] = '3'
2014-10-06 10:45:08,975 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 39: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.ContentPickerAlias' WHERE [macroPropertyType] = '4'
2014-10-06 10:45:08,975 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 40: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.ContentPickerAlias' WHERE [macroPropertyType] = '5'
2014-10-06 10:45:08,975 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 41: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.ContentPickerAlias' WHERE [macroPropertyType] = '6'
2014-10-06 10:45:08,990 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 42: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.Integer' WHERE [macroPropertyType] = '13'
2014-10-06 10:45:08,990 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 43: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.TrueFalse' WHERE [macroPropertyType] = '14'
2014-10-06 10:45:08,990 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 44: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.Textbox' WHERE [macroPropertyType] = '16'
2014-10-06 10:45:08,990 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 45: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.ContentPickerAlias' WHERE [macroPropertyType] = '17'
2014-10-06 10:45:08,990 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 46: UPDATE [cmsMacroProperty] SET [editorAlias] = 'contentType' WHERE [macroPropertyType] = '18'
2014-10-06 10:45:09,006 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 47: UPDATE [cmsMacroProperty] SET [editorAlias] = 'contentTypeMultiple' WHERE [macroPropertyType] = '19'
2014-10-06 10:45:09,006 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 48: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.ContentPickerAlias' WHERE [macroPropertyType] = '20'
2014-10-06 10:45:09,006 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 49: UPDATE [cmsMacroProperty] SET [editorAlias] = 'tabPicker' WHERE [macroPropertyType] = '21'
2014-10-06 10:45:09,022 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 50: UPDATE [cmsMacroProperty] SET [editorAlias] = 'tabPickerMultiple' WHERE [macroPropertyType] = '22'
2014-10-06 10:45:09,022 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 51: UPDATE [cmsMacroProperty] SET [editorAlias] = 'propertyTypePicker' WHERE [macroPropertyType] = '23'
2014-10-06 10:45:09,022 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 52: UPDATE [cmsMacroProperty] SET [editorAlias] = 'propertyTypePickerMultiple' WHERE [macroPropertyType] = '24'
2014-10-06 10:45:09,022 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 53: UPDATE [cmsMacroProperty] SET [editorAlias] = 'Umbraco.TextboxMultiple' WHERE [macroPropertyType] = '25'
2014-10-06 10:45:09,037 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 54: ALTER TABLE [cmsMacroProperty] DROP COLUMN [macroPropertyType]
2014-10-06 10:45:09,037 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 55: ALTER TABLE [cmsMacroProperty] DROP CONSTRAINT [DF_cmsMacroProperty_editorAlias]
2014-10-06 10:45:09,037 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 56: DROP TABLE [cmsMacroPropertyType]
2014-10-06 10:45:09,069 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 57: ALTER TABLE [cmsTagRelationship] ADD [propertyTypeId] INTEGER NULL
2014-10-06 10:45:09,069 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 58: ALTER TABLE [cmsTagRelationship] DROP CONSTRAINT [FK_cmsTagRelationship_umbracoNode_id]
2014-10-06 10:45:09,069 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 59: ALTER TABLE [cmsTagRelationship] DROP CONSTRAINT [PK_cmsTagRelationship]
2014-10-06 10:45:09,069 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 60: ALTER TABLE [cmsTagRelationship] ALTER COLUMN [propertyTypeId] INTEGER NOT NULL
2014-10-06 10:45:09,084 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 61: ALTER TABLE [cmsTagRelationship] ADD CONSTRAINT [PK_cmsTagRelationship] PRIMARY KEY CLUSTERED ([nodeId], [propertyTypeId], [tagId])
2014-10-06 10:45:09,084 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 62: ALTER TABLE [cmsTagRelationship] ADD CONSTRAINT [FK_cmsTagRelationship_cmsPropertyType] FOREIGN KEY ([propertyTypeId]) REFERENCES [cmsPropertyType] ([id])
2014-10-06 10:45:09,084 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 63: ALTER TABLE [cmsTagRelationship] ADD CONSTRAINT [FK_cmsTagRelationship_cmsContent] FOREIGN KEY ([nodeId]) REFERENCES [cmsContent] ([nodeId])
2014-10-06 10:45:09,084 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 64: ALTER TABLE [cmsTags] ADD CONSTRAINT [FK_cmsTags_cmsTags] FOREIGN KEY ([ParentId]) REFERENCES [cmsTags] ([id])
2014-10-06 10:45:09,084 [8] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 21] Executing sql statement 65: CREATE NONCLUSTERED INDEX [IX_cmsTags] ON [cmsTags] ([tag],[group])
2014-10-06 10:45:09,194 [8] INFO Umbraco.Core.Persistence.UmbracoDatabase - [Thread 21] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()
2014-10-06 10:45:09,209 [8] ERROR Umbraco.Core.DatabaseContext - [Thread 21] Database configuration failed
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSeven.UpdateRelatedLinksData.UpdateRelatedLinksDataDo(Database database)
at Umbraco.Core.Persistence.Migrations.Syntax.Execute.Expressions.ExecuteCodeStatementExpression.Process(Database database)
at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database)
at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)
at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade)
at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData()
ClientConnectionId:2b311438-dc34-41ee-a094-eb90a6081309
Error Number:102,State:1,Class:15
2014-10-06 10:45:09,209 [8] INFO Umbraco.Core.DatabaseContext - [Thread 21] The database schema validation produced the following summary:
The following tables were found in the database, but are not in the current schema:
umbracoUserGroup,umbracoUser2userGroup,cmsMacroPropertyType,umbracoStylesheetProperty,Donations,Alumni,umbracoStatSession,umbracoContentData,umbracoContent,cmsContentTypes,umbracoContentAll,umbracoStatEntry,umbracoStylesheet
The following columns were found in the database, but are not in the current schema:
umbracoUserGroup,id,umbracoUserGroup,userGroupName,umbracoUser2userGroup,user,umbracoUser2userGroup,userGroup,cmsMacroPropertyType,id,cmsMacroPropertyType,macroPropertyTypeAlias,cmsMacroPropertyType,macroPropertyTypeRenderAssembly,cmsMacroPropertyType,macroPropertyTypeRenderType,cmsMacroPropertyType,macroPropertyTypeBaseType,umbracoStylesheetProperty,id,umbracoStylesheetProperty,stylesheetPropertyEditor,umbracoStylesheetProperty,stylesheet,umbracoStylesheetProperty,stylesheetPropertyAlias,umbracoStylesheetProperty,stylesheetPropertyName,umbracoStylesheetProperty,stylesheetPropertyValue,umbracoUser,userDefaultPermissions,umbracoUser,defaultToLiveEditing,Donations,pk_DonationID,Donations,CreatedDate,Donations,FirstName,Donations,LastName,Donations,Address,Donations,City,Donations,State,Donations,Zip,Donations,PhoneNumber,Donations,CardType,Donations,CardExpMonth,Donations,CardExpYear,Donations,Amount,Donations,Frequency,Donations,InHonorOfName,Donations,AcknowledgeName,Donations,AcknowledgeAddress,Donations,AcknowledgeCity,Donations,AcknowledgeState,Donations,AcknowledgeZip,Donations,RecurringBillingID,Alumni,PK_AlumniID,Alumni,isActive,Alumni,FirstName,Alumni,LastName,Alumni,Address,Alumni,City,Alumni,State,Alumni,Zip,Alumni,Phone,Alumni,Email,Alumni,Accomplishments,Alumni,Recent,Alumni,PhotoPath,Alumni,DateAdded,umbracoStatSession,id,umbracoStatSession,MemberId,umbracoStatSession,NewsletterId,umbracoStatSession,ReturningUser,umbracoStatSession,SessionStart,umbracoStatSession,SessionEnd,umbracoStatSession,Language,umbracoStatSession,UserAgent,umbracoStatSession,Browser,umbracoStatSession,BrowserVersion,umbracoStatSession,OperatingSystem,umbracoStatSession,Ip,umbracoStatSession,Referrer,umbracoStatSession,ReferrerKeyword,umbracoStatSession,allowCookies,umbracoStatSession,visitorId,umbracoStatSession,browserType,umbracoStatSession,isHuman,umbracoContentData,versionId,umbracoContentData,alias,umbracoContentData,content,umbracoContent,nodeID,umbracoContent,versionID,umbracoContent,show,umbracoContent,parentID,umbracoContent,nodeUser,umbracoContent,level,umbracoContent,sortOrder,umbracoContent,contentType,umbracoContent,templateNodeId,umbracoContent,documentUser,umbracoContent,language,umbracoContent,createdate,umbracoContent,updateDate,umbracoContent,releasedate,umbracoContent,expiredate,umbracoContent,path,umbracoContent,nodeName,umbracoContent,urlName,umbracoContent,versionUserName,umbracoContent,nodeUserName,umbracoContent,alias,umbracoContent,nodeTypeName,cmsMacroProperty,macroPropertyHidden,cmsMacroProperty,macroPropertyType,cmsContentTypes,id,cmsContentTypes,trashed,cmsContentTypes,parentID,cmsContentTypes,nodeUser,cmsContentTypes,level,cmsContentTypes,path,cmsContentTypes,sortOrder,cmsContentTypes,uniqueID,cmsContentTypes,text,cmsContentTypes,nodeObjectType,cmsContentTypes,createDate,cmsContentTypes,pk,cmsContentTypes,nodeId,cmsContentTypes,alias,cmsContentTypes,icon,cmsContentTypes,contentTypeNodeId,cmsContentTypes,templateNodeId,cmsContentTypes,IsDefault,umbracoContentAll,nodeID,umbracoContentAll,versionID,umbracoContentAll,show,umbracoContentAll,parentID,umbracoContentAll,nodeUser,umbracoContentAll,level,umbracoContentAll,sortOrder,umbracoContentAll,contentType,umbracoContentAll,templateNodeId,umbracoContentAll,documentUser,umbracoContentAll,language,umbracoContentAll,createdate,umbracoContentAll,releaseDate,umbracoContentAll,expireDate,umbracoContentAll,updateDate,umbracoContentAll,path,umbracoContentAll,nodeName,umbracoContentAll,urlName,umbracoContentAll,documentUserName,umbracoContentAll,nodeUserName,umbracoContentAll,alias,umbracoContentAll,nodeTypeName,cmsDataType,controlId,umbracoStatEntry,SessionId,umbracoStatEntry,EntryTime,umbracoStatEntry,RefNodeId,umbracoStatEntry,NodeId,umbracoStylesheet,nodeId,umbracoStylesheet,filename,umbracoStylesheet,content,cmsDataType,propertyEditorAlias,cmsMacroProperty,editorAlias,cmsTagRelationship,propertyTypeId
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_cmsContentVersion_cmsContent,FK_cmsContentXml_cmsContent,FK_cmsDataType_umbracoNode,FK_cmsDataTypePreValues_cmsDataType,FK_cmsDocument_cmsContent,FK_cmsDocument_cmsTemplate,FK_cmsDocument_umbracoNode,FK_cmsDocumentType_cmsContentType,FK_cmsDocumentType_cmsTemplate,FK_cmsDocumentType_umbracoNode,FK_cmsLanguageText_cmsDictionary,FK_cmsMacroProperty_cmsMacro,FK_cmsMacroProperty_cmsMacroPropertyType_id,FK_cmsMember_cmsContent,FK_cmsMember_umbracoNode,FK_cmsMember2MemberGroup_cmsMember,FK_cmsMember2MemberGroup_umbracoNode,FK_cmsMemberType_cmsContentType,FK_cmsMemberType_umbracoNode,FK_cmsPreviewXml_cmsContent,FK_cmsPreviewXml_cmsContentVersion,FK_cmsPropertyData_cmsPropertyType,FK_cmsPropertyData_umbracoNode,FK_cmsPropertyType_cmsContentType,FK_cmsPropertyType_cmsDataType,FK_cmsPropertyType_cmsTab,FK_cmsPropertyTypeGroup_cmsPropertyTypeGroup,FK_cmsStylesheet_umbracoNode,FK_cmsStylesheetProperty_umbracoNode,FK_cmsTagRelationship_umbracoNode_id,FK_cmsTask_cmsTaskType,FK_cmsTask_umbracoNode,FK_umbracoDomains_umbracoNode,FK_umbracoRelation_umbracoRelationType,FK_umbracoUser2app_umbracoUser,FK_umbracoUser2NodeNotify_umbracoNode,FK_umbracoUser2NodeNotify_umbracoUser,FK_umbracoUser2NodePermission_umbracoNode,FK_umbracoUser2NodePermission_umbracoUser,FK_user_userType,FK_user2userGroup_user,FK_user2userGroup_userGroup,FK_umbracoNode_umbracoNode_id,FK_cmsContent_umbracoNode_id,FK_cmsContentVersion_cmsContent_nodeId,FK_cmsDocument_cmsContent_nodeId,FK_cmsDocument_umbracoNode_id,FK_cmsDocument_cmsTemplate_nodeId,FK_cmsContentType_umbracoNode_id,FK_cmsDocumentType_cmsContentType_nodeId,FK_cmsDocumentType_umbracoNode_id,FK_cmsDocumentType_cmsTemplate_nodeId,FK_cmsDataType_umbracoNode_id,FK_cmsDataTypePreValues_cmsDataType_nodeId,FK_cmsLanguageText_cmsDictionary_id,FK_umbracoDomains_umbracoNode_id,FK_cmsMacroProperty_cmsMacro_id,FK_cmsMemberType_umbracoNode_id,FK_cmsMemberType_cmsContentType_nodeId,FK_cmsMember_umbracoNode_id,FK_cmsMember_cmsContent_nodeId,FK_cmsMember2MemberGroup_cmsMember_nodeId,FK_cmsMember2MemberGroup_umbracoNode_id,FK_cmsContentXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContentVersion_VersionId,FK_cmsPropertyTypeGroup_cmsPropertyTypeGroup_id,FK_cmsPropertyTypeGroup_cmsContentType_nodeId,FK_cmsPropertyType_cmsDataType_nodeId,FK_cmsPropertyType_cmsContentType_nodeId,FK_cmsPropertyType_cmsPropertyTypeGroup_id,FK_cmsPropertyData_umbracoNode_id,FK_cmsPropertyData_cmsPropertyType_id,FK_umbracoRelation_umbracoNode,FK_umbracoRelation_umbracoNode1,FK_cmsStylesheet_umbracoNode_id,FK_cmsTags_cmsTags,FK_cmsTagRelationship_cmsContent,FK_cmsTagRelationship_cmsTags_id,FK_cmsTagRelationship_cmsPropertyType,FK_umbracoUser_umbracoUserType_id,FK_cmsTask_cmsTaskType_id,FK_cmsTask_umbracoNode_id,FK_cmsContentType2ContentType_umbracoNode_parent,FK_cmsContentType2ContentType_umbracoNode_child,FK_umbracoUser2app_umbracoUser_id,FK_umbracoUser2NodeNotify_umbracoUser_id,FK_umbracoUser2NodeNotify_umbracoNode_id,FK_umbracoUser2NodePermission_umbracoUser_id,FK_umbracoUser2NodePermission_umbracoNode_id,PK_Alumni,PK_cmsTab,PK_ContentVersion,PK_domains,PK_Donations,PK_language,PK_macro,PK_macroProperty,PK_macroPropertyType,PK_stylesheetProperty,PK_templates,PK_umbracoStartSession,PK_umbracoStatEntry,PK_umbracoStylesheet,PK_user2userGroup,PK_userGroup,PK_userType,PK_cmsTemplate,PK_cmsContentVersion,PK_umbracoLanguage,PK_umbracoDomains,PK_cmsMacro,PK_cmsMacroProperty,PK_cmsPropertyTypeGroup,PK_umbracoUserType,IX_cmsContentVersion,IX_cmsDataType,IX_cmsDictionary,IX_cmsMemberType,IX_cmsTaskType,IX_cmsTemplate,IX_umbracoLanguage,IX_umbracoUser,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,IX_umbracoNodeObjectType,IX_cmsTemplate_nodeId,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsContentType_icon,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_Alias,IX_cmsPropertyData,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_cmsTags,IX_umbracoUserLogins_Index,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_computerName,IX_umbracoServer_isActive
The following indexes were found in the database, but are not in the current schema:
IX_Icon,IX_cmsContentVersion,IX_cmsDataType,IX_cmsDictionary,IX_cmsMemberType,IX_cmsTaskType,IX_cmsTemplate,IX_umbracoLanguage,IX_umbracoUser,IX_cmsTemplate_nodeId,IX_cmsContentVersion_VersionId,IX_cmsContentType_icon,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_Alias,IX_cmsTags,IX_umbracoUser_userLogin,IX_cmsTaskType_alias
The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
cmsTags_cmsTagRelationship,umbracoNode_cmsTagRelationship
2014-10-06 10:45:09,209 [8] ERROR Umbraco.Web.Install.Controllers.InstallApiController - [Thread 21] Installation step DatabaseUpgrade failed.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Incorrect syntax near ')'.
Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
2014-10-06 10:45:09,209 [8] INFO Umbraco.Web.Install.Controllers.InstallApiController - [Thread 21] Step completed (took 2819ms)
2014-10-06 10:45:09,209 [8] ERROR Umbraco.Web.Install.Controllers.InstallApiController - [Thread 21] An error occurred during installation step DatabaseUpgrade
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Incorrect syntax near ')'.
Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
I managed to fix the contraint issue for relations.
I checked to see if the id or parent id exists in the node table. If one of the ids cannot be found in the node table, then I removed the row from the relations table.
That fixed adding the contraint. Now I have
The ALTER TABLE statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "umbVYT2", table "dbo.umbracoNode", column 'id'
The following SQL command caused the error:
ALTER TABLE [dbo].[umbracoNode] ADD CONSTRAINT [FK_umbracoNode_umbracoNode_id] FOREIGN KEY ([parentID]) REFERENCES [dbo].[umbracoNode] ([id])
Edit: I fixed this by checking for a null id with a left join and deleting the rows. I ran into more contraint issues with the delete script. So I modified the cascade on delete for the foreign keys that had contraint errors.
I used this example from SO to find bad contraint data. Changed the tables/column names.
Now I'm back to this error: The database failed to upgrade. ERROR: The database configuration failed with the following message: Incorrect syntax near ')'. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
Looks directly related
http://issues.umbraco.org/issue/U4-4548
http://our.umbraco.org/forum/getting-started/installing-umbraco/55044-Database-Issue-(Very-Detailed)
Edit: I submitted my db to HQ.
I used the mostly schema matched 6.22. And Manually did the schema changes to cmstagrelationships (I don't think I had any), described in the ticket I posted above.
Then I started with a fresh 7.18 db. Used redgate to schema compare, move everything I can over.
I had to setup macroproperty types (all of them were "choose" textbox.
Then I had to drop and recreate my document types table. When I did that, document types were showing (got an error in Developer > doc types before).
Then I had to delete App_Data\Temp and App_Data\Umbraco.config.
I dropped and recreated the contextxml and previewxml tables.
Reset the app pool.
Everything looks published. Now getting navigation error and a weird publish error in the log.
See http://our.umbraco.org/forum/getting-started/installing-umbraco/57254-Umbraco-4-to-7-error-when-loading-node-content
Looks like it went away with:
http;//YOURDOMAIN/Umbraco/dialogs/republish.aspx?xml=true and clicking "republish".
Refresh the preview XML
is working on a reply...