got 404 error when creating/editing a page in sitefinity 4.2 - Bugs & Issues - Bugs & Issues - Progress Community

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

 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
  • 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
  • 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
  • how your answer help , if i have the same and i cant see the ticket? and i have no idea where to find it?
  • 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
  • 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
  • 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
  • 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.
  • 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
  • Thanks for sharing with the rest of us Victor!