Zen Cart Logo
Forums / Basic Configuration / Cannot login to Admin

Cannot login to Admin

Views: 3,408

Results 1 to 5 of 5
5 Aug 2020, 11:35 PM
#1
kennynaq avatar

kennynaq

New Zenner

Join Date:
Jul 2018
Posts:
6
Plugin Contributions:
0

Cannot login to Admin

Hello,

I am attempting to reset the Admin password using phpmyadmin. I have tried it through the sql statement way and also editing the admin row and entering in the encoded password and i am still not allowed to log into the control panel. Can someone please let me know how to fix this issue. I am not sure of the version of zencart i am using since i cannot get into zencart.

Can someone please assist. Below is the sql query i used.

DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_profile)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

This supposably should set the username to: Admin
Password should be: admin

and i still can't log in.

Thank you in advance
Kenny

6 Aug 2020, 2:07 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Cannot login to Admin

What are the symptoms of "not allowed to log in"?

Does it give you a blank screen after submitting the page?
A specific error message?
A refresh as though you'd visited it for the first time?

When did this first begin? How does that relate to anything else you've changed about the site?

When was the last time you could login?

Is the storefront having similar login challenges when logging in like a shopper would?

Related docs: https://docs.zen-cart.com/user/troubleshooting/troubleshooting_misc/#i-can-t-login-to-the-admin-after-installing-zen-cart

7 Aug 2020, 3:23 PM
#3
kennynaq avatar

kennynaq

New Zenner

Join Date:
Jul 2018
Posts:
6
Plugin Contributions:
0

Re: Cannot login to Admin

After i put in the Admin username and password i reset it to it simply says "You entered the wrong username or password." I have tried clearing the cache and it still does not work.

7 Aug 2020, 3:46 PM
#4
kennynaq avatar

kennynaq

New Zenner

Join Date:
Jul 2018
Posts:
6
Plugin Contributions:
0

Re: Cannot login to Admin

I also do not have SSL enabled on my site yet. But in the past this has not been an issue. I tested to connection from the shopping cart to the DB by creating a new shopper account. Please help this is urgent i get in the admin section. My client cannot get in either so they cannot get their orders.

Thank you
Kenny

7 Aug 2020, 8:21 PM
#5
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,771
Plugin Contributions:
9

Re: Cannot login to Admin

What other recent changes have been made? Is the site SSL or not? ZC version? Have you tried to check for a bad table in the phpMyAdmin?

In past similar situations, we have also found that an SSL change or 301 can block access. Is your admin expecting a certain URL and an added .htaccess setting is keeping you out?

e.g, if your site is set to redirect to http://www.YOURSITE.com but your SSL is for https://YOURSITE.com, you might be blocked if you use the wrong URL combination.