Copied to clipboard

Flag this post as spam?

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


  • Karl Kopp 121 posts 227 karma points
    Jul 26, 2016 @ 09:32
    Karl Kopp
    0

    Error migrating from 7.2.2 -> 7.5 beta 2 - cmsStylesheetProperty invalid object name

    I have an Umbraco 7.2.2 install and I'm upgrading to 7.5.0 beta 2. During the upgrade process, the table 'umbracoMigration' wasn't found and caused the installer to error. I manually created that table, and now I get the below error. Any ideas?

    PS - the new forum editor doesn't rock and formatting large slabs of text :(

    2016-07-26 19:01:30,988 [12] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 161: ALTER TABLE [umbracoDeployDependency] ADD CONSTRAINT [FKumbracoDeployDependencyumbracoDeployChecksum_id2] FOREIGN KEY ([targetId]) REFERENCES [umbracoDeployChecksum] ([id])

    2016-07-26 19:01:30,989 [12] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 162: ALTER TABLE [umbracoDeployDependency] ADD CONSTRAINT [PK_umbracoDeployDependency] PRIMARY KEY CLUSTERED ([sourceId], [targetId])

    2016-07-26 19:01:30,992 [12] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 163: CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoDeployChecksum] ON [umbracoDeployChecksum] ([entityType],[entityGuid],[entityPath])

    2016-07-26 19:01:30,993 [12] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 164: DELETE FROM [cmsStylesheetProperty] WHERE 1 = 1

    2016-07-26 19:01:30,994 [12] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Database exception occurred System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'cmsStylesheetProperty'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>cDisplayClass1.0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database) at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) ClientConnectionId:df6fec3e-ce7b-4a0a-b354-39b6d98194ee Error Number:208,State:1,Class:16 2016-07-26 19:01:31,010 [12] ERROR Umbraco.Core.DatabaseContext - Database configuration failed System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'cmsStylesheetProperty'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) 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.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService) ClientConnectionId:df6fec3e-ce7b-4a0a-b354-39b6d98194ee Error Number:208,State:1,Class:16 2016-07-26 19:01:31,011 [12] INFO Umbraco.Core.DatabaseContext - The database schema validation produced the following summary: The following tables were found in the database, but are not in the current schema: UFRecordDataInteger,UFRecordDataLongString,UFRecordDataString,UFRecordFields,UFRecords,UFRecordsXml,UFSettings,UFUserFormSecurity,UFUserSecurity,UFWorkflowExecutionStates,UFWorkflows,UFWorkflowsToForms,umbracoUserLogins,CMSImportCustomRelation,CMSImportMediaRelation,CMSImportRelation,CMSImportScheduledItems,CMSImportScheduledTask,CMSImportState,cmsStylesheet,cmsStylesheetProperty,icUrlTracker,UFDataSourceMappings,UFDataSources,UFFieldConditionRules,UFFieldConditions,UFFields,UFFieldsets,UFFieldSettings,UFForms,UFFormStates,UFPages,UFPrevalues,UFPrevalueSources,UFPrevalueSourceSettings,UFRecordDataBit,UFRecordDataDateTime,umbracoAccess,umbracoAccessRule,umbracoCacheInstruction,umbracoExternalLogin,umbracoDeployChecksum,umbracoDeployDependency,umbracoRedirectUrl

    The following columns were found in the database, but are not in the current schema: UFRecordDataInteger,Id,UFRecordDataInteger,Key,UFRecordDataInteger,Value,UFRecordDataLongString,Id,UFRecordDataLongString,Key,UFRecordDataLongString,Value,UFRecordDataString,Id,UFRecordDataString,Key,UFRecordDataString,Value,UFRecordFields,Key,UFRecordFields,Field,UFRecordFields,Record,UFRecordFields,DataType,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,State,UFRecords,currentPage,UFRecords,umbracoPageId,UFRecords,IP,UFRecords,MemberKey,UFRecordsXml,id,UFRecordsXml,Form,UFRecordsXml,xml,UFRecordsXml,created,UFRecordsXml,Page,UFSettings,Id,UFSettings,Key,UFSettings,Value,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,SecurityType,UFUserFormSecurity,AllowInEditor,UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,UFWorkflowExecutionStates,Workflow,UFWorkflowExecutionStates,State,UFWorkflowExecutionStates,Form,UFWorkflows,Id,UFWorkflows,Name,UFWorkflows,Type,UFWorkflows,SortOrder,UFWorkflows,Active,UFWorkflows,Form,UFWorkflows,ExecutesOn,UFWorkflowsToForms,Workflow,UFWorkflowsToForms,Form,cmsContentVersion,LanguageLocale,umbracoUserLogins,contextID,umbracoUserLogins,userID,umbracoUserLogins,timeout,CMSImportCustomRelation,CustomRelationId,CMSImportCustomRelation,UmbracoId,CMSImportCustomRelation,Alias,CMSImportCustomRelation,DataSourceKey,CMSImportCustomRelation,RelatedId,CMSImportMediaRelation,Id,CMSImportMediaRelation,UmbracoMediaId,CMSImportMediaRelation,SourceUrl,CMSImportRelation,Id,CMSImportRelation,UmbracoID,CMSImportRelation,UmbracoParentId,CMSImportRelation,DataSourceKey,CMSImportScheduledItems,ScheduledItemId,CMSImportScheduledItems,ScheduleldTaskId,CMSImportScheduledItems,ScheduledOn,CMSImportScheduledItems,ExecutedOn,CMSImportScheduledItems,InProgress,CMSImportScheduledTask,ScheduleId,CMSImportScheduledTask,ScheduleGUID,CMSImportScheduledTask,ImportStateGUID,CMSImportScheduledTask,ScheduledTaskName,CMSImportScheduledTask,NotifyEmailAddress,CMSImportScheduledTask,ExecuteEvery,CMSImportScheduledTask,ExecuteDays,CMSImportScheduledTask,ExecuteHour,CMSImportScheduledTask,ExecuteMinute,CMSImportScheduledTask,ImportAsUser,CMSImportState,Id,CMSImportState,UniqueIdentifier,CMSImportState,Name,CMSImportState,ImportType,CMSImportState,ImportState,CMSImportState,Recursive,CMSImportState,Parent,cmsPropertyType,helpText,cmsPropertyTypeGroup,parentGroupId,cmsStylesheet,nodeId,cmsStylesheet,filename,cmsStylesheet,content,cmsStylesheetProperty,nodeId,cmsStylesheetProperty,stylesheetPropertyEditor,cmsStylesheetProperty,stylesheetPropertyAlias,cmsStylesheetProperty,stylesheetPropertyValue,cmsTemplate,master,icUrlTracker,Id,icUrlTracker,OldUrl,icUrlTracker,OldUrlQueryString,icUrlTracker,OldRegex,icUrlTracker,RedirectRootNodeId,icUrlTracker,RedirectNodeId,icUrlTracker,RedirectUrl,icUrlTracker,RedirectHttpCode,icUrlTracker,RedirectPassThroughQueryString,icUrlTracker,Notes,icUrlTracker,Is404,icUrlTracker,Referrer,icUrlTracker,Inserted,icUrlTracker,ForceRedirect,UFDataSourceMappings,DataSource,UFDataSourceMappings,DataSourceField,UFDataSourceMappings,Form,UFDataSourceMappings,PrevalueTable,UFDataSourceMappings,PrevalueKeyField,UFDataSourceMappings,PrevalueValueField,UFDataSourceMappings,DataType,UFDataSourceMappings,DefaultValue,UFDataSources,Id,UFDataSources,Type,UFDataSources,Name,UFFieldConditionRules,Id,UFFieldConditionRules,FieldCondition,UFFieldConditionRules,Field,UFFieldConditionRules,Operator,UFFieldConditionRules,Value,UFFieldConditions,Id,UFFieldConditions,Field,UFFieldConditions,Enabled,UFFieldConditions,ActionType,UFFieldConditions,LogicType,UFFields,Id,UFFields,Fieldset,UFFields,Fieldtype,UFFields,PreValueProvider,UFFields,RegEx,UFFields,Mandatory,UFFields,SortOrder,UFFields,Caption,UFFields,DataSourceField,UFFields,ToolTip,UFFields,DefaultValue,UFFields,RequiredErrorMessage,UFFields,InvalidErrorMessage,UFFieldsets,Id,UFFieldsets,Page,UFFieldsets,SortOrder,UFFieldsets,Caption,UFFieldSettings,Field,UFFieldSettings,Key,UFFieldSettings,Value,UFForms,Id,UFForms,Name,UFForms,Created,UFForms,ManualApproval,UFForms,GotoPageOnSubmit,UFForms,MessageOnSubmit,UFForms,DataSource,UFForms,ShowValidationSummary,UFForms,HideFieldValidation,UFForms,RequiredErrorMessage,UFForms,InvalidErrorMessage,UFForms,FieldIndicationType,UFForms,Indicator,UFForms,Archived,UFForms,StoreRecordsLocally,UFForms,DisableDefaultStylesheet,UFForms,Entries,UFForms,Views,UFFormStates,State,UFPages,Id,UFPages,Form,UFPages,SortOrder,UFPages,Caption,UFPrevalues,Id,UFPrevalues,Field,UFPrevalues,Value,UFPrevalues,SortOrder,UFPrevalueSources,Id,UFPrevalueSources,Name,UFPrevalueSources,Type,UFPrevalueSourceSettings,PrevalueProvider,UFPrevalueSourceSettings,Key,UFPrevalueSourceSettings,Value,UFRecordDataBit,Id,UFRecordDataBit,Key,UFRecordDataBit,Value,UFRecordDataDateTime,Id,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,cmsPropertyTypeGroup,uniqueID,cmsPropertyType,UniqueID,cmsPropertyData,dataDecimal,umbracoUser,securityStampToken,umbracoUser,failedLoginAttempts,umbracoUser,lastLockoutDate,umbracoUser,lastPasswordChangeDate,umbracoUser,lastLoginDate,umbracoServer,isMaster,umbracoAccess,id,umbracoAccess,nodeId,umbracoAccess,loginNodeId,umbracoAccess,noAccessNodeId,umbracoAccess,createDate,umbracoAccess,updateDate,umbracoAccessRule,id,umbracoAccessRule,accessId,umbracoAccessRule,ruleValue,umbracoAccessRule,ruleType,umbracoAccessRule,createDate,umbracoAccessRule,updateDate,umbracoCacheInstruction,id,umbracoCacheInstruction,utcStamp,umbracoCacheInstruction,jsonInstruction,umbracoCacheInstruction,originated,umbracoExternalLogin,id,umbracoExternalLogin,userId,umbracoExternalLogin,loginProvider,umbracoExternalLogin,providerKey,umbracoExternalLogin,createDate,umbracoDeployChecksum,id,umbracoDeployChecksum,entityType,umbracoDeployChecksum,entityGuid,umbracoDeployChecksum,entityPath,umbracoDeployChecksum,localChecksum,umbracoDeployChecksum,compositeChecksum,umbracoDeployDependency,sourceId,umbracoDeployDependency,targetId,umbracoDeployDependency,mode,umbracoRedirectUrl,id,umbracoRedirectUrl,contentKey,umbracoRedirectUrl,createDateUtc,umbracoRedirectUrl,url,umbracoRedirectUrl,urlHash

    The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: FKcmsPropertyTypeGroupcmsPropertyTypeGroupid,FKcmsStylesheetumbracoNodeid,FKcmsTemplatecmsTemplate,FKUFDataSourceMappingsUFDataSources,FKUFDataSourceMappingsUFForms,FKUFFieldUFFieldsets,FKUFFieldConditionRulesUFFieldConditions,FKUFFieldConditionRulesUFFields,FKUFFieldConditionsUFFields,FKUFFieldsetsUFPages,FKUFFieldSettingsUFFields,FKUFFormsUFDataSources,FKUFPagesUFForms,FKUFPrevaluesUFFields,FKUFPrevalueSettingsUFPrevalueProviders,FKUFRecordDataBitUFRecordFields,FKUFRecordDataDateTimeUFRecordFields,FKUFRecordDataIntegerUFRecordFields,FKUFRecordDataLongStringUFRecordFields,FKUFRecordDataStringUFRecordFields,FKUFRecordFieldsUFFields,FKUFRecordFieldsUFRecords,FKUFRecordsUFForms,FKUFRecordsXmlUFForms,FKUFUserFormSecurityUFForms,FKUFWorkflowExecutionStatesUFFormStates,FKUFWorkflowsUFForms,FKcmsDictionarycmsDictionaryid,FKcmsLanguageTextumbracoLanguageid,FKumbracoAccessumbracoNodeid,FKumbracoAccessumbracoNodeid1,FKumbracoAccessumbracoNodeid2,FKumbracoAccessRuleumbracoAccessid,FKumbracoDeployDependencyumbracoDeployChecksumid1,FKumbracoDeployDependencyumbracoDeployChecksumid2,FKumbracoRedirectUrlumbracoNodeuniqueID,PKCMSImportCustomRelation,PKCMSImportMediaRelation,PKCMSImportRelation,PKCMSImportScheduledItems,PKCMSImportScheduledTask,PKCMSImportState,PKcmsStylesheet,PKcmsStylesheetProperty,PKicUrlTracker,PKUFDataSourceMappings,PKUFDataSources,PKUFField,PKUFFieldConditionRules,PKUFFieldConditions,PKUFFieldsets,PKUFForms,PKUFFormStates,PKUFPages,PKUFPrevalueProviders,PKUFPrevalues,PKUFPrevalueSettings,PKUFRecordDataBit,PKUFRecordDataDateTime,PKUFRecordDataInteger,PKUFRecordDataLongString,PKUFRecordDataString,PKUFRecordFields,PKUFRecords,PKUFRecordsXml,PKUFSettings,PKUFUserFormSecurity,PKUFUserSecurity,PKUFWorkflowExecutionStates,PKUFWorkflows,PKUFWorkflowsToForms,PKumbracoAccess,PKumbracoAccessRule,PKumbracoCacheInstruction,PKumbracoExternalLogin,PKumbracoMigration,PKumbracoDeployChecksum,PKumbracoDeployDependency,PKumbracoRedirectUrl,IXumbracoNodeTrashed,IXumbracoNodeParentId,IXumbracoNodeUniqueID,IXumbracoNodeObjectType,IXcmsContentType,IXcmsContentTypeicon,IXcmsTemplatenodeId,IXcmsContent,IXcmsContentVersionContentId,IXcmsContentVersionVersionId,IXcmsDocument,IXcmsDocumentpublished,IXcmsDocumentnewest,IXcmsDataTypenodeId,IXcmsDictionaryid,IXumbracoLanguagelanguageISOCode,IXumbracoLog,IXcmsMacroPropertyAlias,IXcmsMacroPropertyAlias,IXcmsPropertyTypeGroupUniqueID,IXcmsPropertyTypeUniqueID,IXcmsPropertyData,IXcmsPropertyData1,IXcmsPropertyData2,IXcmsPropertyData3,IXcmsTags,IXumbracoUseruserLogin,IXcmsTaskTypealias,IXcomputerName,IXumbracoServerisActive,IXumbracoAccessnodeId,IXumbracoAccessRule,IXumbracoMigration,IXumbracoDeployChecksum,IXumbracoRedirectUrl

    The following indexes were found in the database, but are not in the current schema: IXicUrlTracker,UFFieldSettingsIndex,IXumbracoUserLoginsIndex,IXcmsPropertyTypeGroupUniqueID,IXcmsPropertyTypeUniqueID,IXumbracoAccessnodeId,IXumbracoAccessRule,IXumbracoMigration,IXumbracoDeployChecksum,IXumbracoRedirectUrl

  • Karl Kopp 121 posts 227 karma points
    Jul 26, 2016 @ 22:36
    Karl Kopp
    0

    There is now a fix thanks to @seb. See details here.

Please Sign in or register to post replies

Write your reply to:

Draft