Locked out of admin v4.10

Hello

I really need some help please, i was trying to add my gmail as an admin but it did not work and it has locked me out.
all i did was add my email and fill out my details, i never changed the password. when i clicked save it logged me out (expected)
but when i tried to log back in it would not accept any password i tried or the original admin email, i tried the forgot password but no email was ever sent to my gmail account.
I have spent many many hours setting this site up so far and i really do not want to have to delete the whole site and reinstall nopCommerce,  and start from scratch.

Please does anyone have any idea how i can get back into my admin.

Thank you

Can do a password reset directly from admin.

PM me if you need paid help. :)

Hello

Thank you but it is a bit had to create a new login from the admin, if i can not get into the admin.

Thankfully i have an awesome host and they helped me sort it out.

So for anyone else having these problems here are a few things you can try.

https://www.smarterasp.net/support/kb/a1958/resetting-admin-password-nopcommerce.aspx?KBSearchID=494681

here are some more details to make sure you get it right.

You can log in to the NopCommerce database and search for the admin user -- [email protected] by running this SQL command against your database:


use [Database Name]

go

Select ID, Username, Password, PasswordSalt from dbo.Customer WHERE Username='[email protected]'



From the results of that command, copy the “Password” and “PasswordSalt” values.Then run this update command:


use [Database Name]

go

Update dbo.Customer

Set Password='<password copied from previous query>', PasswordSalt='<password salt copied from previous query>' WHERE ID='1';



I am very happy to get this sorted out, and i hope that these tips help any other newbies like me.

Thank you

Flatdog wrote:

Steps to Follow

1. Login to your Database using SSMS.
2. Lookout for the dbo.Customer table.
3. Edit Top xxxx rows Customer table.
4. Find the user who is locked out using Email or Username.
5. Change the CannotLoginUntilDateUtc column for the locked out user to NULL and you should login again.