WordPress.org

Ready to get started?Download WordPress

Forums

V1.2.2 Login Error and password issue. (16 posts)

  1. Usayd
    Member
    Posted 9 years ago #

    Hey everyone, friend can't log into WordPress and is using the forgotten password. I have phpMyadmin and it seems to give you the SQL on the page when requesting the new password (prettey insecure):

    Database error: [You have an error in your SQL syntax near 'SET user_pass = MD5('b1ddba') WHERE user_login = 'user1'' at line 1]
    UPDATE SET user_pass = MD5('b1ddba') WHERE user_login = 'user1'

    Please can anyone assist me, the new sent password does not validate as the correct password and i'm stuck.
    Thanks
    Usayd

  2. hunboon
    Member
    Posted 9 years ago #

    Hi, I have exactly the same problem!

    There appears to be some problem updating the mySQL database, so it doesn't remember the new password.

    Any suggestions anyone?

  3. NuclearMoose
    Member
    Posted 9 years ago #

    What version of WordPress?

  4. Try resetting the password manually:

    http://tamba2.org.uk/wordpress/phpmyadmin/

  5. hunboon
    Member
    Posted 9 years ago #

    It's version 1.2.2.

    I only installed WP over the weekend, never realised there's a problem with the "Lost your password? " feature cos i never had to use it. :)

    So when i click on it, i'll get that error message. I'll receive an email with the new password, though it doesn't work cos the database couldn't be updated.

  6. Try resetting the password manually:

    http://tamba2.org.uk/wordpress/phpmyadmin/

  7. hunboon
    Member
    Posted 9 years ago #

    hi macmanx, it's too much hassle to reset it manually everytime someone forgets their password.

    Wonder what's wrong with the database or WP?

  8. Yes, but try to reset it manually, just once. Maybe that will fix the problem. Don't just cast it aside and wait for another solution to drop by.

  9. hunboon
    Member
    Posted 9 years ago #

    unfortunately it didn't...

    I can log in (cos I never forgot my password in the first place), but any attempt to send a new password will display that error message.

  10. hunboon
    Member
    Posted 9 years ago #

    hey I tried a suggestion in another posting and it worked for me:

    go to wp-login.php and change "$wpdb->users" to "$tableusers" in line 115

    Those with this problem can try looking at:
    http://wordpress.org/support/topic.php?id=18977

    cheers to all who responded. :)

  11. NuclearMoose
    Member
    Posted 9 years ago #

    Excellent! Nice to know you got it sorted out.

  12. Usayd
    Member
    Posted 9 years ago #

    Thanks - i'll try that, i can't really understand the other manual reset because my phpmyadmin is totally different.
    --ed
    this doesn't work, i dont seem to be able to find the string "$wpdb->users"
    hasn't this been taken out in 1.2.2? If so, now how can i solveit?

  13. hunboon
    Member
    Posted 9 years ago #

    I'm using version 1.2.2 and it's there inside wp-login.php . Did you look in the right place?

  14. Usayd
    Member
    Posted 9 years ago #

    This seems to work thanks alot guys!

  15. Usayd
    Member
    Posted 9 years ago #

    ok it seems that it now doesn't send the email...! :'(

    anyone?

  16. Usayd
    Member
    Posted 9 years ago #

    ## Fixed on latest version of WordPress (1.5)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.