Problems logging into admin panel

[rocketpig]

I created a store for a customer about 6-10 months ago... Long story short, they changed the PW and then promptly forgot it (gotta love it), even the email address they used for the account (ugh).

So I went into the database and used the PW reset script from the ZenCart wiki... That didn't work. So then I used the erase and rebuild entire admin table from this forum... That didn't work either.

I don't even remember what version of ZenCart this site is using. Is there a way to figure this out without getting into the admin panel? If not, what should be my next move? Can I pull down the entire site (it's heavily customized) and just re-install it? There's virtually nothing in the store now so that isn't a real issue.

If I can't do that, is there a way to rebuild the entire database? I'm not very good with MySQL and I'm at a real loss here. Thanks in advance.

[rocketpig]

I went into the FTP site and the oldest files I could find were modded on 10/13/06... I assume that means I'm running 1.3.5... So, were the scripts I used for a newer version? Will they not work with 1.3.5?

[Ajeh]

Fixing the Admin login and password is the same regardless of version ...

Assuming that you are not using prefixes on your database tables, peek in your /includes/configure.php on the server to check, you can fix the admin table with the following commands in phpMyAdmin ...

Find the database that matches your /includes/configure.php file on the server and run these in the SQL ...

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;

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

Your login is:
Admin
Your password is:
admin

these are case sensative ...

Close your browser, clear the cache, open a clean browser session ...

Login then go to Tools ... Admin Settings ... and reset your password and email address to the correct information ...

[Ajeh]

NOTE: v1.3.5 does have some errors, security problems and lack of features compared to Zen Cart v1.3.7.1 ...
http://www.zen-cart.com/forum/showthread.php?t=69769

[artcountry1]

Hi, I've been having problems logging into admin on my site. Actually, I was having problems logging into both the one on my local computer and the one on the web. I have found this solution (the code part) works for the one on my computer, but not for the one on the web. What do I have to do to be able to log into the one on the web?

What does this mean exactly? "Assuming that you are not using prefixes on your database tables, peek in your /includes/configure.php on the server to check, you can fix the admin table with the following commands in phpMyAdmin ...

Find the database that matches your /includes/configure.php file on the server and run these in the SQL"?

I'm not sure what to do here or anything.

Please help!

[Ajeh]

On the server, you have two files that set the paths and database for your shop:
/includes/configure.php
/admin/includes/configure.php

They should match on the paths and database information ...

They also contain a line about a database prefix ... this is where a word is added to the front of the database table names so that:
admin becomes something_admin
products becomes something_products

No prefix would be:

  define('DB_PREFIX', '');

Something for a prefix would be:

  define('DB_PREFIX', 'something_');

where something_ is whatever you may have told it to use during the install such as zen_ ...

phpMyAdmin is a program that comes with your domain and is accessible via the Control Panel for your domain ...

[artcountry1]

Ok, I have these files open in my editor and I'm assuming they need to be in my custom folder in order to change them, correct? Or is this wrong in this case? I changed some things in the "define database connection" section before getting your response, putting the username and password in there. I see where the db_prefix is, but not the other part. I"m not sure what I"m supposed to put in here. Is it supposed to be the database name? I see it in the file in another spot already. Or is it supposed to be the sql database name? I"m so confused! What do I do? I feel like I"m never going to get this done...

[Ajeh]

The configure.php files belong in:
/includes/configure.php
/admin/includes/configure.php

You do NOT use overrides for these files as Zen Cart does NOT come with these files so the is no chance of an overwrite from Zen Cart software being loaded to your site ... other than your own copies of these files ...

[artcountry1]

Thank you so much for your help! It's working now and I can log in. And I made more than one login... live and learn... someone told me it's trial and error - but I wish it wasnt so much error!

Thanks again.