Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    21
    Plugin Contributions
    0

    Default Had to reset admin login details in DB now problems in admin area

    Hi Everyone,
    I have a site I had been working on for some time - no problems at all. Using V 1.5

    Anywho went to login today after approx 6-8 weeks of not logging in and problems with password / username so tried to reset via the reset button which the email was coming through but there was no temporary password

    SO moved onto resetting via the DB.

    NOW thats all good - I can get in with Admin / admin login and have the following highlighted in Yellow across the top.

    Warning: Your Admin login is not secure ... either you still have default login settings for: Admin admin or have not removed or changed: demo demoonly
    The login(s) should be changed as soon as possible for the Security of your Shop
    Go to Tools->Admin Settings to change login IDs and passwords.
    For additional Security for the Admin please see the /docs

    OK so again thats fine until I try and go to TOOLS - instead of saying Admin Settings or even remotely similar it says BOX_TOOLS_ADMIN

    and again an error:

    Admin Settings

    1054 Unknown column 'admin_level' in 'field list'
    in:
    [select admin_id, admin_name, admin_email, admin_pass, admin_level from znc_admin order by admin_name limit 0, 20]
    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.

    No idea why??

    This was a fresh install months ago - yes using a template that worked for a long time, until today.

    Any help would be appreciated as I have googled and looked through I think everyone possible!

    Alison

  2. #2
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: Had to reset admin login details in DB now problems in admin area

    Quote Originally Posted by aliali81 View Post
    OK so again thats fine until I try and go to TOOLS - instead of saying Admin Settings or even remotely similar it says BOX_TOOLS_ADMIN
    This is telling us that something is amiss with your english.php language file.

    Quote Originally Posted by aliali81 View Post
    1054 Unknown column 'admin_level' in 'field list'
    This is telling us that there is something amiss with your database.

    I can't think of any single factor that could possibly cause both of these problems to appear at the same time.

    I don't think it is a coincidence either.

    There is too much missing from this picture to even hazzard a guess as to the cause. It has all the markings of being 'man made' though. Are you sure there isn't something that you aren't telling us? Such as a failed upgrade attempt using a 'one click installer' perhaps?

    Cheers
    Rod

  3. #3
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Had to reset admin login details in DB now problems in admin area

    Quote Originally Posted by aliali81 View Post
    Using V 1.5

    ...

    OK so again thats fine until I try and go to TOOLS - instead of saying Admin Settings or even remotely similar it says BOX_TOOLS_ADMIN

    and again an error:

    Admin Settings

    1054 Unknown column 'admin_level' in 'field list'
    in:
    [select admin_id, admin_name, admin_email, admin_pass, admin_level from znc_admin order by admin_name limit 0, 20]
    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.
    Those symptoms look like you're trying to use v1.3.x code on a v1.5.x site.
    So, that tells me you've installed something like a plugin or addon that was designed for v1.3.x and thereby replaced parts of the normal admin PHP code with old stuff.
    .

    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.

 

 

Similar Threads

  1. Admin login problems, password reset / update not working.
    By veronicathecow in forum General Questions
    Replies: 2
    Last Post: 7 Nov 2015, 05:09 PM
  2. Replies: 4
    Last Post: 24 Jan 2015, 03:47 PM
  3. v151 Cannot access admin area - login loops back to admin login page
    By Dianne in forum Installing on a Linux/Unix Server
    Replies: 18
    Last Post: 14 Dec 2014, 02:46 PM
  4. Replies: 2
    Last Post: 27 Sep 2013, 02:59 AM
  5. Admin Login page redirects to itself, since I reset admin activity log
    By beep in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 27 Jan 2010, 01:08 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR