Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2008
    Posts
    20
    Plugin Contributions
    0

    Default Which "Cannot Login to Admin" thread should I follow?

    Zen Cart 1.3.8a.1.
    GoDaddy Linux (shared) server.
    Site has been working fine for months.
    Wednesday, I get a call from my client that they cannot login. They said the problem presented itself on Tuesday. I try it on my computer. Same problem... it's not buying the correct login/password.
    When we click to "Resend Password", they receive no message at the (correct) admin email address.
    I've attempted actions from some of the threads, but so far to no avail.

    I would really appreciate some kind guru starting me off in the right direction, since there are so many variations on this same theme.

    Any kind takers?

  2. #2
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    4,009
    Plugin Contributions
    61

    Default Re: Which "Cannot Login to Admin" thread should I follow?

    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO – 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

  3. #3
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Which "Cannot Login to Admin" thread should I follow?

    Probably, but you might try this first:

    https://www.zen-cart.com/tutorials/index.php?article=2

  4. #4
    Join Date
    Mar 2008
    Posts
    20
    Plugin Contributions
    0

    Default Re: Which "Cannot Login to Admin" thread should I follow?

    OK. I tried the second suggestion first and got this error message:

    Error

    SQL query:

    DELETE FROM admin WHERE admin_name = 'Admin';

    MySQL said: Documentation
    #1146 - Table 'sou0804408442841.admin' doesn't exist


    Does this mean I need to change something in the MySQL code - or move on to first suggestion because my site has been hacked?

  5. #5
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    4,009
    Plugin Contributions
    61

    Default Re: Which "Cannot Login to Admin" thread should I follow?

    If you are using a prefix for your database tables, you'll naturally need to add that prefix to the table name above.
    ie. "... FROM/INTO prefix_admin ...".
    Code:
    DELETE FROM sou0804408442841_admin WHERE admin_name = 'Admin'; 
    INSERT INTO sou0804408442841_admin (admin_name, admin_email, admin_pass, admin_level) 
    VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);
    Try this

    ~Melanie
    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO – 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

  6. #6
    Join Date
    Mar 2008
    Posts
    20
    Plugin Contributions
    0

    Default Re: Which "Cannot Login to Admin" thread should I follow?

    Thank you for your suggestion, Melanie.

    Here's the Error message I get when I run your code:

    Error

    SQL query:

    DELETE FROM sou0804408442841_admin WHERE admin_name = 'Admin';

    MySQL said: Documentation
    #1146 - Table 'sou0804408442841.sou0804408442841_admin' doesn't exist


    What is my next action?

  7. #7
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,571
    Plugin Contributions
    1

    Default Re: Which "Cannot Login to Admin" thread should I follow?

    It first needs to be determined if a prefix is being used and if so, what is the prefix.

    The answer to both questions can be found by looking at the names of the Tables as shown in the left hand column of phpMyAdmin.

  8. #8
    Join Date
    Mar 2008
    Posts
    20
    Plugin Contributions
    0

    Default Re: Which "Cannot Login to Admin" thread should I follow?

    Thank you for your contribution, Website Rob. I finally figured out what the prefix was, and was able to access my site again.

  9. #9
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,571
    Plugin Contributions
    1

    Default Re: Which "Cannot Login to Admin" thread should I follow?

    Glad to hear you were able to get things sorted.

    Now it's onward & upward.

 

 

Similar Threads

  1. v139h Cannot "add to cart", "sign up", or "log in". Returns to home.
    By Damn Kitten in forum General Questions
    Replies: 3
    Last Post: 12 Aug 2013, 03:11 AM
  2. What are "medium" and "large" images called in admin, and which size are recommended?
    By Nina_Paris_France in forum Customization from the Admin
    Replies: 4
    Last Post: 11 May 2011, 03:01 PM
  3. Users cannot login after upgrade - "There was a security error when trying to login"
    By rob.chevalier in forum Upgrading from 1.3.x to 1.3.9
    Replies: 19
    Last Post: 9 Jun 2008, 08:04 PM
  4. Login, but "page cannot be found" unless "Refresh"
    By simonmade in forum General Questions
    Replies: 3
    Last Post: 2 Oct 2006, 07:04 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