No row for Telerik.Sitefinity.Pages.Model.PageData
Hello there,
I am trying to create a page based on some custom templates that i've uploaded on Sitefinity 4.3. Everything was find, when suddenly it just happened
Steps;
Create page
Choose template
Error:
No row for Telerik.Sitefinity.Pages.Model.PageData ('sf_page_data') GenericOID@854a937a PageData content_id=2ef9d04f-c6b3-43c7-a7a3-6d9e6c115ff2
I would like to sort out this problem before going on [production
Would be glad to have some response soon
Thanks
RaV
Hi,
I suppose the problem is with a leftover page draft. So the draft couldn`t find its master and it returned the error.
To fix at your end (please do a quick test at a backup project).
1.Crete .aspx page in solution
2. In the Page_LoadMethod paste this.
var pageManager = PageManager.GetManager(); var draftPages = pageManager.GetDrafts<PageDraft>().Where(p => p.TemplateId == newGuid("A93A986C-B85B-4026-BCCF-20AB9C812E07") && p.IsTempDraft == false); var dummy = draftPages.FirstOrDefault(); foreach(var draftPage indraftPages) var id = newGuid("1196ea8f-f80b-42eb-99c9-f54c0d7b7b0d"); if(draftPage.Id != id) pageManager.Delete(draftPage); pageManager.SaveChanges(); An explanation : new Guid("A93A986C-B85B-4026-BCCF-20AB9C812E07")I took random template_id from page_data table
var id = new Guid("1196ea8f-f80b-42eb-99c9-f54c0d7b7b0d"); this is the guidID from the error thrown when getting the problem.
3. Run the aspx page in the browser or in debug.
I was able to fix the problem on few occasions with running this code. I suppose this will fix the problem in this case.
If this doesn`t help on the backup of the project can you test upgrading it to Sitefinity 4.4? The error was caused by not updating the templates table in the database sf_page-templates, such errors are fixed automatically when an update of the table is enforced by OpenAccess and if it spots the error it will be fixed. The upgrade procedure triggers the update on this table.