[GH-ISSUE #144] Password Change not workin #93

New issue

Closed

opened 2026-02-28 01:20:56 +03:00 by kerem · 3 comments

kerem commented

2026-02-28 01:20:56 +03:00

Owner

Originally created by @righter83 on GitHub (Apr 4, 2017).
Original GitHub issue: https://github.com/tuxis-ie/nsedit/issues/144

I'm not able to change the password via "About Me".
I got no error in logs but after submit the form, there is still the old PW in the SQLite3-DB.
If i change it via "Users" tab it is workin. I see also in the nsedit logfile, that there is no username, but I can see the username in the form:

via About Me:
Updating password and/or settings for . Admin: 1

via Users:
Updating password and/or settings for admin. Admin: 1

Originally created by @righter83 on GitHub (Apr 4, 2017). Original GitHub issue: https://github.com/tuxis-ie/nsedit/issues/144 Hi I'm not able to change the password via "About Me". I got no error in logs but after submit the form, there is still the old PW in the SQLite3-DB. If i change it via "Users" tab it is workin. I see also in the nsedit logfile, that there is no username, but I can see the username in the form: via About Me: `Updating password and/or settings for . Admin: 1` via Users: `Updating password and/or settings for admin. Admin: 1`

kerem closed this issue

2026-02-28 01:20:57 +03:00

kerem commented

2026-02-28 01:20:57 +03:00

Author

Owner

@righter83 commented on GitHub (Apr 6, 2017):

I found the problem.
You send the emailadress instead of the id.
I've patched it the following way in includes/misc.php in function update_user:

if (is_numeric($id))
    {
        $q = $db->prepare('SELECT * FROM users WHERE id = ?');
        $q->bindValue(1, $id, SQLITE3_INTEGER);
        $result = $q->execute();
        $userinfo = $result->fetchArray(SQLITE3_ASSOC);
        $q->close();
        $username = $userinfo['emailaddress'];
    }
    else
    {
        $q = $db->prepare('SELECT * FROM users WHERE emailaddress = ?');
        $q->bindValue(1, $id, SQLITE3_TEXT);
        $result = $q->execute();
        $userinfo = $result->fetchArray(SQLITE3_ASSOC);
        $q->close();
        $username = $id;
        $id = $userinfo['id'];
    }

@righter83 commented on GitHub (Apr 6, 2017): I found the problem. You send the emailadress instead of the id. I've patched it the following way in includes/misc.php in function update_user: ``` if (is_numeric($id)) { $q = $db->prepare('SELECT * FROM users WHERE id = ?'); $q->bindValue(1, $id, SQLITE3_INTEGER); $result = $q->execute(); $userinfo = $result->fetchArray(SQLITE3_ASSOC); $q->close(); $username = $userinfo['emailaddress']; } else { $q = $db->prepare('SELECT * FROM users WHERE emailaddress = ?'); $q->bindValue(1, $id, SQLITE3_TEXT); $result = $q->execute(); $userinfo = $result->fetchArray(SQLITE3_ASSOC); $q->close(); $username = $id; $id = $userinfo['id']; } ```

kerem commented

2026-02-28 01:20:57 +03:00

Author

Owner

@Kraeutergarten commented on GitHub (Apr 21, 2017):

I can confirm this bug.

@Kraeutergarten commented on GitHub (Apr 21, 2017): I can confirm this bug.

kerem commented

2026-02-28 01:20:57 +03:00

Author

Owner

@tuxis-ie commented on GitHub (Apr 28, 2017):