Can't login or reset password

[1Mweeks]

I've been searching for awhile, and maybe missing something easy but I can't login or reset my password and not sure where to look.

Tried e-mailing it, didn't work.

Logged into mysql and ran this code (I have 1.3 and the configure.php shows "define('DB_PREFIX', 'store');" as a prefix):

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

The response I keep getting is this:

SQL query:

DELETE FROM store_admin WHERE admin_name = 'Admin';

MySQL said: Documentation
#1146 - Table 'hailivestore.store_admin' doesn't exist

Any thoughts what to try next? Thanks again for the help in advance!

[stevesh]

Did you see this in the tutorial?

NOTE: If you are using a prefix for your database tables, you'll naturally need to add that prefix to the table name above.
ie. "DELETE FROM prefix_admin ... " and "INSERT INTO prefix_admin ..." ... replacing "prefix_" with your actual tablename prefix.

[DrByte]

@stevesh, he already posted that he used 'store_' as the prefix.


@1Mweeks: However, the error is that DB_PREFIX is 'store', not 'store_' ... so the tablename shouldn't be 'store_admin'; it should be 'storeadmin'.

[tmacarle]

I apologize if this is not supposed to be here, but I am having the same problem. This is the first issue I have ever had losing a password, but I tried to log in and the password was incorrect. I of course tried every variation I have ever thought of, and then tried the 'forgot password' link. The email never came to any of my inboxes, and I even got a green text reading that it was sent. I have found in the 'configure' php the username and password for the DB but this is for the database, not the admin panel. I cannot figure out how to reset this or get into my admin website, can anyone please help me with this issue at least with something to try? Thank you. I am using version 1.5

[DrByte]

I apologize if this is not supposed to be here, but I am having the same problem. This is the first issue I have ever had losing a password, but I tried to log in and the password was incorrect. I of course tried every variation I have ever thought of, and then tried the 'forgot password' link. The email never came to any of my inboxes, and I even got a green text reading that it was sent. I have found in the 'configure' php the username and password for the DB but this is for the database, not the admin panel. I cannot figure out how to reset this or get into my admin website, can anyone please help me with this issue at least with something to try? Thank you. I am using version 1.5

You will probably need to reset it using phpMyAdmin: http://www.zen-cart.com/content.php?...admin-password