Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Robert 20 posts 39 karma points
    Oct 04, 2014 @ 02:04
    Robert
    0

    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')

  • Robert 20 posts 39 karma points
    Oct 06, 2014 @ 18:50
    Robert
    0

    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])

  • Robert 20 posts 39 karma points
    Oct 06, 2014 @ 19:46
    Robert
    0

    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)

  • Robert 20 posts 39 karma points
    Oct 06, 2014 @ 20:51
    Robert
    0

    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.

    DELETE items FROM items leftjoin items as parent on items.parentID = parent.itemID WHERE parent.itemID isNULL
  • Robert 20 posts 39 karma points
    Oct 06, 2014 @ 22:03
    Robert
    0

    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

    http;//YOURDOMAIN/Umbraco/dialogs/republish.aspx?previews=true and clicking "republish".  
Please Sign in or register to post replies

Write your reply to:

Draft