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

Forums / Bugs & Issues / got 404 error when creating/editing a page in sitefinity 4.2

got 404 error when creating/editing a page in sitefinity 4.2

9 posts, 0 answered
  1. Thao
    Thao avatar
    1 posts
    Registered:
    23 Sep 2010
    24 Oct 2011
    Link to this post
    after upgrading to 4.2, we experience an strange behavior.  I create a new page, it shows 404 error for the content page but the page is created in the list.  Double clicking on the page to edit also give me 404 error.  It looks like it can't create page for some reason.  I can't still open old pages that were previously created.

    I looked in sql profiler and noticed it called different sqls for my new page.  when I tried to edit an older page, I see these sql in the profiler and it return one row as expected:

    declare

     

    @p1 int

     

    set

     

    @p1=60

     

    exec

     

    sp_prepexec @p1 output

     

    ,

     

    N'@p0 nvarchar(4)

     

    ,@p1 uniqueidentifier'

    ,

     

    N'SELECT a.[id] AS COL1

     

    , a.[approval_workflow_state_] AS COL2

    , a.[description_] AS COL3

    , a.[redirect_url_] AS COL4

    , a.[title_] AS COL5

    , a.[url_name_] AS COL6

    , a.[allow_multiple_urls] AS COL7

    , a.[allow_parameters_validation] AS COL8

    , a.[app_name] AS COL9

    , a.[can_inherit_permissions] AS COL10

    , a.[date_created] AS COL11

    , a.[extension] AS COL12

    , a.[inherits_permissions] AS COL13

    , a.[last_modified] AS COL14

    , a.[linked_node_id] AS COL15

    , a.[linked_node_provider] AS COL16

    , a.[nme] AS COL17

    , a.[node_type] AS COL18

    , a.[open_new_window] AS COL19

    , a.[ordinal] AS COL20

    , a.[ownr] AS COL21

    , a.[content_id] AS COL22

    , a.[parent_id] AS COL23

    , a.[render_as_link] AS COL24

    , a.[root_id] AS COL25

    , a.[show_in_navigation] AS COL26

    , a.[voa_version] AS COL27

    FROM [sf_page_node] a WHERE a.[app_name] = @p0

    AND a.[id] = @p1 '

    ,

     

    @p0=N'CDX/'

     

    ,

     

    @p1='3546EF6C-8160-4DC4-A665-405D2470AE60'

     

    select

     

    @p1

     


    declare

     

    @p1 int

     

    set

     

    @p1=93

     

    exec

     

    sp_prepexec @p1 output

     

    ,

     

    N'@p0 uniqueidentifier'

     

    ,

     

    N'SELECT b.[id] AS COL1

     

    , b.[approval_workflow_state_] AS COL2

    , b.[description_] AS COL3

    , b.[redirect_url_] AS COL4

    , b.[title_] AS COL5

    , b.[url_name_] AS COL6

    , b.[allow_multiple_urls] AS COL7

    , b.[allow_parameters_validation] AS COL8

    , b.[app_name] AS COL9

    , b.[can_inherit_permissions] AS COL10

    , b.[date_created] AS COL11

    , b.[extension] AS COL12

    , b.[inherits_permissions] AS COL13

    , b.[last_modified] AS COL14

    , b.[linked_node_id] AS COL15

    , b.[linked_node_provider] AS COL16

    , b.[nme] AS COL17

    , b.[node_type] AS COL18

    , b.[open_new_window] AS COL19

    , b.[ordinal] AS COL20

    , b.[ownr] AS COL21

    , b.[content_id] AS COL22

    , b.[parent_id] AS COL23

    , b.[render_as_link] AS COL24

    , b.[root_id] AS COL25

    , b.[show_in_navigation] AS COL26

    , b.[voa_version] AS COL27

    FROM [sf_page_node] a

    LEFT JOIN [sf_page_node] AS b ON (a.[id] = b.[parent_id])

    WHERE a.[id] = @p0

    ORDER BY b.[ordinal] '

    ,

     

    @p0='3546EF6C-8160-4DC4-A665-405D2470AE60'

     

    select

     

    @p1

     


    when I try to edit the page I just created, it calls these sqls:

    declare

     

    @p1 int

     

    set

     

    @p1=130

     

    exec

     

    sp_prepexec @p1 output

     

    ,

     

    N'@p0 nvarchar(4),@p1 nvarchar(11),@p2 nvarchar(18),@p3 nvarchar(23)'

     

    ,

     

    N'SELECT a.[id] AS COL1

     

    , a.[app_name] AS COL2

    , a.[culture] AS COL3

    , a.[disabled] AS COL4

    , a.[is_default] AS COL5

    , a.[last_modified] AS COL6

    , a.[qery] AS COL7

    , a.[redirect] AS COL8

    , a.[url] AS COL9

    , a.[voa_version] AS COL10

    FROM [sf_url_data] a

    JOIN [sf_page_node] AS b ON (a.[id2] = b.[id]) WHERE a.[app_name] = @p0

    AND b.[allow_multiple_urls] <> 0

    AND not (a.[disabled] <> 0)

    AND (a.[url] IN (@p1,@p2,@p3))

    AND a.[voa_class] = 811102197 '

    ,

     

    @p0=N'CDX/'

     

    ,

     

    @p1=N'~/testpage2'

     

    ,

     

    @p2=N'~/testpage2/Action'

     

    ,

     

    @p3=N'~/testpage2/Action/Edit'

     

    select

     

    @p1

     

    declare

     

    @p1 int

     

    set

     

    @p1=85

     

    exec

     

    sp_prepexec @p1 output

     

    ,

     

    N'@p0 nvarchar(4),@p1 uniqueidentifier'

     

    ,

     

    N'SELECT COUNT(1) AS EXPR1

     

    FROM [sf_page_node] a WHERE a.[app_name] = @p0

    AND a.[id] = @p1 '

    ,

     

    @p0=N'CDX/'

     

    ,

     

    @p1='F669D9A7-009D-4D83-DDAA-000000000002'

     

    select

     

    @p1

     

     
    The last sql returns a the row for "Pages" page and the sql next to last return no row.  I have "testingpage2" in sf_page_node, but I don't have it in sf_url_data.  Is that the reason why I have 404 error? if so, how do I insert it to sf_url_data? Please point me to the right direction.
    thank you very much
  2. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    26 Oct 2011
    Link to this post
    Hello Thao,

    I have answered you in the support ticket you have opened.

    Best wishes,
    Victor Velev
    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
  3. Ronen
    Ronen avatar
    2 posts
    Registered:
    24 Nov 2010
    28 Jan 2012
    Link to this post
    how your answer help , if i have the same and i cant see the ticket? and i have no idea where to find it?
  4. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    30 Jan 2012
    Link to this post
    Hi Ronen,

    We have answered you in the ticket you have submitted regarding the issue. However if Thao wishes, he can share with the community what was the actual cause of the problem.

    Greetings,
    Victor Velev
    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
  5. Ronen
    Ronen avatar
    2 posts
    Registered:
    24 Nov 2010
    30 Jan 2012
    Link to this post
    i think it is required. no point keeping such data confident.
    anyway after 3 days and 23 hours we found out it is somehow related to Max pages allowed
    in sitefinity
  6. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    30 Jan 2012
    Link to this post
    Hello Ronen,

    There was an issue with previous versions of Sitefinity, when there are more then hundred pages under a single page node. This resulted in 404's when creating / editing pages. In order to fix that you had to set the maxPageNodes property to 200 in the webconfig file, inside the SitefinitySiteMap attribute.

    All the best,
    Victor Velev
    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
  7. Abílio
    Abílio avatar
    4 posts
    Registered:
    06 Sep 2011
    03 Feb 2012
    Link to this post
    I have a problem similar to this one.
    Every time I want to create a child page i get a 404 error but the page appears in the list pages after that. If I push my page to the root I can edit it, if I drag it to another page and try to edit it I get another 404 error.
    Do you know the reason. This should be straight and simple.
    Thanks in advanced.
  8. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    07 Feb 2012
    Link to this post
    Hi Abílio,

    Have you tried the proposed solution - by setting the maxPageNodes property in the webconfig?

    Greetings,
    Victor Velev
    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
  9. pbwebmaster
    pbwebmaster avatar
    17 posts
    Registered:
    15 Apr 2007
    12 Oct 2012 in reply to Victor Velev
    Link to this post
    Thanks for sharing with the rest of us Victor!
9 posts, 0 answered