[buddypress-trac] [BuddyPress Trac] #5573: Counting problem of Pending Accounts

buddypress-trac noreply at wordpress.org
Tue Apr 22 09:16:39 UTC 2014

#5573: Counting problem of Pending Accounts
 Reporter:  slaFFik            |       Owner:
     Type:  defect (bug)       |      Status:  new
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Administration     |     Version:  2.0
 Severity:  normal             |  Resolution:
 Keywords:  reporter-feedback  |
Changes (by imath):

 * keywords:   => reporter-feedback


 Hi slaFFik,

 I'd really like to see the content of your {$wpdb->signups} table to
 understand why...

 Because the view filter is doing this query:

 {{{SELECT COUNT(*) AS total FROM wp_signups WHERE active = 0}}}

 And when on signups screen the query is :

 {{{SELECT COUNT(*) FROM wp_signups WHERE active = 0 ORDER BY signup_id

 So the only difference is the ORDER BY clause.

 Can you check on your config by adding the ORDER BY clause in the query
 made by the BP_Signup::count_signups() method ?

Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5573#comment:1>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac

More information about the buddypress-trac mailing list