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

[buddypress-trac]

#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


Comment:

 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
 DESC}}}

 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