6 R2 SQL-script: Fetching data on a page to itself will cause app

6 R2 SQL-script: Fetching data on a page to itself will cause application to crash

Johan Kronberg

Vote:

There's a SQL script that identifies this problem in these posts:

http://world.episerver.com/Modules/Forum/Pages/Thread.aspx?id=35632&epslanguage=en

http://world.episerver.com/Modules/Forum/Pages/thread.aspx?id=31982

Would this be a correct equivalent in CMS 6 R2?

SELECT T1.PageGUID, T1.PageLinkGUID
FROM dbo.tblPageLanguage T1
INNER JOIN (
	SELECT PageGUID, PageLinkGUID
	FROM dbo.tblPageLanguage T
	WHERE T.PageLinkGUID IS NOT NULL
) AS T2
ON T1.PageGUID = t2.PageLinkGUID
AND T1.PageLinkGUID = T2.PageGUID
AND t1.PageLinkGUID IS NOT NULL

#61661

Sep 26, 2012 15:37

Per Nergård

Vote:

I was under the impression that this was no longer an issue in r2. I have a check for this in global asax that prevent this kind of circular references. I can give it to you if you want.

#62002

Oct 09, 2012 18:42

Fredrik Söderberg

Vote:

You can use this script to identify the pages that has a circular reference to itself.

SELECT PageLanguage.PageLinkGUID as pageguid, PageLanguage.fkPageID
FROM dbo.tblPageLanguage as PageLanguage

INNER JOIN (
SELECT pkId, PageGUID
FROM dbo.tblPage Page
WHERE Page.PageGUID IS NOT NULL
) AS Page
ON Page.pkID = PageLanguage.fkPageID
AND Page.PageGUID = PageLanguage.PageLinkGUID
AND PageLanguage.PageLinkGUID IS NOT NULL

#82945

Mar 21, 2014 16:53