Sign in Register
Go to solution
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
    Copy Link
  • Dave Woestenborghs 3504 posts 12135 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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft