can't get into admin

[robert4442]

I tried twice now installinh Zen-Cart. After install( iwent through the whole process and put inall the info including the id and pass word for the admin) but it will not let me in. I tells me that I have the wrong info. When I try to use resent password it tells me the email is not correct. I have uploaded all the file each time I installed the program. I have another cart working with out any problems. Can any body help me?

[Ajeh]

To reset the Admin password on your site ...

In phpMyAdmin you could rebuild the admin table in your database so that you have the default login and password ...

If you do not use a prefix on your database tables, as in the admin table is called: admin

you can then use:

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;

and

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

If you use a prefix on your database tables, such as zen_ you could use:

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)
) TYPE=MyISAM;

and

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

Now try to login to your Admin with:
Login: Admin
password: admin

Once in, you want to edit the Login to be your own with your own password and email address in the Tools ... Admin Settings ...

NOTE: make sure that you are using the correct database that is referenced in both the:
/includes/configure.php
/admin/includes/configure.php

NOTE: make sure both of those are referencing the same server and database as well ...

[alpineaddict]

having the same problem with admin login, after installing the security patch and changing the name of my admin folder. I have since reversed all the upgrade but i am still unable to login to ZC admin. tried the SQL query and got this error:

Error
SQL query:
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 )
) TYPE = MYISAM ;

MySQL said:
#1050 - Table 'zen_admin' already exists

What next?

[Ajeh]

Please check the full commands for this ... they start with the:

DROP TABLE IF EXISTS zen_admin;

re-read my post and use the one that matches your database tables ...

[fontaholic]

thank you for this thread. i'm a zen cart newbie, but am jumping in with two feet and making a big dropship webstore to support my brick and mortar shop.

i am trying to reset my admin password, i have figured out how to run phpMyAdmin and then ran the command code (above the and) it asked me if i really wanted to do this, i said yes, and then then ran second bit of code, (INSERT INTO...) and hitting go.

clearly, this was not right, so i got the error:

MySQL said: Documentation
#1146 - Table 'icwebstore.admin' doesn't exist

so i tried running the whole code snipped again and it gave me another error, which i didn't write down but then when i tried again, it gave me:

MySQL said: Documentation
#1050 - Table 'zen_admin' already exists

there was originally an admin table in my store database when i first opened phpMyAdmin. i thought that was the correct table. was there also a zen_admin and did i change the wrong one? i'm using 1.3.8 on a local installation. i recently installed easy populate.

any advice is appreciated. i'm peeved i didn't file the password i created.

[fontaholic]

oh, and when i try to launch my admin panel, i get this:

1146 Table 'icwebstore.admin' doesn't exist
in:
[select * from 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! and THANKS!

[cobasa]

new install of latest version. couldn't access admin. this is still an issue. resend pass doesn't work. resetting values to defaults as described here doesn't work.