I can't Log In to Admin after install/move to a new server

After installed the software on the server (dreamhost.com) (FTP).

I can't see how to go to Admin session to manage the webpage, but I can do so from the link they provided.

https://www.unisupport.co.uk/admin

But when I tryed to log in it doesn't. So, I've tryed many times to log in to Admin by asking many times for a new password I still can't log in to Admin.

On FTP I've added 777 on admin/includes/configure, and haven't worked either.

I just don't know what to do.

Can you help me please?

Sidney

A search in the upper left search box for: Admin password reset

would provide you with quite a few posts on fixing this ...

one such as:
http://www.zen-cart.com/forum/showthread.php?t=36258&highlight=Admin+password+reset

Ajeh:

A search in the upper left search box for: Admin password reset

would provide you with quite a few posts on fixing this ...

one such as:
http://www.zen-cart.com/forum/showthread.php?t=36258&highlight=Admin+password+reset

Hi there, where can I run the info 'codes' you gave me?

Where can I Create a table adimin on?

By the way, I am on Windows. (I have ubuntu as well)

First run this to remove and reset the structure:
Code:

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;

Next run this to set the login to Admin admin:
Code:

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

WARNING: be sure to reset the Admin login as soon as you have access for the Admin password and email address ...

---

Linda McGrath

Thank you.

Sid

Ajeh:

You could rebuild the Admin table with the default settings via phpMyAdmin ...

First run this to remove and reset the structure:

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;

> 
> Next run this to set the login to Admin admin:
> ```
INSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

Can you please, explain each of this lane for me? I know it can work but I don't know how to apply. PLEASE!!! (I also know that it is going to be an extra work for you, but please!

WARNING: be sure to reset the Admin login as soon as you have access for the Admin password and email address ...

where is the phpMyAdmin? to remove and reset the structure?
what is it DROP TABEL IT EXIXTS admin?
where to CREATE TABLE admin to save where? (w'd it be text editor? if so save with what namne?)
what is admin VALUES? And how to apply the VALUES?

SORRY FOR BEING SO STUPED, I JUST DON'T KNOW?

I just want to be able to log in into Admin.

RGDS.

UNI

Hi there

You don't need to explain every thing know more about phpMyAdmin.

The only thing I don't know is the procedute to create and save.
because when I tryed to save, whate ever I put, a warning came up "this is not a number".

So I still need your help,please.

uni

1. Open phpMyAdmin
2. Select your Zen Cart database from the pulldown list
3. Click on the SQL tab in the top center
4. In the query box, paste the commands suggested earlier, and click Go.
5. Your password information will be wiped and reset to Admin->admin

DrByte:

1. Open phpMyAdmin
2. Select your Zen Cart database from the pulldown list
3. Click on the SQL tab in the top center
4. In the query box, paste the commands suggested earlier, and click Go.
5. Your password information will be wiped and reset to Admin->admin

Thank you. I can log in now.

Can you please tell me where can I go, in admin, to change the pictures. Because I've chosen zen pre-done, but there are pictures of products that I will no sell.

So I need to upload my pictures and add others coments,

Where can I go?

Uni.

Continued here:
http://www.zen-cart.com/forum/showthread.php?t=42917

uni:

Originally Posted by DrByte

1. Open phpMyAdmin
2. Select your Zen Cart database from the pulldown list
3. Click on the SQL tab in the top center
4. In the query box, paste the commands suggested earlier, and click Go.
5. Your password information will be wiped and reset to Admin->admin.

Dr..yes i paste the code in the box..but it have two code . and where this box need to be put??

Next run this to set the login to Admin admin:..where is this??
code:
INSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

i always repeat this thing. and when i put Admin as username and admin as password..ot cant works..how?

I've ran that script and reset the user to Admin and pass admin several times. It doesn't seem to be working for me.

http://www.hienquoc.com/domains/runningonthyme/admin

I know its a huge vulnerability but can someone log-in? I'll reset everything later. I'm just transfering the website to a different server and we're not really using it for business at the moment.

This is what I see when I upload the sql commands from a text file
Import has been successfully finished, 2 queries executed.
SQL query: DROP TABLE IF EXISTS admin;# MySQL returned an empty result set (i.e. zero rows).
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 ;# MySQL returned an empty result set (i.e. zero rows).

----------------------------- And then I see below when I set the "Admin" user and "admin" password

Inserted rows: 1 (Query took 0.0004 sec)
SQL query: INSERT INTO admin
VALUES ( 1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1 ) ;

thanks,

I know its a huge vulnerability but can someone log-in? I'll reset everything later. I'm just transfering the website to a different server and we're not really using it for business at the moment.
Will try with pleasure for you but NOT without admin name and password??
:wink:

isn't suppose to be default zencart password

User: Admin
pass: admin

I know it's tempting but please try not to mess with it if you get in ;)
?

Visited, tried using that info..failed...
which version of zencart have you installed?

The latest and greatest version. I couldnt' find which version I originally installed it on. I just dropped my old files and overwrote the new ones. I also dropped the database and replace it with my old one

I noticed my admin table doesn't have the prefix like all my other tables in the database. Could this have something to do with it? I put the prefix that it uses in the admin/includes/config.php

would it be trying to look for the admin table with the prefix in front of it?

The latest and greatest version. I couldnt' find which version I originally installed it on. I just dropped my old files and overwrote the new ones. I also dropped the database and replace it with my old one
Not sure this was good idea, especially as you cannot remember which version of zencart you are overwriting and are then using its database...
ADVICE...start from scratch and install brand new version
of zencart..

That is what I basically did. i started with a fresh install. I had everything working. Then i dropped my old files to overwrite it except the config.php files and replaced my database with the backup version

https://www.zen-cart.com/tutorials/index.php?article=98
Did you follow, step by step, instructions above for upgrading zencart?

alright thanks people... it was a prefix deal. It had two tables admin and one with my prefix and admin. So it was using the prefix admin table and not the admin table by itself.

I also used the old password I had on it and that worked. So using the script to reset the wrong table doesn't help when your using the wrong admin table. Hope someone checks that too when they have problems.

thylow:

alright thanks people... it was a prefix deal. It had two tables admin and one with my prefix and admin. So it was using the prefix admin table and not the admin table by itself.

I also used the old password I had on it and that worked. So using the script to reset the wrong table doesn't help when your using the wrong admin table. Hope someone checks that too when they have problems.
Pleased to hear problem sorted..well done!!
:clap: