First off, you need to make sure the new email/username (the process is the same for both) address is unique.
There can't be any other users on either bombplates.com or SOMEBAND.bombplates.com that use the same address.
From there, the best way to change a user's email is to log in to the band site as that user, click "my account" and change the username or email. They can also do this from bombplates.com's side, but the band site seems to work better.
If you must do this as an administrator, log into the band site as "BPAdmin". Click "Users". Edit the user, and change their username/email.
If password integration gets out of sync, you'll have to update the DB to resync it:
- Log into the band site as "administrator" and log into bombplates.com as an administrator
- Update the relevant account to use the same email and username
- Copy the Integration key from the user's Integration tab on bombplates.com
- Log into the database on the band site server
- > SELECT fid FROM profile_fields WHERE name='profile_pw_integrate_key';
- > UPDATE profile_values SET value='KEY_FROM_ABOVE' WHERE fid=FID_FROM_ABOVE AND uid=USER_UID;
- Clear the cache
- Go to SOMEBAND.bombplates.com/user
- Reset the user's password