Can't log in to admin...

[khopek]

It seems to be working fine now.

I just wish I new what caused it.

The only thing I have done in the past two weeks is install stock by attributes and edit orders.

[Coptic Soldier]

Look at your database ...

Is the database table via phpMyAdmin called admin or does it have a prefix?

NOTE: if it has a prefix so do all the tables ...

If the table is called admin uses the following:

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),
KEY idx_admin_email_zen (admin_email)
) TYPE=MyISAM; 

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

If the admin has a prefix such as zen_admin then use the following where the admin is changed to zen_admin or whatever your prefix is:

DROP TABLE IF EXISTS zen_admin;
CREATE TABLE zen_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),
KEY idx_admin_email_zen (admin_email)
) TYPE=MyISAM; 

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

Your login is now:
Username: Admin
Password: admin

Those are case sensative ...

Then go to the Tools ... Admin Settings ... and reset your email and password once you get in ...

i have been following all the suggestion to this thread and got to this point......now my log in page reads

1146 Table 'hiphopsp_store.hiphopsp_admin' doesn't exist
in:
[select * from hiphopsp_admin where admin_name='demo' or admin_name='Admin']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

help