Forums / Installing on a Windows Server / Can't Access Admin Page

Can't Access Admin Page

Locked

Views: 6,143

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
17 Oct 2008, 3:34 PM
#1
dkg920 avatar

dkg920

New Zenner

Join Date:
Dec 2007
Posts:
13
Plugin Contributions:
0

Can't Access Admin Page

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!

17 Oct 2008, 4:50 PM
#2
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Can't Access Admin Page

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?

21 Oct 2008, 2:22 AM
#3
dkg920 avatar

dkg920

New Zenner

Join Date:
Dec 2007
Posts:
13
Plugin Contributions:
0

Re: Can't Access Admin Page

Thanks! I'll check that.

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

21 Oct 2008, 3:51 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can't Access Admin Page

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

16 Mar 2009, 3:58 AM
#5
dezertdiva avatar

dezertdiva

New Zenner

Join Date:
Sep 2008
Posts:
2
Plugin Contributions:
0

Re: Can't Access Admin Page

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

16 Mar 2009, 2:49 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can't Access Admin Page

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

16 Mar 2009, 11:49 PM
#7
dezertdiva avatar

dezertdiva

New Zenner

Join Date:
Sep 2008
Posts:
2
Plugin Contributions:
0

Re: Can't Access Admin Page

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.:oops:
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?:unsure:
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!:frusty:
Monica King
https://www.dezertdiva.com

17 Mar 2009, 3:19 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can't Access Admin Page

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!