• Searched around the forums and didn’t see anything on this; my apologies if I missed it somehow.
    Tried to recover my password with the link on the bottom of the Login box. At the end of all that, I ended up with this:
    “Database error: [You have an error in your SQL syntax near ‘SET user_pass = MD5(‘f83726’) WHERE user_login = ‘E. Bess” at line 1]
    UPDATE SET user_pass = MD5(‘f83726’) WHERE user_login = ‘E. Bess’
    The e-mail was sent successfully to E. Bess’s e-mail address.
    Click here to login!”
    That syntax looks kind of right to me, but then again, I’m no expert on MySql syntax.
    Is there a fix for this? Thanks!

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter ebess

    (@ebess)

    I should add that an email got sent, but it was blank… and the password never got updated.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    If you have phpmyadmin, use this: http://www.tamba2.org.uk/wordpress/phpmyadmin/

    I get this same problem, but then when I log in after I manually MD5 my password to the new one, it does successfully log me in, but the login link takes me here:
    You don’t have permission to access /myblog/blog/wp-login.php/blog/wp-admin/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-admin/wp-admin/wp-admin/wp-admin/wp-admin/wp-admin/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-images/smilies/wp-admin/wp-admin/wp-admin/ on this server.
    Which is the login link sent in the email.

    Yeah, that’s part of my problem. I think that the SQL has an error in that it’s not specifying the table that needs to be updated.
    When I ran it in PHPMyadmin, it splurged the same error ’til I put in update wp-users set user_pass= blah blah blah.
    Still barfs me out of logging in though, even though the password’s MD5 hash is the same as the one in the database.

    To get around the MySQL bug, edit wp-login.php and change “$wpdb->users” to “$tableusers” in line 115. I don’t know if this is the best fix, but it worked for me.

    They should fix this stupid error in the nex release because it’s realy bothering people with no experience in this field. After all, If you don’t know your way around php or at least how to use phpMyAdmin and you loose your password, your blog is lost.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    This “stupid error” was fixed forty days ago with the release of WordPress v1.2.2.

    http://wordpress.org/development/2004/12/one-point-two-two/

    I dont think it was, i’m running 1.2.2 and its still the same error! I can’t, however, find the string:
    "$wpdb->users"
    in my wp-login.php file

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    You need to fix your site_url after updating. Follow this tutorial:

    http://tamba2.org.uk/wordpress/site-url/

    What I meant by it being fixed, is that it will never happen again. You still need to repair the initial occurrence.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Password recovery MySql angst’ is closed to new replies.