WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Emergency!!! WordPress no longer recognizes my admin user log in (30 posts)

  1. kelly1878
    Member
    Posted 5 years ago #

    Hello,

    I currently run a blog at http://thelesbianlifestyle.com. I had been getting an error when loading the blog telling me I was using too much CPU in a 60 second rolling window. It stated I may be running too many PHP scripts.

    I decided to log on to my server and putz around. MISTAKE. I Noticed a section on my Bluehost.com control panel that talked about PHP scrips and SQL. I clicked on a few but didn't do anything. After reading I could tell it was above and beyond my knowledge.

    I also opened my ftp. I went into my WordPress Content/ Themes folder. I noticed that the Default and Classic theme were still there. I had a custome theme made so figured I would never need them so I deleted them.

    I clicked back on my blog and it opened up just fine. I went to login and plugged in my user name and password. It is now telling me that I am not a registered user. This sucks, as I am the blogs admin and it was under that user name that I make all the changes.

    I did try to register using another email address. I never got an email confirmation to the new address.

    At this point I am totally locked out of my blog and in a state of panic. Any help would be wonderful!

    I've learned my lesson,

    Kelly

  2. MichaelH
    Member
    Posted 5 years ago #

    I'd restore the wp-content/themes/default folder. In fact, this is a good time to upgrade to 2.6.5. See Upgrading WordPress Extended.

    As for the login, here's some things to try if you can't login after the upgrade:
    1. logout or logout with http://www.yourdomain.com/wp-login.php?action=logout
    2. disable all plugins--if necessary read How to deactivate all plugins when not able to access the administrative menus?
    3. clear cookies
    4. exit browser
    5. make sure local firewall is not causing problem
    6. login with http://www.yourdomain.com/wp-login.php

    If WordPress is installed in something other than the root folder please take that into account for the above url examples

    Please let us know what does solve your problem.

  3. kelly1878
    Member
    Posted 5 years ago #

    The issue is that I've always upgraded with the WP Automatic Upgrade plugin. I don't know how to do it manually.

    Here's another note on what I did. I was in the Bluehost.com control panal and click on PHPMyAdmin. I saw that there was a list of plugins in this database. Some of which I was no longer using. I deleted the wp_wassup plugin. After frantically doing some research I see that i have a wp_usermeta database.

    Did deleting the wp_wassup plugin in PhPMyAdmin mess this up. I'm sorry I'm just freaking out at the moment. I have a lot going on at the blog right now and want to get this fixed without having to start all over again.

  4. omgitztrey
    Member
    Posted 5 years ago #

    wp_wassup would not interfere with wp_usermeta.

    Everything in that table refers to access levels, bios and stuff for the users.

  5. kelly1878
    Member
    Posted 5 years ago #

    I'm thinking I may have messed with a database.

  6. kmessinger
    Volunteer Moderator
    Posted 5 years ago #

    First stop clicking around :^) Contact your host and see if they, by pure chance, have a back up of your db.

    Otherwise or in addition, if you don't want to upgrade or can't follow MichaelH from the second paragraph and don't forget to check the links he provided.

  7. BernardBorealis
    Member
    Posted 5 years ago #

    You can also try changing your user and password directly through the database using phpmyadmin: http://www.tamba2.org.uk/wordpress/phpmyadmin/ however, I agree with kelly1878 about seeing if just by chance there is a backup available.

  8. BernardBorealis
    Member
    Posted 5 years ago #

    Sorry, kelly1878, I meant I agree with kmessinger about what he advised for you. :)

  9. PyKorry
    Member
    Posted 5 years ago #

    Thank you MichaelH for this tip:
    2. Disable all plugins--if necessary read How to deactivate all plugins when not able to access the administrative menus.

    Like kelly1878, my host is Bluehost, and I upgraded to 2.6.3 using Fantasico, and it seems the program did not deactivate the plugins -- which resulted in WP not recognizing my Username and password.

    It's took a bit of hunting but I finally found how to do the following on phpMyAdmin:

    In the table wp_options, under the option_name column (field) find the active_plugins row
    Change the option_value field to: a:0:{}

    After that, I was able to log in to my dashboard, deactivate the plugins, and do the upgrade to 2.6.5 using Simple Scripts (through my cPanel on Blue Host) without any problem.

    Cheers!

  10. KellyLes
    Member
    Posted 5 years ago #

    Kelly here. My webdesign company wants to charge me 100/hr to look into this issue. I attempted the suggestions above to no avail. If anyone can give me any further help on this matter I would be in debt to you. I do not have the money to have this researched, nor do I have the know how to further researchi it myself.

    At this time I am not able to log on to my WordPress account. Nor are any of the over 200 registered authors. No new user registrations are being processed.

    I attempted the fix that PyKorry suggested and this did not work for my blog. I am still currently in a panic and would be so greatful to anyone who could work with me to look into this issue further.

    Thanks in advance,

    Kelly

  11. whooami
    Member
    Posted 5 years ago #

    I attempted the suggestions above to no avail.

    which suggestions?

    // taking notice of all the ads on that site. thats called $$$

    I do not have the money to have this researched

    Just pointing out that while we are happy to help you to the best of our ability for free, no-one here is blind or dumb.

  12. KellyLes
    Member
    Posted 5 years ago #

    I never thought anyone here was blind or dumb. Quite the contrary. I don't charge hardly anything for the ads and the money raised goes to the blog awards the site hosts the first of each year. I am by no means attempting to fool anyone into helping me. I am honestly at a standstill with this issue.

    I tried the suggestions given by MichealH and PyKorry. I did notice something however. BernardBorealis suggested that I try changing my user and password directly through the database using phpmyadmin: http://www.tamba2.org.uk/wordpress/phpmyadmin/.

    I went to this site and attempted to follow the instructions. I noticed that I do not have a wp_users database, but do see the wp_usermeta. Could it be that I mistakenly deleted the wp_users database and that is causing the issues? If so is there a way to correct this?

  13. mikey1
    Member
    Posted 5 years ago #

    My webdesign company wants to charge me 100/hr to look into this issue.

    I'd be downloading a copy of my database and heading for the airport by now. LOL

  14. Bob Smith
    Member
    Posted 5 years ago #

    @ whooami

    what do you do around here but just rag on people all day who are frustrated and looking for help?

    you have nothing constructive to offer. getting outside once in awhile may help you get some perspective.

  15. Bob Smith
    Member
    Posted 5 years ago #

    @ KellyLes

    just ignore whooami's posts. he just rags on people here all day. hope you get your issue sorted.

  16. whooami
    Member
    Posted 5 years ago #

    hey bob, why dont YOU help her, big guy?

    wtf are you anyway? Youve been here 6 months and EVERY single (-1) one of your posts is about your blog being hacked.
    Your quite the mentor, right?

    Oh and ps, im a female. get your gender right, BOB. Believe it or not, they allow women on the web.

    Now, since you have answered the question, and then some, I can tell you what the problem is, Kelly.

    I do not have a wp_users database

    Right there.

    Do you have backup of your database?

    Failing that, I can give you a query that will recreate the table, and make an admin account, but your 200 users are going to be SOL.

  17. KellyLes
    Member
    Posted 5 years ago #

    I use the automatic wordpress upgrade plug in. The last backup file I have is from 9/9/08. I looked in the file and folders and couldn't find anything that was labeled wp_users. Can you tell me where it would be located within the backup files?

  18. whooami
    Member
    Posted 5 years ago #

    its not in a file normally. Its in your database.

    I dont use that plugin, so I dont know if it makes a backup of the database.

    Is there anything named qwerty.sql where qwerty could be anything else?

  19. KellyLes
    Member
    Posted 5 years ago #

    Is there any way to pull from the wp_usersmeta database? It seems that all the authors are still listed there.

  20. whooami
    Member
    Posted 5 years ago #

    Like I said, it the wp_users table not being there, that is the issue. That table stores the passwords and the emails.

    So no. You could use that data to recreate a list of users, thats all.

  21. KellyLes
    Member
    Posted 5 years ago #

    I am currently downloading a backup from 11/22/08. I will let you know what I find as soon as it is finished. I can't thank you enough. I hope this works!

  22. KellyLes
    Member
    Posted 5 years ago #

    Ok I downloaded the system backup called weekly.tar files from 11/22/08. I have opened it, but I am not sure where to find the wp-user database. There is no file that specifially states "Database" Do you have any direction?

    Here's a link to a screen shot of the file I downloaded and am currently looking at.

    http://img115.imageshack.us/my.php?image=weeklyja2.jpg

  23. whooami
    Member
    Posted 5 years ago #

    I dont see any image on that page.

    Here are the 2 queries you need to do inside phpmyadmin:

    http://pastebin.com/d4af81056

    The resulting password is included.

  24. whooami
    Member
    Posted 5 years ago #

    Do you have any direction?

    From one of my previous posts:

    Is there anything named qwerty.sql where qwerty could be anything else?
    Also, look for anything ending in a .gz or .zip prefix

  25. KellyLes
    Member
    Posted 5 years ago #

    I could not open http://pastebin.com/d4af81056

    I found the following files:

    mysql which contains:
    thelesb1_wrdp1.sql
    roundcube.sql
    horde.sql

    Would it be easier for you to log on to my cpanel or is that unheard of. As you can tell I am separate at the moment.

  26. whooami
    Member
    Posted 5 years ago #

    thelesb1_wrdp1.sql <-- thats what you are looking for.

    its a text file, open it in wordpad. Right click on the file, scroll to open with, and pick wordpad.

    Scroll the file until you find:

    CREATE TABLE IF NOT EXISTS wp_users

    or something very similar.

    (the necessary backticks are bing stripped out of my post above. meh.)

    The pastebin site is down right now, I just tried.

  27. whooami
    Member
    Posted 5 years ago #

    send me the sql file. if the info is in there, Ill be happy to put it back in your database.

    I am going to sleep though, (I work overnights, 12 hour shifts, and have been up way longer than normal).

    my e-mail is whoo at my domain.com, which is -> village-idiot.org

    If I dont respond immediately its because ive passed out. But I will look at the sql file, and reply when I wake up.

  28. KellyLes
    Member
    Posted 5 years ago #

    Found it!!! I will send it to the email you advised. Along with the info you will need to log onto my cpanel. Thank you Whoo!!!

    Kelly

  29. KellyLes
    Member
    Posted 5 years ago #

    It's fixed!!! Wooami you are a life saver!!! It seems that I deleated my wp_users database. Thank God I had a backup of the database. Thank you, thank you, thank you!!!

  30. Bem Florido
    Member
    Posted 5 years ago #

    Hi, I've opened my blog in December,2008 and only now I've tried to get back to it. WordPress says my password is wrong. I can't find the registered email when I ask for a new password. I'd like to remove my blog (bemflorido.wordpress.com) and start a new one. Help me, please.
    Sandra

Topic Closed

This topic has been closed to new replies.

About this Topic