[wp-trac] [WordPress Trac] #14576: Nav Menu Item Description Duplicates Content

[WordPress Trac]

#14576: Nav Menu Item Description Duplicates Content
--------------------------+-------------------------------------------------
 Reporter:  jghazally     |       Owner:                 
     Type:  defect (bug)  |      Status:  new            
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Menus         |     Version:                 
 Severity:  normal        |    Keywords:                 
--------------------------+-------------------------------------------------

Comment(by jghazally):

 Hi @filosofo
 essentially the SQL statement was badly written and is not restructured to
 suit, simply speaking WPEC was doing a (sudo code)

  SELECT `post_id` FROM `wp_posts` WHERE `content`= '[shortcode]' LIMIT 1;

 this was old code used for pulling out the ID for the products page to
 render the permalinks etc. however when 3.0 came out and people started to
 use the navigation and menu system and added the products-page to the
 menu, WP was adding a new row into wp_posts for the custom post type of
 `nav_menu_item` and duplicating the content... which was returning the
 wrong ID and failing to render permalinks...

 As I said, WPEC has resolved the issue with better SQL statement, but
 thought I should report the issue incase it relates to other Plugins,
 Themes performance issues ..

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/14576#comment:2>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software