Can't log into admin

I am not sure why you would get that error as the first drops the table and rebuilds it and the second adds the login ...

NOTE: make sure that you are not using prefixes on your database table names ... if you are, you will see it referenced in your two configure.php ...

[FONT=Verdana]I just reset my hosting account and install new zen cart. After the installation I have uploaded the backup files/folders (+mysql database) to the new zen cart directory except the 2 configure.php files (to prevent from being overwritten).

The website was fine but I can't login to the admin. I enter my new username & password. But it keeps saying 'You entered the wrong username or password'. Anyone know what cause the problem? Is there any file I shouldn't overwrite?[/FONT]

Use the post above that I made for recreating the table and inserting the default login ...

Once you are logged in, then change the Admin login and password to your own ...

I tried the post above but it still says 'You entered the wrong username or password'.

Admin Username:Admin
Admin Password: admin

Can you check the file, on the server, for:
/admin/includes/configure.php

Make sure you are using the right database ...

Make sure that if you are using a prefix on your database tables that you alter the SQL statements to include those on the database ...

Is this what you meant by prefix?

PHP Code:

---

define('DB_PREFIX', 'zen_'); 


---

How should I alter the SQL statements?

Code:

---

DROP TABLE IF EXISTS YOURPREFIXHERE_admin;
CREATE TABLE YOURPREFIXHERE_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;

---

Code:

---

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

---

NOTE: the prefix is case sensative

Also, if you see both a table called:
admin
zen_admin

And you are using the prefix on your database tables, as in all start with YOURPREFIXHERE_, then the admin table should not be there ...

Finally! Thank you Ajeh. :D

You are most welcome ... :smile:

Thanks for the update that you are using table prefixes on your database and needed to update your admin table using the table prefix in the SQL statements ...

Hi,

I thought did the rest but I think I dropped the zn_admin...before running the script or something...
when I try to log in I get:
zc_admin' doesn't exist

Can I rebuild it?

Lasa