Topic: Issues after changing admin username · BuddyPress.org

Skip to:: Content; Pages; Categories; Search; Top; Bottom

Issues after changing admin username

bennadler
Member

@bennadler

14 years ago

I followed a tutorial at http://www.onextrapixel.com/2010/01/30/13-useful-wordpress-sql-queries-you-wish-you-knew-earlier/ on how to change my WordPress username from admin to my name.

It mostly worked. I initially lost Super Admin and Admin access, but I was able to restore this using my partner’s account.

Everything seems to be fine, until I found out that users could not send me Private Messages in Buddypress. I also noticed that my mention code on my profile is still @admin, and not @bennadler

So it seems the WordPress database was updated, but Buddypress was not. Is there another SQL query I need to run in order to change and fix this? Thanks for your help!

Viewing 3 replies - 1 through 3 (of 3 total)

sicksight
Participant

@sicksight

14 years ago

First: I have not updated to WordPress 3.0 …
I used “root” instead of “admin” and I immediately replaced after the installation all text with “admin” in the database with “root”.

Paul Wong-Gibbs
Keymaster

@djpaul

14 years ago

Update the appropiate record in the bp_xprofile_data table (field_id=1, user_id=1).

r-a-y
Keymaster

@r-a-y

14 years ago

By default, BuddyPress uses the user_nicename column in the DB and not the user_login. Make sure your user_nicename is the same as your user_login.

Or you can add the following line to wp-config.php:
define( 'BP_ENABLE_USERNAME_COMPATIBILITY_MODE', true );

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Issues after changing admin username’ is closed to new replies.