Can't log in :(

I wonder if somebody could help me please. I've been working on a website that has a zen cart installed. For years I've been able to log into it but now for no reason I can no longer do so, it just says I entered the wrong username or password. I know nothing has changed and if I click to resend the password no email is ever sent.

Nothing on the server has changed so I'm puzzled as to why this is happening but would be grateful of some help please.

Thanks

Follow the steps here
https://www.zen-cart.com/content.php?44-how-do-i-change-or-reset-my-admin-password-%28i-lost-it%29

kobra:

Follow the steps here
https://www.zen-cart.com/content.php?44-how-do-i-change-or-reset-my-admin-password-%28i-lost-it%29

Thanks, I did try that but still wasn't able to log in. I tried both Admin and admin as the username and neither worked :(

thehappyappy:

Thanks, I did try that but still wasn't able to log in. I tried both Admin and admin as the username and neither worked :(

What was the SQL used to reset the password (specific SQL statement)?
What result(s) were presented when using it?
What is the value of DB_PREFIX (define('DB_PREFIX',?);) in your admin/includes/configure.php?
As the instruction states (twice) the username is: Admin, the password is all lowercase.
Start there first.

mc12345678:

What was the SQL used to reset the password (specific SQL statement)?
What result(s) were presented when using it?
What is the value of DB_PREFIX (define('DB_PREFIX',?);) in your admin/includes/configure.php?
As the instruction states (twice) the username is: Admin, the password is all lowercase.
Start there first.

I used this to create the Admin user:

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

I checked the database and the user details were there. All that happens when I try to log in is that the page refreshes and says the login details are wrong.

The configure.php file says this: define('DB_PREFIX', '');

Try:

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

Reason is, in some upgrades, I have seen that the admin profiles have been set to 0 instead of 1. An alternative is to check for that, change the value to 1 from 0 but that could also cause some other issue in the current version.

The other thing would be to upgrade ZC as there may be a PHP version conflict, but that too is to be evaluated...

thehappyappy,

What ver of php are you using?
What ver of mysql are you using?
Are you using ZenCart v1.3.9h?

mc12345678:

Try:

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

> 
> Reason is, in some upgrades, I have seen that the admin profiles have been set to 0 instead of 1.  An alternative is to check for that, change the value to 1 from 0 but that could also cause some other issue in the current version.
> 
> The other thing would be to upgrade ZC as there may be a PHP version conflict, but that too is to be evaluated...

I tried that but sadly it didn't work either :(

I'm happy upgrading if that will fix it but am reluctant to if it's not guaranteed.

kobra:

thehappyappy,

What ver of php are you using?
What ver of mysql are you using?
Are you using ZenCart v1.3.9h?

PHP version is 5.4.45
I'm not sure which MySQL version, PHPMyAdmin says this:

Server: mysql03 - 213.171.200.64 (213.171.200.64 via TCP/IP)
Server type: MySQL
Server version: 5.0.95-log - Source distribution
And the version.php file says:
define('PROJECT_VERSION_MAJOR', '1');
define('PROJECT_VERSION_MINOR', '3.9h');
....
define('EXPECTED_DATABASE_VERSION_MAJOR', '1');
define('EXPECTED_DATABASE_VERSION_MINOR', '3.9');

Thanks guys for helping with this

Well it looks like it is time for you to upgrade your ZenCart
As you are using 1.3.9h with php v5.4.45

Zen Cart v1.3.9 series is compatible with PHP 5.2.10 thru PHP 5.3.x.
https://www.zen-cart.com/content.php?48-what-are-the-server-requirements-to-run-zen-cart

And this is most likely the cause of your issues

kobra:

Well it looks like it is time for you to upgrade your ZenCart
As you are using 1.3.9h with php v5.4.45

https://www.zen-cart.com/content.php?48-what-are-the-server-requirements-to-run-zen-cart

And this is most likely the cause of your issues

Thanks for the advice, I'll upgrade it now - does it cost to upgrade? Also I didn't see a link to download the upgrade - do I have to do it within the software?

thehappyappy:

Thanks for the advice, I'll upgrade it now - does it cost to upgrade? Also I didn't see a link to download the upgrade - do I have to do it within the software?

The software is provided free. See the first page of this site: http://zen-cart.com for obtaining and for server requirements. The assistance obtained from this site is free. If you approach someone specifically, they may withholf assistance for a fee. That is up to you and them to address. A link ought to also be available (ahem) in the admin screen upper right corner, but that assumes one can get to their admin. tongue-in-cheek.

The suggested "upgrade" process for this version is a rebuild of the software with an upgrade of the database:
http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading

Thanks guys, I really appreciate you helping on this. I'll let you know how I get on!

It worked!! Thanks you so much for all of your help.

Just one question though, when I click on anything in the admin it takes me to the login page were I need to log in again before it then goes to that page - is that normal or have I missed something?

is that normal or have I missed something?
No that is not normal - have you upgraded your files?
Have you upgraded your database?

kobra:

No that is not normal - have you upgraded your files?
Have you upgraded your database?

Yes I've done both of those and have also noticed that when I save something in the admin it doesn't updated (images aren't saved to the server and changes aren't stored in the database)

thehappyappy,

Check your private messages