Skip to:
Content

BuddyPress.org

Opened 11 years ago

Closed 11 years ago

#5573 closed defect (bug) (duplicate)

Counting problem of Pending Accounts

Reported by: slaffik's profile 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)

#1 @imath
11 years ago

  • Keywords reporter-feedback added

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 ?

#2 @slaFFik
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 @boonebgorges
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: @slaFFik
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 @imath
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 @imath
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

#7 @slaFFik
11 years ago

can you confirm the structure of your signups table

Yes, I have that structure.

this bug will be fixed in 2.0.1

That's great, thanks for investigating!

Last edited 11 years ago by slaFFik (previous) (diff)

#8 @DJPaul
11 years ago

  • Milestone Awaiting Review deleted
  • Resolution set to duplicate
  • Status changed from new to closed

Closing per imath's comments (#5563).

Note: See TracTickets for help on using tickets.