XF 2.2 Password reset

Realist

Member
Hi all,

I’ve ran the SQL query to reset my admin password and it’s still not letting me regain access to my account.

Any ideas?
 
D

Deleted member 232995

Guest
Hi all,

I’ve ran the SQL query to reset my admin password and it’s still not letting me regain access to my account.

Any ideas?
More info, error messages etc would be more helpful...

Code:
UPDATE xf_user_authenticate
SET data = BINARY
    CONCAT(
        CONCAT(
            CONCAT('a:3:{s:4:"hash";s:40:"', SHA1(CONCAT(SHA1('XXXXXXXXXXXXXX'), SHA1('salt')))),
            CONCAT('";s:4:"salt";s:40:"', SHA1('salt'))
        ),
        '";s:8:"hashFunc";s:4:"sha1";}'
    ),
scheme_class = 'XF:Core'
WHERE user_id = USER_ID;

Should be enough.
 
Top