problem with re-setting password v.1.2.2

  • mongo

    (@mongo)


    21 years, 2 months ago

    hello,

    i am running wordpress 1.2.2 ; i am running into a problem when my users forget their passwords and try to use the “retrieve password” feature. the following error is generated:

    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(‘987ac9’) WHERE user_login = ‘username” at l]

    UPDATE SET user_pass = MD5(‘987ac9’) WHERE user_login = ‘username’

    the user is sent an email with a new password but it doesn’t work–the older one still does when i tested it.

    earlier topics on this aren’t helpful as they merely say to upgrade to a higher version which i already have. any thoughts? i know how to fix it on a case by case basis via phpmyadmin but i’d rather get the correct code in the file so i don’t have to keep doing that.

    thanks in advance!

Viewing 9 replies - 1 through 9 (of 9 total)
  • Mark (podz)

    (@podz)

    21 years, 2 months ago

    Have you tried re-upgrading to 1.2.2 by using a fresh set of files, deleteing the old files before uploading those new files and then running upgrade.php ?

    Thread Starter mongo

    (@mongo)

    21 years, 2 months ago

    i began with version 1.2.2–i didn’t upgrade to it. so the only files that there are are the original files. and i haven’t messed with anything other than index.php and wp-layout.css.

    am i the only one on 1.2.2 with this problem?

    Thread Starter mongo

    (@mongo)

    21 years, 2 months ago

    apparently yes, i am the only one with this problem

    DianeV

    (@dianev)

    21 years, 2 months ago

    Sorry; I don’t know. I haven’t tried retrieving the password.

    As I recall, there were issues with cookies. Try dumping cookies after getting the password, then log in again. Did you try that?

    ronix

    (@ronix)

    21 years, 2 months ago

    Yeah. I had athe same problem. I had version 1.2.2 but I didn’t know if it was the official one. but this thread helped me out when I made these changes:

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

    from the forum:
    http://wordpress.org/support/topic.php?id=18977

    bengarland

    (@bengarland)

    21 years, 2 months ago

    Thanks for the fix! I just installed WP today for the first time and ran across this idiotic error. I can’t believe that this is a bug in a RELEASE version. I hope it’s not an omen of things to come now that I’ve chosen WordPress. :/

    bengarland

    (@bengarland)

    21 years, 2 months ago

    Actually nevermind. While this did prevent the error from occurring, I still can’t log in. Now when I try to log in, I don’t get an error — the login screen just reappears. Looks like I’m going to have to reinstall everything. Thank god I didn’t post any entries or anything before I ran into this error. This is ridiculous, I shouldn’t be running into errors 5 minutes after setting up my blog.

    Thread Starter mongo

    (@mongo)

    21 years, 2 months ago

    bump to ask if anyone has figured this out yet

    Thread Starter mongo

    (@mongo)

    21 years ago

    bueller? bueller?

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘problem with re-setting password v.1.2.2’ is closed to new replies.