Topic: All Authors Not Showing Up In Authors List

[cshulse]

1. Wordpress 2.7.1
2. Custom theme built off of Sandbox: www.plaintxt.org/themes/sandbox/
3. http://www.awesomeopolis.com
4. WP-Stats 2.40
5. PHP:2.8.0.1, MYSQL:5.0.51a-log
6. None

I have a blog that I run with a few people, and the Author stats that come back are incorrect.

Under my statistics page, I see the following:
http://www.awesomeopolis.com/statistics/

Total Stats

    * 5 authors to this blog.
    * ...
    * OTHER STATS

And on the bottom, I see FOUR names.

Authors

   1. Corey (9)
   2. Ryan (2)
   3. Stephanie (3)
   4. Sathvik (2)

Both of these are wrong, as I have SIX authors to the blog, each with multiple posts.

I have a call to wp_list_authors() on another page, and it correctly shows all six of my authors.

http://www.awesomeopolis.com/archives/

Archives by Author

    * Corey (9)
    * Drew (6)
    * Matt (4)
    * Ryan (2)
    * Sathvik (2)
    * Stephanie (3)

Why is WP-Stats not showing all of my authors?

Thanks in advance.  I really love all the plugins you've created and they've been great in helping us build great functionality into our blogging project!

Best,
Corey
http://www.awesomeopolis.com

[GaMerZ]

1. Check wp_user table database to see if there is a activation key to the author not listed.
2. Ensure that their userlevel is more than 1 by checking usermeta table

[cshulse]

I just looked at the wp_users table.  Yes, those two users have activation key entries.  What does that mean?  I'm presuming they got an e-mail to validate their accounts but never did?  Is it safe to delete those entries from the database or is there a different way to go about it to make sure I don't screw up the database?

[GaMerZ]

Yeap, you can just edit the activate key field to be blank and they will appear.

[kgagne]

I'm having a similar problem.  Stats are displayed here:

http://www.showbits.net/stat/

Under Total Stats is "1 author to this blog".  Then under "Author Stats" are the post counts for all seven authors.

Their activation keys are clear:

http://www.gamebits.net/screens/cd1810c7005e863410372b015b89edfa.jpg

And their user levels are at least 1:

http://www.gamebits.net/screens/4e7064753048a5542efe19aafc6e9104.jpg

WordPress 2.8.1, WP-Stat 2.5.0.

[GaMerZ]

For your case, a quick fix would be to modify:

Code: [Select]

$totalauthors = intval($wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users LEFT JOIN $wpdb->usermeta ON $wpdb->usermeta.user_id = $wpdb->users.ID WHERE $wpdb->users.user_activation_key = '' AND $wpdb->usermeta.meta_key = '".$wpdb->prefix."user_level' AND (meta_value+0.00) > 1"));
To:

Code: [Select]

$totalauthors = intval($wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users"));
It work fine on my site http://lesterchan.net/wordpress/stats/ I got 3 Authors but in Authors Stat only 1 is listed because the rest have 0 post.

What is your MYSQL version?

[kgagne]

Thanks!  I replaced line 76 as directed.  Now it says I have nine authors -- the seven whose posts are counted, and two who have posted nothing, due to being only subscribers and not contributors:

http://www.gamebits.net/screens/f078e403d4b72c01275f9c58201c256d.jpg

I'm not sure why the original code isn't properly counting users who have posting capabilities (and published posts).  Ideally, both numbers should report 7.

I believe my mySQL version is 5.0.32 and PHP 5.2.9.

[GaMerZ]

MYSQL version looks ok to me. I have also no idea why it does not work for you. I can't find anything wrong with the SQL statement. What is your table prefix?

[kgagne]

$table_prefix  = 'wp_';

[GaMerZ]

Hmm looks fine to me, let me KIV this first.