I am getting an increasing number of members who are unable to login after changing password via Forgot Password. When entering the system generated password from the email, access is denied. This is also the case when changing the password via admin.
Having searched the forum I found an old post from Deano on resetting the Admin password which he said would work for any user if you knew the member ID. The process is:
In phpMyAdmin run the following MySQL queries.
UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10, 36) WHERE `ID`='xxxxx';
UPDATE `Profiles` SET `Password` = SHA1(CONCAT(md5('New Admin Password'), `Salt`)) WHERE `ID`='xxxxx';
Now Delete user1.php from the cache folder on the server. (This step is important.)
This works fine but only if the member Role is set to 3 - Admin. If the role set to 1 - User, password is not recognised when logging in.
I have tried changing the user role to 3, running the above SQL, deleting cache and then setting role back to 1 but with no luck.
Other options I have tried included
Replacing memeber.php to a clean version (not that mine had be altered)
Turning off all caching
This issue does not exist for all users so I'm a bit at a loss.
Any ideas guys?