1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / No row for Telerik.Sitefinity.Pages.Model.PageData

No row for Telerik.Sitefinity.Pages.Model.PageData

2 posts, 0 answered
  1. Ravish
    Ravish avatar
    12 posts
    Registered:
    27 Sep 2011
    09 Jan 2012
    Link to this post
    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

  2. Jen Peleva
    Jen Peleva avatar
    568 posts
    Registered:
    10 Nov 2016
    12 Jan 2012
    Link to this post
    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.

    Greetings,
    Jen Peleva
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered