Hey everybody,

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:
Code:
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;
and then

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'
in:
[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.