Copied to clipboard

Flag this post as spam?

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


  • Bluegrass Digital 17 posts 68 karma points
    Feb 03, 2017 @ 12:45
    Bluegrass Digital
    0

    Xml Cache Data Integrity - cmsContentXml error

    We've recently noticed that one of our sites running on Umbraco V7.3.5 is having problems displaying certain images stored in the CMS's media section. We've also noticed that there seems to be a problem with the Xml Cache Data Integrity (https://gyazo.com/7e5d24d5dcd02f9deb007aa26cdde708) and when attempting the cmsContentXml table fix it throws the following error "System.Data.SqlClient.SqlException (0x80131904): Cannot resolve the collation conflict between "Latin1GeneralCIAS" and "SQLLatin1GeneralCP1CIAS" in the equal to operation."

    Can someone please urgently provide some guidance on how to resolve this as there sees to be no related information anywhere.

  • Dave Woestenborghs 3504 posts 12134 karma points MVP 9x admin c-trib
    Feb 04, 2017 @ 10:22
    Dave Woestenborghs
    100

    Hi Bluegrass,

    I have seen similar issues where we restored a database on another server that had different collation than the server that the backup was created on.

    Could that be the case ?

    dave

Please Sign in or register to post replies

Write your reply to:

Draft