WordPress.org

1. snowcrash
   Member
   Posted 3 years ago #

   Hello

   Pleased to see the development of this plugin

   Though the coauthors_wp_list_authors tag appears to have a similar problem as the original co-authors plugin. That is, users who don't have a post as a first author, but only as a co-author, do not appear with links when listed via the coauthors_wp_list_authors tag.

   thanks

2. Mohammad Jangda
   Member
   Posted 2 years ago #

   Hi snowcrash,

   Thanks for your note. Is this happening in any specific contexts (e.g. on particular posts or archive pages) or any time the tag is used? I know that there is an issue on author pages with some of the tags, and I should have a fix coming out soon.

3. snowcrash
   Member
   Posted 2 years ago #

   Hi batmoo

   I've used this in my own template page (called it contributor.php), where I simply include the coauthors_wp_list_authors tag, for example:

   ...
   <ul>
   <?php if(function_exists('coauthors_posts_links'))
   				coauthors_wp_list_authors('hide_empty=1');
   			else
   			wp_list_authors('hide_empty=1'); ?>
   </ul>
   ...

   look forward to a fix
   many thanks

4. Svirksts Maris
   Member
   Posted 2 years ago #

   The bug is inside this sql statement:

   $author_count = array();
    $sql = "SELECT DISTINCT
    p1.post_author,
    (COUNT(ID)+(SELECT COUNT(*)
    FROM $wpdb->posts p2, $wpdb->postmeta pm
    WHERE p2.ID = pm.post_id
    AND pm.meta_key = '_coauthor'
    AND pm.meta_value = p1.post_author)
    ) AS count
    FROM $wpdb->posts p1
    WHERE post_type = 'post' AND " . get_private_posts_cap_sql( 'post' ) . "
    GROUP BY post_author";

   To fix it I changed the lines above (coauthors.php file, lines 455 till 466 from Co Authors Plus plugin) to this:

   foreach ( (array) $authors as $author ) {
    $sql = "SELECT count(*) AS count FROM $wpdb->posts p1, $wpdb->postmeta pm WHERE p1.ID = pm.post_id AND pm.meta_key = '_coauthor' AND pm.meta_value = '" . $author->ID . "' AND p1.post_status = 'publish' OR p1.post_author = '" . $author->ID . "' AND p1.post_status = 'publish'";

   And add } symbol right after line 508.

   Now, this is definitely not the best variant as it makes an sql query for each author, but - it works. One can see it in action at darkmatter101.org.

   If you don't want to dive into your plugin file, to fix this - Co Authors Plus modified plugin download link: http://www.moskjis.com

5. adastra
   Member
   Posted 2 years ago #

   @Moskjis: That information appears to be outdated. Do you (or does anyone else) know a solution for the most recent version of the plugin?

   This is the SQL code which isn't working correctly:
   

   $query  = "SELECT DISTINCT $wpdb->users.ID AS post_author, $wpdb->terms.name AS user_name, $wpdb->term_taxonomy.count AS count";
   	$query .= " FROM $wpdb->posts";
   	$query .= " INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id)";
   	$query .= " INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)";
   	$query .= " INNER JOIN $wpdb->terms ON ($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)";
   	$query .= " INNER JOIN $wpdb->users ON ($wpdb->terms.name = $wpdb->users.user_login)";
   	$query .= " WHERE post_type = 'post' AND " . get_private_posts_cap_sql( 'post' );
   	$query .= " AND $wpdb->term_taxonomy.taxonomy = '$coauthors_plus->coauthor_taxonomy'";
   	$query .= " GROUP BY post_author";

Topic Closed

This topic has been closed to new replies.