Admin password not working

[Shelia]

I tried resending the password to my email address but the one that was generated doesn't work.

I know the password in the database uses md5:salt format. Anyone have a generic password I could enter into my database so I can login and troubleshoot my problem?

Somelike -

userid: Admin
password: admin

would work

[Ajeh]

Do a few searches on Admin Password on the forum and in the Wiki ... there are several threads for doing just that ...

Question is ... how the heck did you bust that? Betcha the typo monster gotcha ...

[DrByte]

http://www.zen-cart.com/wiki/index.p...me_or_password.

[Shelia]

Not only is it busted but the fix suggested did work either! I haven't upgraded to v1.3.0.2 yet, do you think that might help?

[Ajeh]

Go to your phpMyAdmin ... should be able to get to that through your website Control Panel if you do not know how to do that ...

Find your database ...

Click on the admin table ...

Click on browse ...

You should see 1 to many rows of Admin logins ...

1 of those rows should contain your admin_name and admin_email ...

Do you see more than 1 row with your admin_name and admin_email?

Note: these are case sensative

Or ... if the worse case has happened ... you can totally rebuild your admin table and paste this into the SQL of phpMyAdmin:

DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
  admin_id int(11) NOT NULL auto_increment,
  admin_name varchar(32) NOT NULL default '',
  admin_email varchar(96) NOT NULL default '',
  admin_pass varchar(40) NOT NULL default '',
  admin_level tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (admin_id),
  KEY idx_admin_name_zen (admin_name)
) TYPE=MyISAM;

INSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1); 

Your new login is:
Admin
admin

Again ... this is case sensative ...

When you get in, immediately change the email address and password to your own ...

[Ajeh]

Note: after you are all fixed up ... upgrade to v1.3.0.2 ... you need a valid admin login to upgrade ...

[Shelia]

Thanks Ajeh. I am not even gonna try to figure out what happened!
I rebuilt the admin table and I upgraded - everything is working fine.
Shelia

[Ajeh]

Thanks for the update ...