Problem With Lost Password

  • bgrech

    (@bgrech)


    19 years, 4 months ago

    Using Version 2 and when I go to reset a password, I get the following:
    Database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SET user_pass = MD5(’57d047’) WHERE user_login = ‘ggrech” at li]
    UPDATE SET user_pass = MD5(’57d047′) WHERE user_login = ‘ggrech’

    Warning: mail(): “sendmail_from” not set in php.ini or custom “From:” header missing in C:\Program Files\Apache Group\Apache2\htdocs\wordpress\wp-includes\functions.php on line 1384

    The e-mail could not be sent.
    Possible reason: your host may have disabled the mail() function…

    I’ve set up the php.ini but wasn’t exactly clear on what to do where it mentions the From header configuration. Also, seems to be a strange SQL error before all that. Anyone run into this?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    19 years, 4 months ago

    If you have access to phpmyadmin, reset the password manually: http://www.tamba2.org.uk/wordpress/phpmyadmin/

    Thread Starter bgrech

    (@bgrech)

    19 years, 4 months ago

    Thanks for the reply, however, I am hoping that the automated process will work.

    fridgepimp

    (@fridgepimp)

    19 years, 3 months ago

    There appears to be a bug in the wp-login.php (I just installed 1.2.2 today and had this problem). I fixed it by changing line #115. The current update query says:

    UPDATE $wpdb->users SET user_pass = MD5("$user_pass") WHERE user_login = "$user_login"

    I fixed it to say:

    UPDATE $tableusers SET user_pass = MD5("$user_pass") WHERE user_login = "$user_login"

    Once I did that, the forgotten password script worked beautifully.

    fridgepimp

    (@fridgepimp)

    19 years, 3 months ago

    The root of the above bug, as I wasn’t perfectly clear, is that $wpdb->users appears to be blank. I poked around briefly, but I didn’t see anywhere obvious where it would’ve been set anyway, so I’m guessing it’s a mistake. I could be wrong, what with my whole 20 minutes of Word Press experience :).

    fridgepimp

    (@fridgepimp)

    19 years, 3 months ago

    One final note:

    The difference appears to be a variable naming change between version 1.2.2 (and maybe before) and subsequent releases. I grabbed the nightly build for Jan 7th (tomorrow?!?) and checked. Nearly all the references to $tableusers have been replaced with references to $wpdb->users.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    19 years, 3 months ago

    Fridgepimp, please report the bug.
    http://mosquito.wordpress.org/

    fridgepimp

    (@fridgepimp)

    19 years, 3 months ago

    The bug was reported yesterday by someone else here:

    http://mosquito.wordpress.org/view.php?id=628

    It is now marked “resolved”, however it isn’t actually fixed in version 1.2.2. The resolution simply states that it isn’t a bug in 1.5. That might be useful if, say, 1.5 was the stable version that is most prominent on the “Download” page, but it isn’t. 1.2.2 is the “latest” version that is stable, so anyone who downloads it will encounter this bug.

    I thought the best way to help people get help was to post the solution here since it doesn’t look like a fix will be coming to the 1.2.x tree.

    moodspins

    (@moodspins)

    18 years, 9 months ago

    whenever a user does a lost password, they get an email, but then still can’t log in. what do I do?

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Problem With Lost Password’ is closed to new replies.