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.
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.
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
is working on a reply...