如何恢复prestashop的密码？

Question

I clicked on forgot password link and wrote my email but the server didn't send any information regarding password to my mail-id.I have used the following query which causes an error .Please rectify the error..

UPDATE 'ps_employee'
SET 'passwd' = md5(“<3w3kuJFFAMFB4zUR19aTDvbnomepQJFTd60NUCns5HDtqf9mEkv6APFy><samyak02>”) 
WHERE 'email' = “<[e-mail]>”;

where, 3w3kuJFFAMFB4zUR19aTDvbnomepQJFTd60NUCns5HDtqf9mEkv6APFy is the cookie_key in settings.inc.php and samyak02 is the new password I want to set.

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 ''ps_employee' SET 'passwd' = md5(“<3w3kuJFFAMFB4zUR19aTDvbnomepQJFTd60NUCns5HD' at line 1

Answer 1

You need to:

1. Register a new user/employee
2. Go to the user table, copy hashed password
3. Go to employee table, save your hashed password (just in case);
4. Paste hashed password of newly registered user into your user row (replace your hash)
5. Since PS uses the same hashing algorithm, this should do the trick.

Cheers