posts-to-posts collides with wp_query 'posts_fields' filter

[lbell]

Details here: http://wordpress.org/support/topic/error-plugin-fails-with-custom-wp_query-filter?replies=1#post-3866640

But essentially it seems that with a custom wp_query posts_fields filter in place, posts-to-posts fails due to the MySQL subquery that searches for the related IDs with an IN statement expected to only return ID's -- but posts_fields is bringing baggage baby!

[scribu]

Could you post the filter you're adding to 'posts_fields'?

[lbell]

add_filter('posts_join', 'fact_join');         
function fact_join($join){
  global $wp_query, $wpdb;
    $fact_meta_table = $wpdb->prefix . "extended_table";
    $join .= "LEFT JOIN ". $fact_meta_table . " ON $wpdb->posts.ID = ". $fact_meta_table .".id ";  
  return ($join);
}

add_filter('posts_fields', 'fact_fields');         
function fact_fields($fields){
  global $wp_query, $wpdb;
    $fields .= ", " . $wpdb->prefix . "extended_table.*";
  return ($fields);
}

[lbell]

Using P2P 1.4.3 and WP 3.5.1

[lbell]

I've temporarily hacked my way around this with:

$q->_p2p_sql = str_replace( ', wp_extended_table.*' , '' , $q->_p2p_sql );

In function capture_query()

This is a bit inelegant (and likely misses something...) but I've scoured for a way to fix this all morning, and tis a bit beyond me...

[lbell]

Still an issue (I was reminded when I updated). For further info (for me) the above function can be found in core/side-post.php around line 108