Admin Rights Gone

(manic laughter, that’s the most sadistic bug I saw in a long time – sorry)

Bruce, do you have FTP access to your blog ? If you do, I would recommend that you manually deactivate this, with hopes the changes the plugin created are not permanent but enforced by the plugin’s presence.

First, log out from your blog.
To deactivate this plugin, open your blog’s folder in your FTP client, and go to wp-contents/plugins/ , in where you’ll locate the folder with the name of that simple-membership plugin.
And then, just rename that folder, for instance adding an underscore in the end : that will make wordpress turn off the plugin.

And then, in your browser login again… will that work ? I hope so ??

Edit : if I may add a suggestion for the future, in case of crazy stuff like that, always have a secondary user account with admin rights, that you never use, whose credentials you keep on a post-it somewhere in your drawers. It may help in the future.

Sabinooo if I wasn’t so pis… at my self I would laugh too. I did try renaming the plugin on the ftp server but it doesn’t seem to change my rights. This is a sad situation

Allright, allright. Checked if some fancy lines have been added to your .htaccess file ?
If yes, temporarily replacing it with the default htaccess syntax (or nothing at all, if you’re ready to give up on optimizations for a while) might be worth a try.

otherwise, did you consider manually editing your user account in your database with phpmyadmin to change its rights manually ? That would require searching the web for the right options to change, this would be tedious but far from impossible, I think…

I looked at that file but I don’t really know anything about code and what it should look like, If I try and login now it tells me there is no such user. If I try a password reset my account doesn’t even exist anymore

Wow.
Allright, do you have access to phpmyadmin for your web hosting ?

In there, you can go to the list of tables for your database, and click in the “users” table.
Are you able to find your admin’s username ? Remember its ID number (should be 1, but maybe not)
After this, in the left column, please click the “usermeta” table.
In the right column, for your user ID, there should be a row called “wp_capabilities” : what does it says, in there ?

For this wp_capabilities, I have three admin-power accounts, and they say [ a:1:{s:13:”administrator”;b:1;} ] , [ a:1:{s:13:”administrator”;s:1:”1″;} ] and [ a:2:{s:13:”administrator”;b:1;s:13:”bbp_keymaster”;b:1;} ]
I don’t know what these minor differences mean (at least, bbp_keymaster : it’s related to the BBpress plugin), but that’s at least, hopefully, giving a general idea.

Also, if you can’t login anymore as admin, check this page, also to be done with phpmyadmin :
https://codex.www.ads-software.com/Resetting_Your_Password

Hi Sabinoo Sorry for the delay I had to go to my real job that pays the bills ?? I do see the PHadmin panel but I have three headings
I315469_wp1, information schema, and routerre_23f23f23f

I don’t see my admin name in the table

I see an admin name but it looks more like the admin name for GoDaddy.

Do you think if Go Daddy had a back version of the site it could be restored from a previous date to solve the problem.

Thanks so much for taking the time to help me with this

(lightning fast response, busy with bills to pay, likewise)
that means you’re not yet “in” your database, you must click one of the two (ruling out information schema) to display the list of the tables contained within your blog’s database. The right one will probably be the one ending in wp1, I imagine it means wordpress1 ??

wow that was quick!
I looked in both but don’t know what I should change safely <grin>

Is there anyway I can hire you to go into my c-panel and see what I’m seeing it would likely make sense to you.

I have to go out for about an hour I’ll check the post then. Thanks

I’m not here to take money, so, no hiring – plus you really shouldn’t even consider granting that level of trust to an internet stranger ??

OK, so you can get it done within phpmyadmin (on the plus side of doing it : it’s a learning experience and at worst if the database gets corrupted the following state was a restoration anyway, on the minus side : there’s no guarantee at all it would work so it may have been time lost for nothing), but frankly, if you don’t have much to lose, it would be simpler to ask your host to restore a database backup, indeed.

If you want to go the phpmyadmin way, here’s the way :
https://imgur.com/SBFZTpp

Not sure you’d want to edit at once the capabilities line, but at least you can look at them and see if weird stuff is in there.
Looking at various blogs I have, the admin information was always simple, such as [ a:1:{s:13:”administrator”;b:1;} ] or [ a:1:{s:13:”administrator”;b:1;} ]

Thank you so much for all of your time, I know its valuable. I will give the repair a try, as you said it will be a learning experience (huge in my case)
I’m sure I’ll be back looking for more help, but thank you for everything you have suggested. Cheers

Np ??
I realized something, my list in usermeta was not sorted by ID, you need to click it, and then I found new things that may need to be copied over appear, like wp_user_level (to set to 10 according to https://codex.www.ads-software.com/Roles_and_Capabilities#User_Levels )and wp_usersettings

Hi, I’m back
I have made all the changes. It show an admin user with an ID of 1, capabilities of 10 and still can’t get in. My hope that Go Daddy had a backup was wrong – no backup.

What about re-installing WordPress do you think that would help? This is very frustrating, especially when I don’t know what I’m doing. I better stick to woodworking. ??

Yahoo! I’m finally back in to the admin side of things. Thank you for all of your time and suggestions. I followed everything you suggested in every location that looked like it required it and I’m finally back in. Yea!
You rock. Cheers, hopefully someday I can repay the favor somehow.
Bruce

Use the GoDaddy CPanel to make a backup of your site now that its working.