[wp-trac] [WordPress Trac] #14058: Export issues on multisite configurations

[WordPress Trac]

#14058: Export issues on multisite configurations
--------------------------+-------------------------------------------------
 Reporter:  yoavf         |       Owner:           
     Type:  defect (bug)  |      Status:  new      
 Priority:  normal        |   Milestone:  3.1      
Component:  Export        |     Version:  3.0      
 Severity:  normal        |    Keywords:  has-patch
--------------------------+-------------------------------------------------
Changes (by yoavf):

  * milestone:  3.0.1 => 3.1


Old description:

> In 3.0, some changes were introduced to the export functions may fail on
> some multi sites configuration.
>
> For example, [14153]
>
> This new query won't work on installations where the posts table and the
> users tables aren't on the same server.
>
> 2nd issue:
> from wp-admin/includes/export.php
> {{{
> $where .= $wpdb->prepare( "AND ID IN (SELECT object_id FROM
> $wpdb->term_relationships WHERE term_taxonomy_id = %d) ", $term_id );
> }}}
>
> This is flawed because it assumes the term_relationship object_id is the
> same as the term_id which might not always be the case (ie global tags
> configuration).
>
> The attached patch fixes that by using get_objects_in_term() instead. The
> authors selection drop down code is reverted to pre-3.0 code.

New description:

 In 3.0, some changes were introduced to the export functions that may
 cause the export to fail some multi-sites configuration.

 For example, [14153]

 This new query won't work on installations where the posts table and the
 users tables aren't on the same server.

 2nd issue:
 from wp-admin/includes/export.php
 {{{
 $where .= $wpdb->prepare( "AND ID IN (SELECT object_id FROM
 $wpdb->term_relationships WHERE term_taxonomy_id = %d) ", $term_id );
 }}}

 This is flawed because it assumes the term_relationship object_id is the
 same as the term_id which might not always be the case (ie global tags
 configuration).

 The attached patch fixes that by using get_objects_in_term() instead. The
 authors selection drop down code is reverted to pre-3.0 code.

--

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