Zen Cart Logo
Forums / General Questions / Urgent:0 db_error_not_connected admin after changing database password on server

Urgent:0 db_error_not_connected admin after changing database password on server

Locked

Views: 2,486

Results 1 to 19 of 19
This thread is locked. New replies are disabled.
5 Feb 2010, 4:17 PM
#1
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Urgent:0 db_error_not_connected admin after changing database password on server

After our web host changed the password to my sql data base password, I'm getting this error message on my site

DB_ERROR_NOT_CONNECTED and my site won't come up. I can't get in to the admin login page either.

What files do I have to alter in order to get my site back up.

Anybody help please
Thanks,
Bob

5 Feb 2010, 4:19 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Urgent:0 db_error_not_connected admin after changing database password on server

You have 2 configure.php files where you have specified your database details.
They are probably read-only so you'll need to mark their permissions writable before you'll be able to upload any changes to them. Be sure to make them read-only again afterwards.

5 Feb 2010, 4:37 PM
#3
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

I know that one of them is in admin/includes/configure.php.
Where is the second one?
Thanks,
Bob

5 Feb 2010, 5:40 PM
#4
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

includes/configure.php
admin/includes/configure.php

Vger

5 Feb 2010, 8:07 PM
#5
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

Thank you very much, was able to locatemake the changes and voila site was restored.

I don't know what I would do without you guys.

Probably n

6 Feb 2010, 1:17 AM
#6
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

Would you beleive I got my site back Now I cant get my admin login sheet to show up. Do I have to change something in there to?
Again Thanks for your help

6 Feb 2010, 1:29 PM
#7
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

Viigor,
Would you beleive I got my site back Now I cant get my admin login sheet to show up. Do I have to change something in there to?
Again Thanks for your help

6 Feb 2010, 2:24 PM
#8
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

Would you believe I got my site back Now I cant get my admin login sheet to show up.
I made the password changes in both configure.php files and that brought my site back.
Do I have to change something somewhere else to get my login page back.
Again Thanks for your help

6 Feb 2010, 4:02 PM
#9
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

As I have pointed out - there are two configure.php files, and one of them is the admin/includes/configure.php file.

Vger

6 Feb 2010, 4:13 PM
#10
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Urgent:0 db_error_not_connected admin after changing database password on server

RobertG, your multiple duplicate posts of the same question have been merged together. Splattering duplicates all over the forum is inappropriate, especially when you're already receiving help on the topic.

ref: http://www.zen-cart.com/forum/faq.php

6 Feb 2010, 5:17 PM
#11
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

The only reason I did multiple requests is because I wasn't getting any responses for my previous messages. As I explained Three times already is the my admin login page won't come up, I did succed to get my site back up with the suggestions of VGer. His reiteration of the fix doesn't fix the admin l;ogin page.
I don't mean to be a pest, but I am nearly ready to transfer the site to a new server and I need everything to work properly.
You all have helped me immensely in the past, I'm just hoping you can do it again.
Sincerely,
RobertG

6 Feb 2010, 10:37 PM
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Urgent:0 db_error_not_connected admin after changing database password on server

What exactly do you mean by "login page won't come up"?

If you're talking about getting a "blank page", then the FAQ article I posted in your other thread about blank pages applies equally.

8 Feb 2010, 3:57 PM
#13
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

I had the server people help me this morning and they found that 2 files had been deleted from the includes/extra_configures file.
I replaced the and was able to get my Login page back as well as logged in to Admi. But now I get this message:
WARNING: The Admin Activity Log table has records over 2 months old and should be cleaned ... 12-08-2009 (in yellow) and below that

1146 Table 'vws30408.admin_menu_headers' doesn't exist
in:
[select id from admin_menu_headers where header = 'Configuration']
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.

Even using the back button on the browser doesn't allow me to do anything. How can I rectify this problem.
And again I do Really appreciate the help, I just wish I didn't to have to constantly be asking for your help.
Sincerely,
Bob

8 Feb 2010, 4:20 PM
#14
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

The table 'admin_menu_headers' does not exist in the database, and isn't even part of the default install of Zen Cart.

The Admin Activity Log notice is just telling you to clear it.

Vger

8 Feb 2010, 4:46 PM
#15
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

I understand the part of clearing the Admin activity log. Problem is where and how do I clear it. The host company tells me they can't clear logs because they track all errors etc.
Can I access this within Zen Cart application using my FTP application?
Thanks,
Bob

8 Feb 2010, 4:59 PM
#16
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

I went to Mysql data base and truncatted the account activity file. Now when I log in the The message about clearing admin activity log is gone but the bottom part is still there???

1146 Table 'vws30408.admin_menu_headers' doesn't exist
in:
[select id from admin_menu_headers where header = 'Configuration']
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.

8 Feb 2010, 5:06 PM
#17
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

The table 'admin_menu_headers' does not exist in the database, and isn't even part of the default install of Zen Cart.

That means that the table is missing from the db and will have to be created or removed from the mysql queries in the coding of the website.

Vger

8 Feb 2010, 7:15 PM
#18
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

Re: Urgent:0 db_error_not_connected admin after changing database password on server

SUCCESS:
I figured out the problem. Just prior to the site having problems due to a password change, I was in the process of installing the Admin Profile Mod. The problem was due to the fact That I hadn't finished the installation, but certain files had been uploaded to the server and were overriding some of the basic admin files. I removed all installed files and everything came back to normal.
I must admit that this has been a labor of love, The time and effort spent on building this site has been overwhelming, But with the help of several fellow Zenners I can see the light at the end of the Tunnel.

P.S. Don't get to excited I'll still have some questions to ask.
Thanks,
Bob

8 Feb 2010, 7:23 PM
#19
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Urgent:0 db_error_not_connected admin after changing database password on server

RobertG:

now I get this message:
WARNING: The Admin Activity Log table has records over 2 months old and should be cleaned ... 12-08-2009 (in yellow)
... and it tells you to visit Admin->Tools->Store Manager to clear it.