if the wp_users table is empty, there’s a problem.
is this a brand new install?
It’s been going for a year and half and working fine. The Invalid Username notice started yesterday, but I think the wp_users table may have been unintentionally deleted by someone at our end after the initial problem started.
I remember for sure what version this WordPress is, but I do know that it hasn’t been updated since early 2007.
..but I think the wp_users table may have been unintentionally deleted by someone at our end after the initial problem started.
nope, not deleted but definitely truncated, if it’s empty.
Take a look at wp-includes/version.php and let me know what version of wordpress you are using, and I’ll try to reconstruct what you want to put back into wp_users for you to get admin access back.
Also, look to see if the usermeta table is still intact? and by intact, I mean not empty.
Thanks—I clicked Browse on usermeta table. It appears to be intact.
Where do I find wp-includes/version.php? I looking for it.
you find it right where I said. its a file.
Sorry, I don’t understand. Where do I find this file?
its a file.
its going to be on the web server. where the rest of your wordpress files are.
c’mon, please put on your thinking cap, or I have other things I can do 🙁
I’m doing my best here. I appreciate your help, but do keep in mind I’m exploring an area I haven’t been in before. By web server, I assume you mean the Host. Should I be searching in the phpMyAdmin?
Hey whooami,
Is this what you’re looking for?
$wp_version = ‘2.1’
ok, here you go:
http://pastebin.com/m1ce5975f
there’s the query you need to to run inside phpmyadmin.
that will put back the admin user and give you the password of 5a4250
change the email address to match your own.
Thanks for that. I gotta figure out what it means. I’ll try to work out where I have to insert that information. Here goes…
at the top of the screen in phpmyadmin, there is a link identified as SQL.
click it.
a new page loads with a big box in it.
paste that query in to it, edit the email address, and hit “Go”
Thanks for that. I’ve got the big box open.
I’ve pasted that query (the part that’s contained within the brackets) in to it and edit the email address and hit GO…several times. I’m getting an error message. I’ll keep trying to modify it till hopefully I get it write.
Question–Do delete script below here and paste the query over it?
SELECT * FROM wp_users WHERE 1
