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.
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%'
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.
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.
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 tocmsContentVersion
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.Hope it helps!
Is that a node in the recycle bin?
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.
Mark,
That did the trick! Thanks! I would never had thought of that.
is working on a reply...