I'm locked out of my zen cart admin page. In fact, I tried to fix it in phpmyadmin and though I thought I knew what I was doing, I must not have. :-( However, on the good side, the store is still up...
I am wrapping up development of a store for a client and at the end went to change the admin e-mail to their e-mail address. I did, and assumed the password was the same (I didn't change it). I went to the client's computer, tried to login -- no luck. I requested a new password, the new password didn't work.
So I followed this thread: http://www.zen-cart.com/forum/showthread.php?p=456063
I have a prefix of zencart_ on my zen cart database, so I edited his SQL command:
and thenCode:DROP TABLE IF EXISTS zencart_admin; CREATE TABLE zencart_admin ( zencart_admin_id int(11) NOT NULL auto_increment, zencart_admin_name varchar(32) NOT NULL default '', zencart_admin_email varchar(96) NOT NULL default '', zencart_admin_pass varchar(40) NOT NULL default '', zencart_admin_level tinyint(1) NOT NULL default '1', PRIMARY KEY (zencart_admin_id), KEY idx_admin_name_zen (zencart_admin_name) ) TYPE=MyISAM;
Code:INSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);
I now get this messages on /zencart/admin when I try to login:
1054 Unknown column 'admin_name' in 'where clause'
[select * from zencart_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.
Your help very appreciated! I'll keep looking in phpMyAdmin carefully.