Can't log into admin

[Ajeh]

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 ...

[miles]

[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]

[Ajeh]

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 ...

[miles]

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

Admin Username:Admin
Admin Password: admin

[Ajeh]

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 ...

[miles]

Is this what you meant by prefix?

define('DB_PREFIX', 'zen_'); 

How should I alter the SQL statements?

[Ajeh]

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;

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 ...

[miles]

Finally! Thank you Ajeh.

[Ajeh]

You are most welcome ...

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 ...

[Lasa]

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