It lists a query to run to see if there are "bad characters" in the content:
select distinct contentNodeId, path, text from cmsPropertyData inner join umbracoNode on umbracoNode.id = cmsPropertyData.contentNodeId where dataNtext like '%%'
I have over a thousand rows returned -- does this mean there's junk in my db that needs cleaning out? I am having issues with the media tree loading/backend office slowness. The log files have row after row of warning "Couldn't find any page with node id...." I'm using 6.0.3 (I believe), with Ublogsy.
Question about a query listed on a "how-to" page in Umbraco documentation
On this page:
http://our.umbraco.org/wiki/how-tos/fix-odd-publishing-problems
It lists a query to run to see if there are "bad characters" in the content:
select distinct contentNodeId, path, text
from cmsPropertyData
inner join umbracoNode on umbracoNode.id = cmsPropertyData.contentNodeId
where dataNtext like '%%'
I have over a thousand rows returned -- does this mean there's junk in my db that needs cleaning out? I am having issues with the media tree loading/backend office slowness. The log files have row after row of warning "Couldn't find any page with node id...." I'm using 6.0.3 (I believe), with Ublogsy.
Thanks! Steph
is working on a reply...