Opened 11 years ago
Closed 11 years ago
#5573 closed defect (bug) (duplicate)
Counting problem of Pending Accounts
Reported by: | slaFFik | Owned by: | |
---|---|---|---|
Milestone: | Priority: | normal | |
Severity: | normal | Version: | 2.0 |
Component: | Administration | Keywords: | reporter-feedback |
Cc: |
Description
Here is the the screencast: http://screencast.com/t/kIq5hCyZsvZx
That's on Users admin area pages.
Change History (8)
#2
@
11 years ago
I have right now 24 items in that table. And nothing displayed when I'm on /wp-admin/users.php?page=bp-signups
page (all are activated).
There is no signup_id
field in $wpdb->signups
table in my database.
#3
@
11 years ago
There is no signup_id field in $wpdb->signups table in my database.
It sounds like this may be the problem. slaFFik, are you working on an installation that uses or has used the Gravity Forms User Registration add-on? See #5563.
#4
follow-up:
↓ 5
@
11 years ago
No, that site has never had that plugin at all.
Initially it was WPMU (back to 2.6-2.7), converted to WP, and a year ago or so BuddyPress was installed.
BP Registration Options plugin is intalled.
#5
in reply to:
↑ 4
@
11 years ago
Replying to slaFFik:
No, that site has never had that plugin at all.
Initially it was WPMU (back to 2.6-2.7), converted to WP, and a year ago or so BuddyPress was installed.
slaFFik,
1/ can you confirm the structure of your signups table, just downloaded WPMU 2.7 and the signups table was created this way :
CREATE TABLE IF NOT EXISTS $wpdb->signups ( domain varchar(200) NOT NULL default '', path varchar(100) NOT NULL default '', title longtext NOT NULL, user_login varchar(60) NOT NULL default '', user_email varchar(100) NOT NULL default '', registered datetime NOT NULL default '0000-00-00 00:00:00', activated datetime NOT NULL default '0000-00-00 00:00:00', active tinyint(1) NOT NULL default '0', activation_key varchar(50) NOT NULL default '', meta longtext, KEY activation_key (activation_key), KEY domain (domain) ) $charset_collate;
2/ When you say "converted to WP" does it means you converted to a multisite WP or a non multisite WP ?
#6
@
11 years ago
slaFFik,
Just ran some upgrade tests by creating the signups table described in point 1/ for a non multisite WP
Upgrading 1.9 to 2.0 :
I confirm in this case that when on a users screen there's a total for the Pending view and that when going on the Pending screen, no signups are displayed and the total is 0.
Then Upgrading to 2.0.1 (benefiting of the work done by jjj and r-a-y in #5563)
It solves the issue : signups count is consistent between the two screens and in the signups table, there's now a signup_id. It's then possible to have the signups listed and to manage them (activate, delete, resend).
So i would say that this bug will be fixed in 2.0.1 thanks to the work done on #5563
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 ?