Copied to clipboard

Flag this post as spam?

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


  • Peter S 169 posts 587 karma points
    Sep 25, 2015 @ 14:16
    Peter S
    0

    Strange log several times a minute

    I just noticed that this line occurs in the logs of our site and it's been printed several times a minute since a few months back. There's no page 1393 in the database and it's never mentioned in any code. Any suggestions how to find out what's causing this?

    2015-09-25 14:13:12,344 [7] WARN Umbraco.Web.Routing.DefaultUrlProvider - [Thread 22] Couldn't find any page with nodeId=1393. This is most likely caused by the page not being published.

  • Mark Bowser 273 posts 860 karma points c-trib
    Sep 25, 2015 @ 17:46
    Mark Bowser
    100

    We see this sometimes when clients create "locallinks" in rich text editors. I think it can also happen with pickers. If the node being linked to is broken, you will get that warning in the logs. It is a little bit tricky to track down all of the culprits.

    Here is a query you can run on the database to find the nodes that have the broken references. This query basically searches through all of the node data looking for references to 1393. I added some JOINs to cmsContentVersion so that you will only be searching on the latest node data. You can remove those if you think the query might be missing something.

    SELECT TOP 1000  n.id
                    ,n.[text]
                    ,n.[path]
                    ,pt.Alias
                    ,pd.dataInt
                    ,pd.dataDate
                    ,pd.dataNvarchar
                    ,pd.dataNText
                    ,cv.VersionDate
    FROM cmsPropertyData pd
    INNER JOIN cmsPropertyType pt
        ON pt.id = pd.propertytypeid
    INNER JOIN umbracoNode n
        ON n.id = pd.contentNodeId
    INNER JOIN cmsContentVersion cv
        ON cv.VersionId = pd.versionId
    INNER JOIN (SELECT cv_inner.ContentId
                      ,MAX(cv_inner.VersionDate) VersionDate
                FROM cmsContentVersion cv_inner
                GROUP BY cv_inner.ContentId) cv_top
        ON cv_top.ContentId = cv.ContentId AND (cv_top.VersionDate = cv.VersionDate)
    WHERE pd.dataInt = 1393
       OR pd.dataNvarchar LIKE '%1393%'
       OR pd.dataNtext LIKE '%1393%'
    

    Hope it helps!

  • Nicholas Westby 2054 posts 7100 karma points c-trib
    Sep 25, 2015 @ 19:59
    Nicholas Westby
    0

    Is that a node in the recycle bin?

  • Mark Bowser 273 posts 860 karma points c-trib
    Sep 25, 2015 @ 21:49
    Mark Bowser
    0

    Nicholas,

    Last time I saw this, it was because of broken locallinks in the rich text editor. The client had picked some content to link to. Then, months later, they completely deleted the node that was linked to. It wasn't in the recycle bin. I would search the umbracoNode table for any node with the id and couldn't find it. The problem was that the locallink was still stored a link in the rich text.

    It would be kind of neat to fix that log message in umbraco, so it would report which page was trying to link to the deleted node.

  • Peter S 169 posts 587 karma points
    Sep 28, 2015 @ 06:40
    Peter S
    0

    Mark,

    That did the trick! Thanks! I would never had thought of that.

Please Sign in or register to post replies

Write your reply to:

Draft