Jump to content

Error Meassage Shown "employee does not exist, or bad password"


Recommended Posts

My site was being hacked. I cleared all the data stored in the database and re-installed the whole prestashop.
However, this time, i was not able to log in and error meassage shown "employee does not exist, or bad password". There was no mail notification from prestashop though i had request during the system setup.
Please advise how to solve this problem


Link to comment
Share on other sites

If you’re like me and you tried the “lost password” link on prestashop’s backend and never received the email, you might try this solution if you have access to the database. Look in config/settings.inc.php for the _COOKIE_KEY_ as you’ll need that. Run the following SQL and replace the <> variables with your information.

UPDATE employee SET passwd = md5(”<_COOKIE_KEY_>”) WHERE email = “youremailaddress”;

hope that helps

define('__PS_BASE_URI__', '/');
define('_THEME_NAME_', 'prestashop');
define('_DB_NAME_', 'chippedm_andy');
define('_DB_SERVER_', 'localhost');
define('_DB_USER_', 'chippedm_andy');
define('_DB_PREFIX_', 'ps_');
define('_DB_TYPE_', 'MySQL');
define('_COOKIE_KEY_', 'w7n3HwABF81c8KOFYGAuRav9I2TwjN0p3nXV4H0q56HEJFSJKXLiUTO4');
define('_COOKIE_IV_', 'RJMWMUsn');
define('_PS_VERSION_', '');

Link to comment
Share on other sites

Thanks for the info.
under the ps_employee table, the passwd field;
However, i'm not able to find the column for "variable", so that i can insert the password into it
Please advise!

Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...

Hello Newcomer,

COOKIE_KEY: ‘hgI3M9S1Uv45wDqkqvGNYF.xAamJY9.zKpykqHCgCxE5m1ozAtQBjFIi’
New pass: myPasswordWith8Characters
Email: [email protected]

INSERT INTO ps_employee SET passwd=md5("hgI3M9S1Uv45wDqkqvGNYF.xAamJY9.zKpykqHCgCxE5m1ozAtQBjFIimyPasswordWith8Characters") WHERE email="[email protected]"

Password (new as old) must have at least 8 characters!


Link to comment
Share on other sites

  • 2 weeks later...

Hi Handy,

Still failed to solve the problem, same error message of “employee does not exist, or bad password” appear when logging in.

New pass: testing123456
Email: [email protected]

Input SQL query as shown below:

UPDATE ps_employee SET passwd = md5('wK3dFLohdXUrSCiYQY7dJk3roL8FRIOpEpy1EL9M6mOURsKrtLcAMAVbtesting123456') WHERE email = '[email protected]';

Link to comment
Share on other sites

Hi Handy,

Thanks a lot for your advise.

However, i still failed to solve the problem. Maybe i should brief you i have done.

- Log in to the database
- click on "SQL" button
- paste the (INSERT INTO ps_employee SET passwd=md5("ead3c46b93b49519c0badf5762879711") WHERE email="[email protected]") into the SQL coloum
- Submit

Go to my site login,
username: [email protected]
password: testing123456
Error message: employee does not exist, or bad password

Would be appreciating, if you could send me your personal e-mail add, so that i can send you all the details for my DB for your easy reference.


Link to comment
Share on other sites

Hi Handy,

Attached the file for ps_employee, however, we changing the value of null from 0 to 1, the following error message appears.


SQL query: Edit

INSERT INTO `property666`.`ps_employee` (
`id_employee` ,
`id_profile` ,
`lastname` ,
`firstname` ,
`email` ,
`passwd` ,
`last_passwd_gen` ,
`stats_date_from` ,
`stats_date_to` ,
'1', '1', '', '', '', ' ', '2009-10-10 14:40:47', '2009-10-01', '2009-10-01', '1'

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1


Link to comment
Share on other sites

Hello Heng,

Fill "lastname", "firstname", "email" and "passwd" fields:

"lastname" field: HENG

"firstname" field: Zimy

"email" field: [email protected]

"passwd" field need to be fill with this MD5 generated password: ead3c46b93b49519c0badf5762879711.

You can use this website to generate your MD5 password:


Like that:


For you, it's:


Click on "Hash" button. Copy/Paste md5 checksum result on "passwd" field.


Link to comment
Share on other sites

  • 1 month later...
  • 3 weeks later...
Hi guys, I have the same problem. Ive tried to do all the things described, but nothing helps... Please, tell what to do.

i had this same problem too. i think there is a bug.
FINALLY this worked for me:
I had to leave the “send email notifications” checkbox at the bottom of step 4. shop configuration UN-CHECKED.
and don't upload logo file.

Later u can upload logo.jpg file in like this img/logo.jpg

Hope it helps u all.

Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...