Can't Access Admin Page

[dkg920]

I have my zen cart set up, but made some changes to the configuration files a few months back and couldn't get back into the admin pages. I went back to the orig. config. files and changed the settings to what I thought it had been when I was able to access the admin page, but that didn't work either. I've been at this for to long. I don't want to reinstall because I have to many products in place already. Here is what comes up when I type in the url for the admin page - http://www.katestrackshack.com/catalog/admin -

0 DB_ERROR_NOT_CONNECTED
in:
[select * from kts_project_version WHERE project_version_key = 'Zen-Cart Database' ]
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.

Does anyone know what I'm doing wrong that I can't access my admin page?

Thanks!

[stevesh]

That means Zencart can't find or enter your database.

The database path and/or user name and/or password is/are wrong in admin/includes/configure.php.

Most shared server hosts add your control panel user name to the name of the database, so the database name Zencart needs would be username_databasename - you might check that.


People are still buying 8-tracks?

[dkg920]

Thanks! I'll check that.

Yes, people still buy 8-tracks! We've sold 8-tracks all over the world!

[Ajeh]

Note: your catalog shop also appears down as does the admin ...

[dezertdiva]

I am still pretty new to this, but I am having the same problem. I didn't log into my Zen Cart Admin for a while, I have a few chronic illnesses that keep me down sometimes and lately I was away getting several tests done. Then I have some down time, I may be down alot more than I would like, but I am wanting to finally get my store up and running, but my last login password is either no good or something, I don't know. I need help quick before I break something LOL!!!

[Ajeh]

Are you able to login as a customer?

If so, you might try resetting the Admin password to the defaults:
https://www.zen-cart.com/tutorials/index.php?article=2

and see if you can login that way ...

[dezertdiva]

Hi, I must have really screwed up and I don't know answers to many of your questions, except Siteground.com I am so danm stupid. I red something last night that said I just needed to go to admin/includes/, and open the configure.php and scroll down to where the password is supposed to be, and I changed it even thought I din't understand what was in its place and I didn't right it down so I can't put it back the way it was.
Oh and I usually have a super guy helping me but I think he is busy with other things right now cause I can't get a hold of him.
I appreciate you input, Maybe someday I will know enough to help someone else.
just by what I have done, can you assume (no pun intended) that I have screwed myself?
and what is this new version and how do I find out which version I have?
Oh and why does the resend on the admin login never work?
SORRY for all the questions but the more I learn, the stupider I get!
Monica King
www.dezertdiva.com

[Ajeh]

If you changed the password in the:
/admin/includes/configure.php

file incorrectly, there is the file:
/includes/configure.php

with the same information that you can refer to ...

The issue I was referring to was to reset the Admin password in the database to the default login and password ...

If you are the only one who logs into the Admin, then you can redo this by rebuilding the admin table in your database with phpMyAdmin that you should be able to access with your Control Panel for your server using in the SQL the following ...

This will remove and rebuild the admin table in your database:

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),
  KEY idx_admin_email_zen (admin_email)
) TYPE=MyISAM;

This will add a new Admin login where you can use
Login: Admin
Password: admin

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

You will then want to login and go to the Tools ... Admin Settings ... and edit to change the Login and email and then reset the password ...