Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Tom Engan 430 posts 1173 karma points
    Aug 16, 2018 @ 08:29
    Tom Engan
    0

    Health Check, Data Integrity - Database Schema Validation: 53 WARN

    After upgrading from Umbraco v7.11.0 to v7.12.0, I immediately performed a health check:

     X    53 problems were detected with your database schema (Check the log for details).

    The message only applies to custom tables, or tables integrated from other packages.

    My App_Data/Logs/UmbracoTraceLog.WS12R2IISU.txt log file:

     2018-08-16 09:58:17,017 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Some errors were detected while validating the database schema against the current version of Umbraco.
 2018-08-16 09:58:17,017 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: HikingDestinations
 2018-08-16 09:58:17,017 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: NoZipCodes
 2018-08-16 09:58:17,018 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: perplexUmbracoMemberAccessLog
 2018-08-16 09:58:17,018 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: perplexUmbracoMemberLog
 2018-08-16 09:58:17,018 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: perplexUmbracoUserLog
 2018-08-16 09:58:17,019 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: Postnummer
 2018-08-16 09:58:17,019 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,Id
 2018-08-16 09:58:17,019 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,nodeId
 2018-08-16 09:58:17,020 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,SelectedHikingDestination
 2018-08-16 09:58:17,020 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,StartDate
 2018-08-16 09:58:17,020 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,HikingCode
 2018-08-16 09:58:17,021 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,NumberOfHikingDestinations
 2018-08-16 09:58:17,021 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,ActivityGrading
 2018-08-16 09:58:17,021 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,Mobile
 2018-08-16 09:58:17,022 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,ID
 2018-08-16 09:58:17,022 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,PostNr
 2018-08-16 09:58:17,022 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,Poststed
 2018-08-16 09:58:17,023 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,KommuneNr
 2018-08-16 09:58:17,023 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,Kommunenavn
 2018-08-16 09:58:17,023 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,Kategori
 2018-08-16 09:58:17,024 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,ImagePath
 2018-08-16 09:58:17,024 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,Id
 2018-08-16 09:58:17,024 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,MemberId
 2018-08-16 09:58:17,025 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,UserId
 2018-08-16 09:58:17,025 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,Timestamp
 2018-08-16 09:58:17,025 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,IpAddress
 2018-08-16 09:58:17,026 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,Action
 2018-08-16 09:58:17,030 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,Id
 2018-08-16 09:58:17,031 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,UserId
 2018-08-16 09:58:17,038 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,Date
 2018-08-16 09:58:17,038 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,IP
 2018-08-16 09:58:17,039 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,AuditAction
 2018-08-16 09:58:17,039 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,Url
 2018-08-16 09:58:17,040 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,Id
 2018-08-16 09:58:17,040 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,PerformingUserId
 2018-08-16 09:58:17,041 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,AffectedUserId
 2018-08-16 09:58:17,042 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,Username
 2018-08-16 09:58:17,042 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,AuditEvent
 2018-08-16 09:58:17,043 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,IpAddress
 2018-08-16 09:58:17,043 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,Timestamp
 2018-08-16 09:58:17,044 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,ID
 2018-08-16 09:58:17,044 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Postnummer
 2018-08-16 09:58:17,045 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Poststed
 2018-08-16 09:58:17,045 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Kommunenummer
 2018-08-16 09:58:17,046 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Kommunenavn
 2018-08-16 09:58:17,047 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Kategori
 2018-08-16 09:58:17,048 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_HikingDestinations__nodeId_cmsMember_nodeId
 2018-08-16 09:58:17,049 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_HikingDestination
 2018-08-16 09:58:17,050 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_NoZipCodes
 2018-08-16 09:58:17,050 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_perplexUmbracoMemberAccessLog
 2018-08-16 09:58:17,051 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_perplexUmbracoMemberLog
 2018-08-16 09:58:17,052 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_perplexUmbracoUserLog
 2018-08-16 09:58:17,052 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_Postnummer

    How can I fix these errors?

    Copy Link
  • Sebastiaan Janssen 5061 posts 15544 karma points MVP admin hq
    Aug 16, 2018 @ 08:48
    Sebastiaan Janssen
    0

    Seems fine, none of these are Umbraco tables.

    So the question is: how should Umbraco fix showing these errors? 😉

    Copy Link
  • Sebastiaan Janssen 5061 posts 15544 karma points MVP admin hq
    Aug 16, 2018 @ 08:50
    Sebastiaan Janssen
    1

    I've created an issue for it: http://issues.umbraco.org/issue/U4-11580

    Copy Link
  • Tom Engan 430 posts 1173 karma points
    Aug 16, 2018 @ 08:55
    Tom Engan
    0

    Health Check on Database Schedule Validation appears to be new in version 7.12.0, so it's just fine that you created an issue. I suppose customs tables work just as well as before (will of course be tested..).

    Copy Link
  • Umbraco Newbie 22 posts 124 karma points
    Sep 25, 2018 @ 21:08
    Umbraco Newbie
    2

    Hi

    Just upgraded to Umbraco version 7.12.3 assembly: 1.0.6837.12334 and can confirm this is still an issue with custom tables.

    I have a custom table that stores 120,000 IMEI numbers on a customers website allowing customers to search for their phone. Don't really want to store them in Umbraco so a custom table works fine, but this is flagged up in the back office when doing a health check.

    Does not appear to affect performance

    Copy Link
  • Thomas 160 posts 335 karma points
    Oct 08, 2018 @ 08:27
    Thomas
    0

    I just upgrade my site from v7.5.11 to v7.12.3 and i am facing the same issue. 81 errors which are the followings...

    2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Some errors were detected while validating the database schema against the current version of Umbraco. 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: CMUmbracoToolsSettings 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: CMUmbracoToolsPermanentRedirects 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecords 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordFields 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataString 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataLongString 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataInteger 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataBit 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataDateTime 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFUserSecurity 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFUserFormSecurity 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsSettings,SettingID 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsSettings,Application 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsSettings,Name 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsSettings,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsPermanentRedirects,PermanentRedirectID 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsPermanentRedirects,OriginalURL 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsPermanentRedirects,RedirectURL 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsPermanentRedirects,Notes 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Form 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Created 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Updated 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,CurrentPage 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,UmbracoPageId 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,IP 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,MemberKey 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,UniqueId 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,State 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,RecordData 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,FieldId 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Record 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Alias 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,DataType 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,User 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageDataSources 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManagePreValueSources 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageWorkflows 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageForms 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,Id 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,User 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,Form 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,HasAccess 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,AllowInEditor 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,SecurityType 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdatabitrecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdatadatetimerecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdataintegerrecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdatalongstringrecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdatastringrecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Unknown: Id 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataBitUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataDateTimeUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataIntegerUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataLongStringUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataStringUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKCMUmbracoToolsPermanentRedirects 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKCMUmbracoToolsSettings 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataBit 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataDateTime 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataInteger 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataLongString 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataString 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordFields 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecords

    Copy Link
  • Andreas 7 posts 77 karma points
    Dec 03, 2018 @ 10:03
    Andreas
    0

    I just updated to Umbraco 7.12.1 and I got 22 errors as well, but this seems to be umbraco tables/fields.

    2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Some errors were detected while validating the database schema against the current version of Umbraco. 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKumbracoRedirectUrl 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentcmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentVersioncmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentcmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentcmsTemplatenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentTypecmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentTypecmsTemplatenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDataTypePreValuescmsDataTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDictionarycmsDictionarayid 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsLanguageTextcmsDictionaryid 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsMemberTypecmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsMembercmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentXmlcmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPreviewXmlcmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPreviewXmlcmsContentVersionVersionId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypeGroupcmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypecmsDataTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypecmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsTagRelationshipcmsContent 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentTypeAllowedContentTypecmsContentType 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentTypeAllowedContentTypecmsContentType1 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKumbracoRedirectUrlumbracoNode_uniqueID

    Copy Link

  • 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