Copied to clipboard

Flag this post as spam?

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


  • stephanie 52 posts 133 karma points
    Jul 04, 2014 @ 17:32
    stephanie
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft