Can't log in :(

[thehappyappy]

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

[kobra]

Follow the steps here
https://www.zen-cart.com/content.php...28i-lost-it%29

[thehappyappy]

Follow the steps here
https://www.zen-cart.com/content.php...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

[mc12345678]

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.

[thehappyappy]

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', '');

[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...

[kobra]

thehappyappy,

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

[thehappyappy]

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

[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

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...o-run-zen-cart

And this is most likely the cause of your issues

[thehappyappy]

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...o-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?