Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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
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
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
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?
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
is working on a reply...