how did you change the username?  did you keep the same user id and user meta entries in the wp database?  if not, its really a new user…

wp admins are not sp admins…  you have to give sp admin capabilities to users on the forum – admin – manage admiins panel…  you do this with an account that is an sp admin – not necessarily a wp admin..

if you do not have access to that account (looking at screenshot, at least one does exist or else all wp admins would get access), you do this:

so for the user id in question, go to your database…  the wp_usermeta table (your prefix might be other than wp_)… find the user meta for your id with a name of wp_capabilities (again, wp_ may be different)… change the value to

a:14:{s:13:"administrator";s:1:"1";s:18:"SPF Manage Options";b:1;s:17:"SPF Manage Forums";b:1;s:22:"SPF Manage User Groups";b:1;s:22:"SPF Manage Permissions";b:1;s:21:"SPF Manage Components";b:1;s:16:"SPF Manage Users";b:1;s:17:"SPF Manage Admins";b:1;s:18:"SPF Manage Toolbox";b:1;s:24:"SPF Manage Configuration";s:1:"1";s:19:"SPF Manage Profiles";b:1;s:15:"SPF Manage Tags";b:1;s:17:"SPF Manage Themes";b:1;s:18:"SPF Manage Plugins";b:1;}

worth noting that if you have other plugins that add capabilities to your account, you will have to account for those – most folks wont have that…

I think, it is solved. Thank you.

Good to know. Sadly the WordPress team has still not given us a ‘hook’ that allows us to detect an admin account delete process prior to the delete taking place which is what we need to enable a better solution for this one.

Not sure yet if this is extra information or a cry for help.

During the recent botnet attacks on WordPress installations worldwide, our admin installed Better WP Security. This allows for the changing of both user id and username for his WP user ‘admin’. Our admin did both. 

The result seems to be as follows:

– User attempts to log in with old credentials (admin) via the SP forum and gets bounced to the main WP login page. The only way to login is with the new credentials (newadmin). Success.

– When logged in with the new credentials (newadmin) the forum identifies the user as a new member (albeit with the original join date) and with no posts attributed. No admin rights either.

– The wp_sfmembers table displays a row for both the original user id 1 ‘admin’ and a new row for id 123 ‘newadmin’.

– However wp_users and wp_usermeta have no reference to user id 1. All the data is now stored in id 123 ‘newadmin’.

Am I asking for trouble by deleting the new row on wp_sfmembers and then changing ID 1 and name ‘admin’ on the original row to the new credentials? Hmmm… I’d need to change the user id on posts by user 1 too…

And yes, the admin did backup first. Apparently Better WP Security facilitates this.

yes, that would be problematic, I think…  because the rest of the simple press tables that reference the user id still point to the original 1.. thinks like who created topics and posts as well as memberships…

we have fallback code in place so if a new user comes to the site and their sp data has not been created, we  create for them on their first visit… so that is what happened to this new user (or if the other plugin used the wp api for creating the new user, we hooked in then)… but it would not move the older user stuff – wouldnt know about that…

If the original user in wp, user id 1, was deleted properly with the wp api, we should have seen the deletion hook from wp and would have removed the wp row in sfmembers too…  if there is no row in wp users table with that ID, there shouldnt be in sfmembers either… but if there is and the sp data in topics/posts/etc are still pointing to that now invalid user, you could use some mysql queries to move them to the new user…

I just wanted to add the code above solved my problem!

I have wishlist member.  As I was using role manager to adjust the permissions/ add roles, I accidentally locked myself out of wishlist member admin settings, it took a week to figure out the user lever in role manager was wrong.  So I finally had access to wishlist member settings again, at the same time I was locked out of simple press admin settings.  It was out of a horror movie.  Role Manager was the culprit and I couldn’t undo anything with role manager since any changes are persistent ever if role manager was deactivated and deleted. 

So forward to now I stumble upon this post which did not address my problem but was the closest thing to it.  I copied and pasted the code and now after 2 weeks of this mess, I finally have access to both wishlist member and simple press!!

Lesson learned… don’t take role manager plugin lightly.  Follow the codex instructions EXACTLY!  I got too confident.

http://codex.simple-press.com/codex/faq/problem-with-post-edit-buttonow-to/problem-with-post-edit-buttonow-to-configure-simple-press-with-membership-plugin/

glad it worked out in the end!