cannot log into my backoffice...

[Komichi]

I know many people has create this topic. and I did went through most of them to find solution.
However, wither it did not work or I did not understand...

Could someone help me this problem? It has been more than a few days now...
I am getting really frustrated..

I get the following error when I try:

employee does not exist, or bad password

I'm sure that I have typed in all correctly.. I can see that my user does exists.. so then it must be the password I guess?

Anyway, I then decide to try genereta a new password by clicking “Lost Password”.
I type in the correct e-mail adress and then when I press send, i get this following error:

Error – No iso code for email

I did send email, but no reply yet. I would like to get started but stuck.

Would be very thankful if someone could help me out here!

[Jublo]

If you have remote connection to database, enter the database (preferably for this purpose) by MySQL Workbench. (Or with anything you can edit the database with). Google for download, if you don’t have the application. Configure connection, and connect directly from your desktop at home. Find table ps_employee. Add data for email, add data for password (by simply guessing the key, if old key is there, leave it there). Go to admin login and use new email with old password, if the password key was there. If password key was not there, and you just guessed one, regenerate the password for the email entered. If it does not work, go back to Workbench. Enter email, but for password now enter the key you know the password for. (You will need to copy that from the shop which works, and you know the IDs for). Go to admin – get in. (Done many times, transferred admins many times from production server to developing server). Quick help – this key 0985040c8d5f7fe273359598d6833702 works with this password Bp9HSL3h so if you use that key (with any email, just enter the password. Sounds complicated, but it is not.

[max99]

Hi Jublo, thanks for your post. I have exactly the same problem, and, when I ask the system to regenerate a password, it doesn't work, I don't receive any email (I checked my spam folder, but there's nothing). In the table ps_employee, I can see that I'm using the right e-mail for the loggin, so I tried to change the password directly inside this table with the one you give in your post (0985040c8d5f7fe273359598d6833702)... then, I go to my backend login page, put my e-mail adress, and the short password you give in your post, but it doesn't work... Any other idea (I'm beginner )

[Jublo]

Hi,

(Actually, you don’t sound like beginner). Was shop sending emails ok before? Regenerating is important part, even though I did find some inconsistencies there. Make sure there is a valid address in the database, and also that you save the changes while playing with the data fields. Email is independent (just tested) key vs. password is not (depending on shop version). Obviously, the third number in this game is cookie key from your /config/settings.inc.php. I just retested, making sure I have changed the cookie key, since yours is different, but all works fine. If shop works ok with the cookie key, numbers given by me on the first place will not match, which is not problem. You need to satisfy the algorithm with the variables. The fact that variables will eventually be nonsense does not matter, but you will trigger regeneration based on the cookie key in use, so emailed password will match.

[amyegrossman]

Any luck finding a solution to this issue? I am having the same problem and made the revisions recommended above without any luck. I also am not receiving an email when I ask the system to retrieve my password and send it to me.

[max99]

Hi Jublo,

Yes I'm a real beginner, as I couldn't follow your instructions, they're probably perfect but much too technical for me
I'm still not able to retrieve this password, so I guess that I'll save my layout design, and re-install it completely (my shop isn't available for customers yet, so I'm not selling for the moment online). But if you find another solution, please just post it here, as I'm not going to re-install it in the next days...

Thanks to you Jublo and to the whole community for giving support!!

Max

[Jublo]

Max, there is no need to reinstall, if shop script is still working okay. Strange password code (you can see in db field) is generated by simple function using the cookie key and new password. Do you have access to database? If you want to go straight for new password without triggering the regeneration, just create the new one. Most of ISPs give you cPanel which includes tools like phpmyadmin to edit the database. Just use it. You can change any password to whatever you want, employ password or customer password, it does not matter.
In your config directory, there is file ‘setting.inc’. Go - Right click – Open with (notepad) and look for ‘_COOKIE_KEY_’ number in quotes. Get this number (carefully) as this is your cookie key, and save it somewhere.

Open phpmyadmin tools. Locate the table ‘ps_employee’ and click edit on the employee you want to change.

In the password field first enter the cookie key (the one you extracted) followed by NEW password (word like: London) for example (you can change it later). Make sure there is no space between the cookie key and new password. In function list (left from the place where you typed cookie key and new password) select function ‘MD5’. Go all the way down and click SAVE.

Go to ‘back office’ login and use the email and new password. It is that simple. (If there was no email, edit email field for the employee you did edit). Now, this procedure must work 100% if main script is all intact. Send me PM if you still have the problem.

[bigmaxy]

Jublo! you are the man!

I struggled with this issue on MAMP but after working it out with your instructions it worked.

(I am quite a newbie so I had some difficulty with phpmyadmin )
tnx much