[buddypress-trac] [BuddyPress Trac] #7109: `wp_bp_xprofile_groups` DB table sometimes sets `Base` group to an `id` that is not `1`

[buddypress-trac]

#7109: `wp_bp_xprofile_groups` DB table sometimes sets `Base` group to an `id`
that is not `1`
----------------------------------+-----------------------------
 Reporter:  r-a-y                 |      Owner:
     Type:  defect (bug)          |     Status:  new
 Priority:  normal                |  Milestone:  Awaiting Review
Component:  Component - XProfile  |    Version:  1.2
 Severity:  major                 |   Keywords:  dev-feedback
----------------------------------+-----------------------------
 I've seen a few reports on the forums about the registration page and
 "Edit Profile" button not working correctly when the Extended Profiles
 component is enabled.

 It appears this issue dates back quite far.  At least BP 1.8 or even
 earlier:
 https://buddypress.org/support/topic/bad-link-to-profile-edit/

 More recent:
 https://buddypress.org/support/topic/registration-and-edit-profile-issue/

 The main problem is sometimes the `wp_bp_xprofile_groups` DB table sets
 the `Base` group at an `id` that isn't `1`.

 The only way this can happen is if the `Base` group is deleted somehow and
 then recreated, which auto-increments the `id`.

 Since we do manual checks for `id = 1`, this breaks things like the
 registration page and "Edit Profile" link
 (`/members/USER/profile/edit/group/1/`):

 https://buddypress.trac.wordpress.org/browser/tags/2.5.3/src/bp-xprofile
 /bp-xprofile-screens.php?marks=57-60#L44

 https://buddypress.trac.wordpress.org/browser/tags/2.5.3/src/bp-members
 /bp-members-screens.php?marks=133-134,154-157#L133

 This might be related to this:
 https://buddypress.trac.wordpress.org/browser/tags/2.5.3/src/bp-core/admin
 /bp-core-admin-schema.php?marks=412-414#L409

 Looks like this dates as far back as v1.2.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/7109>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac