Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2013
    Posts
    2
    Plugin Contributions
    0

    Default Did Admin/Pwd reset through SQL Query but now Error instead of Admin Login Page

    Hi, I installed ZenCart a few days ago using a one-click install from dreamhost. I was incredibly stupid and forgot to write down my admin password, and when I tried to get it emailed to me I didn't receive the email. Yesterday I went in and found the FAQ here for how to do the reset via SQL. Finally got the query to go through, but now when I click on my shop admin area I get "WARNING: An Error occurred, please refresh the page and try again." When I go to the main shop page I get "Sorry! There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you." I looked at the help page for not being able to see the admin page, and I do not see any files called .htaccess in my FTP site. I don't think it's a cookie or firewall issue because I was able to see the login page before. I think I somehow managed to screw things up with the SQL query. Not sure what additional information I need to post. Can anyone recommend my next step?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,380
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Did Admin/Pwd reset through SQL Query but now Error instead of Admin Login Page

    Quote Originally Posted by daryn View Post
    "WARNING: An Error occurred, please refresh the page and try again."
    That means you've got a database error. For security reasons the actual error message is not displayed on-screen, lest a hacker discover information that they could use to damage your site. Instead the error will be stored in the /logs/ folder.
    Related FAQ article, of the same title as the message you got: http://www.zen-cart.com/content.php?...-and-try-again

    I recommend deleting and re-installing, since there's probably not much you'd lose in doing so given that you only just installed 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.

  3. #3
    Join Date
    Sep 2013
    Posts
    2
    Plugin Contributions
    0

    Default Re: Did Admin/Pwd reset through SQL Query but now Error instead of Admin Login Page

    uninstall reinstall seems to have done the trick! I'm in. Thanks much.

 

 

Similar Threads

  1. Replies: 7
    Last Post: 12 Apr 2015, 08:38 PM
  2. v150 Had to reset admin login details in DB now problems in admin area
    By aliali81 in forum General Questions
    Replies: 2
    Last Post: 15 May 2013, 05:32 PM
  3. v150 Can't login to admin and sql password reset doesn't work
    By tips007 in forum General Questions
    Replies: 1
    Last Post: 17 Jan 2013, 04:13 PM
  4. Replies: 9
    Last Post: 8 Oct 2012, 05:16 PM
  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