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!

[Ajeh]

In phpMyAdmin ... do you see the table name:
admin
zen_admin

What is the table name for:
products

or is it:
something_products

Read post #2 and use the correct one to fix your database table for the:
admin

the table name must match ... so if you see:
fred_admin
fred_products

you need to replace the:
zen_admin with fred_admin

if you see:
admin
products

make sure you use the code without the prefix ...

NOTE: read post #2 carefully ... I just spotted a ... umm ... typo ...

[cumbrianrider]

Hi all.

I've jus tinstalled Zencart and had a similar problem.

At first I thought I had really messed up the install but then stumbled upon an FAQ with one vital piece of info.

At present I don't have SSL on my site as not yet ready for that part.

However. On installation I kept the default setting for this part of the install. Bad move !

After looking at all sorts about reset to Admin and admin, messing with PHP files and .htaccess etc I suddenly found that the actual problem was the SSL settings !

I cannot remember now which FAQ it was but this may be your only problem with the installation. This was certainbly all that held me back from accessing my admin area. Once I edited the config file and uploaded it back to my webspace it worked no problem.

This is the enable SSL FAQ

https://www.zen-cart.com/tutorials/index.php?article=14

From what I can rememer I just left the https server bit blank i.e. remove the https://your domain bit from between ' and ' and set to false where it says true.

Hope that helps.


CR

[pts3227]

Hi all.

I've jus tinstalled Zencart and had a similar problem.

At first I thought I had really messed up the install but then stumbled upon an FAQ with one vital piece of info.

At present I don't have SSL on my site as not yet ready for that part.

However. On installation I kept the default setting for this part of the install. Bad move !

After looking at all sorts about reset to Admin and admin, messing with PHP files and .htaccess etc I suddenly found that the actual problem was the SSL settings !

I cannot remember now which FAQ it was but this may be your only problem with the installation. This was certainbly all that held me back from accessing my admin area. Once I edited the config file and uploaded it back to my webspace it worked no problem.

This is the enable SSL FAQ

https://www.zen-cart.com/tutorials/index.php?article=14

From what I can rememer I just left the https server bit blank i.e. remove the https://your domain bit from between ' and ' and set to false where it says true.

Hope that helps.


CR

I'm having a similaar issue, i was able to log in to admin recently but now I can't nothing has changed, I even created a fake site with all similar info and did a comparison and all the info seems to match and I still can't log in. Any help is greatly appreciated. I have a prefix in my login code, etc. I have all my logins and paswords written down, I know, not safe.... so I know they are correct... and I even get the email issue. Another issue, if I do get it to email me a password, it emails one to reset the password to my other cart. It seems to have the 2 mixed up, like the wires are crossed. That is why I first compared codes.... any thought????

[Ajeh]

Check the two configure.php files in:
/includes/configure.php
/admin/includes/configure.php

are you using the right URLs, paths, database table, username and password?