Really need Help!!.. Admin cant login

Hi Zen guru and followers,

i have some big problem about my admin,

Quote:

---

Originally Posted by Ajeh

You could rebuild the Admin table with the default settings via phpMyAdmin ...

First run this to remove and reset the structure:

Code:

---

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;

---

Next run this to set the login to Admin admin:

Code:

---

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

---

WARNING: be sure to reset the Admin login as soon as you have access for the Admin password and email address ...

---

and also by sense Dr.byte

Quote:

---

Originally Posted by DrByte

First, empty that table.

Code:

---

truncate table admin;

---

then run the INSERT statement

---

i have try all this code but it cant works..i dont know why..i'm quiet tired of this right know. two weeks my admin cant login because of this problem. I got this problem after i have install newsletter subcribe modules.And know i'm worried if i have a sales for past a week in my admin.

I have no idea how to settle this problem. Can guru or anyone could u help me??..please email me at support AT lighterboy DOT com.. i will give a detail about my webserver.. i really2 need help...pls

Thank you

p/s: i'm a new beginer using a zencart..some technical part i dont really familiar

Did you use phpMyAdmin?
If not try the above through phpMyAdmin....

Yes, off coz johny..

i'm insert this code on my phpmy admin before this. 1st i choose SQL tab at the top and i insert a code on the queries box and i select button 'Go'. i do it twice, first for 1st code and 2nd for another code(short code).

then,when i try login back using password and login=Admin and admin...its still didnt work...anyone help me..

I'm wait a respons from you guys...i know u are a nice people..

I'm really uncomfortable because this problem..help me guyss..:(