The 2 errors can be found by translating the checkContent code into SQL:
var subQuery = new Sql()
.Select("DISTINCT cmsContentXml.nodeId")
.From<ContentXmlDto>(_sqlSyntax)
.InnerJoin<DocumentDto>(_sqlSyntax)
.On<DocumentDto, ContentXmlDto>(_sqlSyntax, left => left.NodeId, right => right.NodeId);
Not sure what the .On() does. But pretty sure it has to do with the inner join. :)
XML Data Integrity - ContentXml won't fix
I've been trying to use the Umbraco Api in order to access content. However when I access the API i get an error saying the XML is invalid.
On checking the health check features in the new Umbraco it says I have two invalid entries as shown in the image below:
Is there a quick way to find these errors as I have over 3000+ rows in the cmsContentXml table.
Note this was originally running on Umbraco 4 before being upgraded to 7.5.2
NOTE: What i forgot to mention is that selecting the fix button doesn't correct the issue.
I don't know if it's the same cause I had but I had the same issue http://issues.umbraco.org/issue/U4-8911
I have cleared out the recycle bin but still produces same error. Thanks for your efforts though
Actually fixed this. Just manually delete all values in the cmsContentXml table and this will force it to properly generate a new valid XML
The 2 errors can be found by translating the checkContent code into SQL:
Not sure what the .On() does. But pretty sure it has to do with the inner join. :)
is working on a reply...