Posted 6 years ago #
I've never seen this happen, but for the past two days, when I log-into my wp-admin area, all of my options are gone. What I mean is -- I look like a vanilla user. Ok, I lied . I do have some options: *sign-out*& *my account*.
Every posting appears to be in-tact, and I can edit all of them. I am the only user on my site, with no other admins.
I don't want to play the "is someone up to foul play card", but now that you know it's in my hand, do you think I should play it?
Thanks!
Any post tagged with "lutefisk" needs extra attention!
Are you able to see what level your account is? Did you inadvertantly remove your Adminship?
Posted 6 years ago #
That's what it seems, but I cannot tell what level anymore. I haven't tweaked anything in User settings for several weeks. The only non-posting change was comment settings - set to approve by admin.
I clicked "forgot password" to test for fun. I was able to change the pass and get back into vanilla land. Still got the stiff arm.
Ooh! Maybe I sold my company! Yess!
And if you like lutefisk, we did a podcast interview with a fish store in Minn. at http://www.bionicgenius.com </shamelessPlus>
Well, here's a zany thought: Can you get to your database with phpMyAdmin or something similar?
If so, pop into wp_usermeta and see what you have for wp_user_level (should be 10 if it is even still used) and wp_capabilities (mine is a:1:{s:13:"administrator";b:1;} and frankly, I'm still pondering what all that means... but I like seeing "administrator" in it).
Posted 6 years ago #
Zoiks. I have no clue. I'm staring at the wp_usermeta screen, and nothing says wp_user_level. Nor is it in wp_users. I don't see the word administrator or admin anywhere either. I wonder if this is even English?
Jinkies!
Maybe wp_user_level is left over from my 1.5x upgrade. But no wp_capabilities column?
Posted 6 years ago #
Ruh-Roh. Not that I can tell. If the columns are these {below}. If you mean within wp-usermeta, then no again.
Here's what I've got:
wp_categories
wp_comments
wp_linkcategories
wp_links
wp_options
wp_post2cat
wp_postmeta
wp_posts
wp_usermeta
wp_users
Jeepers. I kinda botched my last one. In wp_usermeta, do you have a column named meta-key with a value like I said in my last post? (a:1:{s:13:"administrator";b:1;})
Posted 6 years ago #
Schnikies. I clicked on BROWSE, and am back in the Mystery Machine, riding shotgun. I have a:1:{s:13:"administrator";b:1;} as well.
My umeta_id has a value of 5.
My user_id has a value of 1.
Hoooold on there Scoob...
My wp_user_level has a value of 3! Could this be it? Mister Witherspoon!!?? How did that get changed?
Wonder if I should bump it to 10.
I hope this is as entertaining for you as it is for me! LOL.
If admin - it should be 10!
I blame those meddling kids!
Ratchet her up to 10 there Scoob and let's see what happens next...
Posted 6 years ago #
Crap. The user level is at 10 for my admin. I was looking at another member. The munchies can make you see strange things, apparently.
So, any more suggestions?
I'm thoroughly stumped at this point. Hmmm...
Do you have any userlevel or admin tweaking plugins installed?
Posted 6 years ago #
No - No plugins. I upgraded to 2.0.1 about a month ago, and have never had a glitch. I guess I'll contact my host to see how this got changed w/out touching it, and what they can do to help. Thanks for your help Handy! Now about our podcast... =^)
liI encourage anyone to chime in. Even if you know nothing about ScoobyDoo. Smurfs perhaps?/li
Posted 6 years ago #
If I have problems with backsticks, I must be a dolt.
Just put one backtick at the beginning of your code portion and another backtick after it. That's all. Whatever is in between will not be rendered but displayed.
I was always partial to Smurfette...
Say, I just stumbled over this think here in another thread. Never heard of it and can't find mention of it at the redalt site, but... if'n y'all are mighty brave (and backed up your db *cough*) might be worth a shot.
http://redalt.com/downloads/wp2/restore-admin.zip
There's on file in that zip and if you open it up, the instructions are built in as comments at the top of it. It says it works for 1.6 which is what became 2.0 as I recall.
Oher than that, I got nuttin'.
Posted 6 years ago #
K. Thanks. I dropped Dreamhost a note. I imagine the problem lies somewhere in WP though.
Well yeah. I'd agree. My previous post was a bit garbled -- did you try that link?
Posted 6 years ago #
I got a good laugh out of you guys and the back and forth.... I'm wondering if DH had a problem on your server, and reloaded an older backup. Not a good idea....
And that's about all I can even think to offer. Except that once you get this sorted and you're back in business, make a db dump and store it locally at least once a week, 'kay?
Posted 6 years ago #
I did backup db when moving to v2. I guess backing-up now might be fruitless, but I guess since everything is "functional" as far as posts, I'll do a backup now, then I'll try the restore tool.
I know DH does incremental backups, so I'll see what's up in that department. Great advice on the weekly procedure.
I'll Holla. I cannot think of any good Smurf references; just the names Gargamel and Azrael come to mind, and it makes me long for the days of good cartoons... like... Scooby-Doo perhaps?. Yes! new I could bring us back on topic.
Posted 6 years ago #
Oh, I just miss the AD&D cartoon.... and a really really lovely b&w one from the mid-50s which I of course do not have any clue as to the name of now, and a truly truly wonderful comic strip from the early 70s about some people trapped in the world in a drop of amber....
Hmm... I can't recall any good AD&D cartoons. Perhaps I missed one!
And hell, the 70s had the 90 minute "Bugs Bunny / Road Runner Show." What more did we need for cartoons?!?
*meep meep*
Keep us posted Creative and I might just get around to grabbing that podcast...
Posted 6 years ago #
I didn't say it was a GOOD one.
Posted 6 years ago #
Ok... I unzipped the file linked above, and there were no instructions; there was one PHP file, whith the following {below}... It looks like this will restore admin, but if I already have admin... no clue, rooby-roo.
get_var("SELECT ID from {$wpdb->users} WHERE user_login = '{$adminuser}';"); if(!$adminid) { die("
Uh, oh... The username '{$adminuser}' does not exist in your database. Try again.
"); } $admin = new WP_User($adminid); $admin->add_cap('edit_users'); $admin->add_cap('read'); wp_redirect("wp-admin/profile.php"); ?>
Preview post would be cool here. Silly backticks.
From that same file:
RESTORE ADMINISTRATOR PERMISSIONS
=================================So, you've messed with the Role Manager (or some database properties) and you've locked yourself out of WordPress... Well done!
Follow these instructions to get yourself back into the system:
1. Edit this file and change the value for $adminuser that appears just below these instructions. Set $adminuser equal to your admin's username. Save it.
2. Upload this file to your WordPress directory as "restore-admin.php". It should be in the same directory as your wp-config.php file.
3. Access this file from your web browser using the URL similar to http://example.com/restore-admin.php . You should be redirected to a login page or a profile page. Login as the specified user and verify on the login page that the additional capability "edit_users" is now set.
4. The user you have specified should now have edit_users permissions, and should be able to change user permissions as necessary to restore any required access. Note that this DOES NOT restore edit_users permission to a ROLE, only to the user specified below. To restore edit_users permission to a Role, use the Role Manager plugin.
5. Optionally delete this file. Although this file will only ever add edit_users capabilties to a single user as hardcoded in the file, it seems safer not to tempt fate by leaving it around for hackers to attempt to tamper with it.
I dunno... But heck, what do you have to lose at this point ;-)
Posted 6 years ago #
Ran it, and all is the same. $#gerfuffle*&!
Looks like I need to reinstall WP.
Having never done this, I'm skeered. Might not be that difficult, as the update was easy-peasy.
I think the db is all good still, but then who knows?
At-least this is my site, and no-one paying me! Guess the backup lesson is learned here. *sniff*
Posted 6 years ago #
Okeydonkey. I cleared-out, and reloaded WP completely. It was actually pretty easy, and forced me to clean-up a bunch of stuff.
Consider this one closed. Thanks for the excellent assistance!
WordPress ROCKS. You know this.
Yay! (about time :-p ) Glad you got it all going again in spite of my helpful advice. ;-)
Posted 6 years ago #
Shaambaala! Another case closed, watson....
This topic has been closed to new replies.
