Cannot reset admin password

[bishoptech]

one other thing. At the top of the site it has the error "Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels." I cannot look into this of course because I cannot log in as admin. Does this help any?

[DrByte]

one other thing. At the top of the site it has the error "Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels." I cannot look into this of course because I cannot log in as admin. Does this help any?

Zen Cart consists of two pieces that must match: PHP files and Database data. If you upgrade PHP files and don't upgrade the database, or vice-versa, you'll get that sort of error message.
You'll sometimes get that message if you've been hacked and the hackers have damaged any of the files or database records involved in the version detection process.

So, since you're getting that message, it suggests you've got PHP files out of sync, which coincides with my suggestion to carefully inspect everything on your site to figure out what's different from the original files, and sort out whatever you discover.

[nigelt74]

I only get it when trying to log in with an admin account, and with nonexistent customer accounts.

You aren't perchance trying to login to admin, in the catalog section of the site where the customers login are you,?

Customers and admin have completely seperate login pages, in completely seperate parts of the site

your admin login page would be

yoursite.com/your_adminfoldeerrname/

--- had to explain this to someone for the umpteenth time a few days ago

[danbro0811]

that was the post that I originally started with.

I lost my Admin login password. So I clicked on "Resend Password" to get a new password. That was two days ago and I have still not received a new password. I have tried a few more times. Still no luck. I am positive my email address works because I have verified it from another address. So how can I retrieve a new password. Need to get into my Admin ASAP.

[RescoCCC]

I lost my Admin login password. So I clicked on "Resend Password" to get a new password. That was two days ago and I have still not received a new password. I have tried a few more times. Still no luck. I am positive my email address works because I have verified it from another address. So how can I retrieve a new password. Need to get into my Admin ASAP.

https://www.zen-cart.com/tutorials/index.php?article=2

[danbro0811]

Yes, I've already been to that page, but it wasn't helpful. I'm not a tech guy, so all this stuff is pretty much Greek to me. My hosting company is Hostmonster, if that tells anyone what I'm dealing with. The Zen-Car tutorial says to "Open your phpMyAdmin (supplied by your hosting company), select your store's database, then click the "SQL" tab and run this query." OK, first of all, I see no option for "phpMyAdmin." There is one called php Config. However, when I go to that page, I see no SQL tab. So what do I do now?

[RescoCCC]

Yes, I've already been to that page, but it wasn't helpful. I'm not a tech guy, so all this stuff is pretty much Greek to me. My hosting company is Hostmonster, if that tells anyone what I'm dealing with. The Zen-Car tutorial says to "Open your phpMyAdmin (supplied by your hosting company), select your store's database, then click the "SQL" tab and run this query." OK, first of all, I see no option for "phpMyAdmin." There is one called php Config. However, when I go to that page, I see no SQL tab. So what do I do now?

Log in to your cPanel, which is usually yourdomain.com/cpanel. Once in there, look in the section headed "Databases". There you will find phpMyAdmin.

[danbro0811]

OK, found that. Now here's the problem. I click on the tab "SQL" which opens the query window. Then I copy the query code into that window: FROM/INTO prefix_admin
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 run the query, but then i get the following error message:

Error
SQL query:
FROM / INTO prefix_admin DELETE FROM admin WHERE admin_name = 'Admin';
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM/INTO prefix_admin
DELETE FROM admin WHERE admin_name = 'Admin'' at line 1

Now what do I do? I also tried using the other code.

I appreciate you help.

[RescoCCC]

First, did you use the correct version of the patch? There are two; one for 1.39 and the other for 1.5. If you're sure you used the correct version then it's likely you pasted it in incorrectly. Make sure you didn't accidentally truncate it, and make sure you don't have extra spaces at the top or bottom. Use only a plain text editor to do the copy/paste.

PS: Also check to make sure you're not using table prefixes. If you are, you need to edit the patch to add the prefix.

[RescoCCC]

Okay, I think I see the problem. You followed the instructions for databases that use a prefix by appending "prefix" to the table name. If you are using prefixes, the name would be whatever was assigned then the database was created, not "prefix". If you aren't using prefixes, just install the patch as written.