Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19
  1. #11
    Join Date
    Nov 2009
    Posts
    339
    Plugin Contributions
    0

    Have a Drink 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

  2. #12
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

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

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #13
    Join Date
    Nov 2009
    Posts
    339
    Plugin Contributions
    0

    Default 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

  4. #14
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default 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

  5. #15
    Join Date
    Nov 2009
    Posts
    339
    Plugin Contributions
    0

    Have a Drink 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

  6. #16
    Join Date
    Nov 2009
    Posts
    339
    Plugin Contributions
    0

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

  7. #17
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default 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. #18
    Join Date
    Nov 2009
    Posts
    339
    Plugin Contributions
    0

    Have a Drink 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

  9. #19
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

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

    Quote Originally Posted by RobertG View Post
    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.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v151 Can't access admin section after changing DB password
    By lidlchris in forum Basic Configuration
    Replies: 34
    Last Post: 6 Oct 2015, 04:36 PM
  2. Replies: 0
    Last Post: 2 Sep 2013, 02:11 AM
  3. Urgent Please Lost admin access after DB PassWord update
    By motobuddy in forum General Questions
    Replies: 4
    Last Post: 3 Jun 2010, 05:51 AM
  4. Replies: 9
    Last Post: 12 Apr 2010, 02:00 AM
  5. Urgent: Website pictures not displaying after changing server
    By dealbyethan.com in forum General Questions
    Replies: 1
    Last Post: 14 Jan 2009, 11:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg