Copied to clipboard

Flag this post as spam?

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


  • Roger Jarl 22 posts 115 karma points
    Aug 27, 2018 @ 12:28
    Roger Jarl
    0

    Database Integrity Health Check and Umbraco Forms

    After upgrading to Umbraco 7.12.1, I get these errors in my log when I ran the Database Integrity Health Check. It's from one of my sites where I have Umbraco Forms 6.0.6 is installed. How do I fix these errors?

         2018-08-27 14:15:10,381 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Some errors were detected while validating the database schema against the current version of Umbraco.
     2018-08-27 14:15:10,381 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecords
     2018-08-27 14:15:10,381 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordFields
     2018-08-27 14:15:10,381 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataString
     2018-08-27 14:15:10,381 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataLongString
     2018-08-27 14:15:10,382 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataInteger
     2018-08-27 14:15:10,382 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataBit
     2018-08-27 14:15:10,382 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataDateTime
     2018-08-27 14:15:10,382 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFUserSecurity
     2018-08-27 14:15:10,382 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFUserFormSecurity
     2018-08-27 14:15:10,382 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Id
     2018-08-27 14:15:10,382 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Form
     2018-08-27 14:15:10,382 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Created
     2018-08-27 14:15:10,383 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Updated
     2018-08-27 14:15:10,383 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,CurrentPage
     2018-08-27 14:15:10,383 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,UmbracoPageId
     2018-08-27 14:15:10,383 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,IP
     2018-08-27 14:15:10,383 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,MemberKey
     2018-08-27 14:15:10,383 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,UniqueId
     2018-08-27 14:15:10,384 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,State
     2018-08-27 14:15:10,384 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,RecordData
     2018-08-27 14:15:10,384 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Key
     2018-08-27 14:15:10,384 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,FieldId
     2018-08-27 14:15:10,384 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Record
     2018-08-27 14:15:10,384 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Alias
     2018-08-27 14:15:10,384 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,DataType
     2018-08-27 14:15:10,385 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Id
     2018-08-27 14:15:10,385 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Key
     2018-08-27 14:15:10,385 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Value
     2018-08-27 14:15:10,385 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Id
     2018-08-27 14:15:10,385 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Key
     2018-08-27 14:15:10,385 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Value
     2018-08-27 14:15:10,385 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Id
     2018-08-27 14:15:10,385 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Key
     2018-08-27 14:15:10,385 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Value
     2018-08-27 14:15:10,386 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Id
     2018-08-27 14:15:10,386 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Key
     2018-08-27 14:15:10,386 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Value
     2018-08-27 14:15:10,386 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Id
     2018-08-27 14:15:10,386 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Key
     2018-08-27 14:15:10,386 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Value
     2018-08-27 14:15:10,386 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,User
     2018-08-27 14:15:10,387 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageDataSources
     2018-08-27 14:15:10,387 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManagePreValueSources
     2018-08-27 14:15:10,387 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageWorkflows
     2018-08-27 14:15:10,387 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageForms
     2018-08-27 14:15:10,387 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,Id
     2018-08-27 14:15:10,387 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,User
     2018-08-27 14:15:10,387 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,Form
     2018-08-27 14:15:10,387 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,HasAccess
     2018-08-27 14:15:10,387 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,AllowInEditor
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,SecurityType
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_databit_recordfield
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_datadatetime_recordfield
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_datainteger_recordfield
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_datalongstring_recordfield
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_datastring_recordfield
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Unknown: Id
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataBit_UFRecordFields_Key
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataDateTime_UFRecordFields_Key
     2018-08-27 14:15:10,388 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataInteger_UFRecordFields_Key
     2018-08-27 14:15:10,389 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataLongString_UFRecordFields_Key
     2018-08-27 14:15:10,389 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataString_UFRecordFields_Key
     2018-08-27 14:15:10,389 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataBit
     2018-08-27 14:15:10,389 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataDateTime
     2018-08-27 14:15:10,389 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataInteger
     2018-08-27 14:15:10,389 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataLongString
     2018-08-27 14:15:10,389 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataString
     2018-08-27 14:15:10,389 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordFields
     2018-08-27 14:15:10,390 [P2544/D2/T7] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecords
    
  • Dave Woestenborghs 3504 posts 12134 karma points MVP 9x admin c-trib
    Aug 27, 2018 @ 12:33
    Dave Woestenborghs
    100

    Hi Roger,

    This is a known issue : http://issues.umbraco.org/issue/U4-11580

    This health check was introduced in 7.12 but it checks all tables in your database, while it should only check the ones for Umbraco CMS.

    Here is another post about it : https://our.umbraco.com/forum/using-umbraco-and-getting-started/93290-health-check-database-schema-validation-error

    Dave

Please Sign in or register to post replies

Write your reply to:

Draft