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.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies