[wp-trac] Re: [WordPress Trac] #5457: deleting a nested page from Manage => Pages causes query inconsistency

[WordPress Trac]

#5457: deleting a nested page from Manage => Pages causes query inconsistency
---------------------+------------------------------------------------------
 Reporter:  hailin   |        Owner:  anonymous
     Type:  defect   |       Status:  new      
 Priority:  high     |    Milestone:  2.5      
Component:  General  |      Version:           
 Severity:  major    |   Resolution:           
 Keywords:           |  
---------------------+------------------------------------------------------
Old description:

> Given the following pages:
>
> ID  Title        post_parent
> 4   sunpage     0
> 5   -moonpage   4
> 6   --starpage  5
> 7  rainpage     0
>
> if we remove moonpage, and do page refresh, starpage is not displayed.
> The root cause is that, after removing moonpage, the internal db state
> and cache may be out of sync. ie, querying phpmyadmin reveals the
> starpage has post_parent=4; yet
> print_r(pages) within page_rows() reveals starpage has post_parent=5.
>
> This can cause all sorts of perplexing problems if not fixed.

New description:

 Given the following pages:
 {{{
 ID  Title        post_parent
 4   sunpage     0
 5   -moonpage   4
 6   --starpage  5
 7  rainpage     0
 }}}
 if we remove moonpage, and do page refresh, starpage is not displayed.
 The root cause is that, after removing moonpage, the internal db state and
 cache may be out of sync. ie, querying phpmyadmin reveals the starpage has
 post_parent=4; yet
 print_r(pages) within page_rows() reveals starpage has post_parent=5.

 This can cause all sorts of perplexing problems if not fixed.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/5457#comment:1>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software