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

Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

Home / Forums / Legacy forums / Episerver CMS 6 R2 /

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 (MVP)

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

This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.