Help! Locked out of my own store!

Not sure if this is related to the renaming my admin folder a couple weeks ago to make it more secure(I followed the directions I found here and yes I've logged in before today with the new directory name), but, I can not login in to my new admin now. My site still works. branderalarm.net To further confound me, when I tell it to resend my password and I enter my email address, it says it emailed me a new password - but it lies! I did this a few times with no luck. I can login to my cpanel and the hosting site tells my I can ask you all for help and use myPHPadmin to fix it but I am lost. I asked them to reload the site from 24 hours ago, from before I had them help me add a subdomain - just in case that screwed things up. I'll have to wait at least 2 hours to see if that fixes things, but in the mean time I'd like to know what this sounds like to you experts?
Thanks,
Doug

What error do you get when you try to log in?

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

It says:
You entered the wrong username or password.
resend password

I click on resend password and entered my admin email address and it says it sent me a new password. But it didn't.

I tried your link for the myPHPadmin but it fails:

Error

SQL query:

DELETE FROM admin WHERE admin_name = 'Admin';

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

How does this work: If I try the wrong username and PW too many times, does it lock me out? When I click resend it does it wipe out the original?

Can anyone else help please???

You access phpMyAdmin either directly, or from a link called "MySQL Administration" or "phpMyAdmin" in your web hosting control panel.

Once in there take a look - has it got a table called 'admin'? If it doesn't then your database is screwed.

Vger

fishingmaniac:

How does this work: If I try the wrong username and PW too many times, does it lock me out?Not at this time.

fishingmaniac:

When I click resend it does it wipe out the original?Yes

fishingmaniac:

To further confound me, when I tell it to resend my password and I enter my email address, it says it emailed me a new password - but it lies!It doesn't lie. It does send the new password. If you don't receive it then it's either gone into your junkmail/spam folder, or your email server dumped it for perhaps the same reason. You could try setting the minimum password length to something longer to try to avoid it being treated as spam. That has worked once or twice for people.

If the emails don't arrive for you, then you can use the FAQ article mentioned earlier to do the reset.

Thank you for these answers! Before I received them, I was able to get in, albiet briefly. Just long enough to delete the Admin username and admin PW. I tried and changed the email settings and have them working for "ask_a_question", but when I logged of and re-logged back in (only once successfully) and had a hard time - as it turns out the mozilla auto userID and password script was probably the culprit, I eventually clicked resend Password and my email settings failed to send it to me - I was hoping that it would use the same settings as the ask_a_question, which works, but nope! So, as I restore from backup another time and prepare to try to hack my way back in to my own cart, again, (jeeze), :frusty: the question I now have is where are the proper email settings for the admin PW to have it "SUCCESSFULLY" send a new darn Password? I set up the configurations for all other email messages (new logins, customers, orders, etc) in the configuration screen and used smtp for type (not PHP wrapper) and mail.blahblah.com with my port setting on the line below. Again that works, but resend Password DOES NOT and I don't know why not?
Any idea why so if i screw it up again I can be bailed out more easily?

fishingmaniac:

I was able to get in, albiet briefly.You got in. Great! How?
What do you mean by "briefly"?
If you got in, then you should be "in". It doesn't just suddenly kick you out.

I restored from back up, tried a bunch of user ID and passwords, and hit on one. Got in and changed it to my normal one. added another normal one. logged out and back in. Worked on my email settings, so I could try to get a new one emailed to me if i got locked out again. Didn't work. Locked out again. Tried restore and all that again. No luck. My Mozilla password feature might/must have been the culprit. Have since turned it off in Mozilla. If resending password resets it, I seem to be really locked out this time. Tried the myPHPadmin reset query again, with no luck. I think I need someone to take a look.

I would think the phpMyadmin thing would have to work. Are you sure you're using Admin for the user name (note the capital A) and admin as the password?

Have you looked at those fields to see what's in them now?

I agree that the Firefox auto-complete 'feature' can be a major PITA in cases like this - turning it off is the first thing I do after installing FF.

I have noticed on several occasions that if you login and change your User Name and/or Password and log out again, but leave your browser window open and try to login again then it will fail.

The thing is - once logged out, close your browser window before trying to login again.

Vger

Yes I tried that again, but this is the error message I get, and I don't know how or where to look for the entries(not that I would know what to do if I found them):

Server: localhost
Error

SQL query:

DELETE FROM admin WHERE admin_name = 'Admin';

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

Also, I don't know if this is relevant, but I have renamed my admin folder to something else following the instructions here, and everything seemed to be OK for a few weeks. Since I restored again yesterday, and messed things up again, I now have the old "admin" folder and the new, renamed folder. Trying to log on to either fails the same way.- wrong pass/username.
Would really appreciate someone to talk to on this. 20,000 active products - ssl installed - locked out of admin. :no:

When I do get it working again, I need to be sure I can get my email settings to work and that it will resend me a password, and test it somehow, BEFORE logging out. Can this be done?

Does the 'admin' table exist? Have you checked that in your database?

If it does not exist then you need to create it.

Vger

I do not know. But my guess is yes. Where/how do I look? Which folder should I look in Admin, or my new renamed Admin?

Since I have backups can I just replace it with an older version?

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

The words".admin doesn't exist" should give you a clue. It is telling you that the 'admin' table does not exist in your database.

I don't know where you are trying to run the SQL command, but you need to access your database via the phpMyAdmin link in your cPanel. One look at the list of tables will tell you if the 'admin' table is there or not.

Vger

I went into cpanel, clicked on myPHPadmin, went to the SQL tab and entered this:
DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

and hit enter>are you sure>yes. Maybe I'm not in the right starting folder to run this? Where could it if have gone? Especially with two admin folders (one Admin and one "Admin" with a "new name") there should be two instances found?

The 'admin' table has got nothing to do wth the naming of the 'admin' folder.

While you were in phpMyAdmin did you do what I said - and actually look to see if there was an existing table called 'admin'?

What was the result of running the SQL query?

Vger

LOL Where / how do I look in myPHPadmin?
I already showed the result above.

Is this close to where to look:
Table Action RecordsTip Type Collation Size Overhead
BLOG_CATEGORY Browse Structure Search Insert Empty Drop 2 MyISAM latin1_swedish_ci 2.3 KiB -
BLOG_CONTENT Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
cart_comments Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
login Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 2.8 KiB -
login_attempts Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
login_bans Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
PROMO_BOXES Browse Structure Search Insert Empty Drop 27 MyISAM latin1_swedish_ci 16.1 KiB -
sec_codes Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 2.0 KiB -
sec_users Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 2.2 KiB -
site_pages Browse Structure Search Insert Empty Drop 10 MyISAM latin1_swedish_ci 3.8 KiB -
site_specs Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 1.3 KiB -
smt_userdata Browse Structure Search Insert Empty Drop 9 MyISAM latin1_swedish_ci 2.9 KiB -
STATS_BROWSER Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 2.5 KiB -
STATS_BYDAY Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 2.3 KiB -
STATS_BYHOUR Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 2.3 KiB -
STATS_REFER Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 2.5 KiB -
STATS_TOP25 Browse Structure Search Insert Empty Drop 2 MyISAM latin1_swedish_ci 2.6 KiB -
STATS_UNIQUE Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 2.4 KiB -
UDT_CONTENT_SEARCH_REPLACE Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
19 table(s) Sum 59 MyISAM latin1_swedish_ci 53.1 KiB 0 B
With selected: Check All / Uncheck All

Database _sope1 (19)_zc1 (95)_zc2 (95)

brande9_sope1 (19)

* Browse BLOG_CATEGORY
* Browse BLOG_CONTENT
* Browse cart_comments
* Browse login
* Browse login_attempts
* Browse login_bans
* Browse PROMO_BOXES
* Browse sec_codes
* Browse sec_users
* Browse site_pages
* Browse site_specs
* Browse smt_userdata
* Browse STATS_BROWSER
* Browse STATS_BYDAY
* Browse STATS_BYHOUR
* Browse STATS_REFER
* Browse STATS_TOP25
* Browse STATS_UNIQUE
* Browse UDT_CONTENT_SEARCH_REPLACE

Basically jibberish to me

I have just gone through the same thing this morning. I just got the SSL Cert yesterday and it points to the www prefix. Basically, I went back to the two configure files and changed the HTTP_SERVER's to http://your_site.com and I set the ENABLE_SSL_CATALOG and SSL_ADMIN to 'false'.
I was then able to log in to the admin CPanel, change the password. From there I changed the configure settings back one by one, quitting the browser each time and relogging into admin CPanel. For whatever reason, this has worked for me.
Mike