Can't Access Admin after upgrading Gold3 - 4

[rlopez]

After upgrading from Gold R3 to Gold R4 I cannot login using my Admin account. All other accounts are disable during an upgrade. Is there any tips and tricks for getting around this? I have had this problem in earlier upgrades with Gold but have been able to get in with super user accounts. Anyfeedback would be great.

Rick L.

[mikek]

You can manually unlock the admin account directly in the ac_Users table.
- Open the database using SQL Management Studio
- Select ac_Users table right click and select Edit Top 200 rows
- Click on the SQL Icon at the top (Show SQL Pane).
- Add where clause to the SQL statement ( WHERE UserName = 'adminemail@user.com') to find the record related to your admin account
- Check IsApproved and IsLockedOut fields. IsApproved should be set to TRUE, IsLockedOut to FALSE

[rlopez]

Thanks for the reply. I whent into the data base and was not sure by changing the IsLockedOut to FALSE may cause more problems. It worked like a champ! thanks again for the tip. Able should find a way to keep accounts from being locked out when having to do full upgrades. This also causes all users account passwords needing to be reset after the upgrade. Thanks again for the feedback
Rick L.

[ForumsAdmin]

I don't think there is a way accounts could get automatically locked out on upgrade. I suspect that you are probably upgrade an old install that you did not access for quite a while.
There is only one situation when admin accounts can get disabled. It happens when an admin does not access/login to the store for a inactivity period defined in merchant admin. By default the inactivity period is 6 months.

[pluggedin]

We just encountered a similar problem.

We have Gold. It's set up as a members only, so you have to log in to see the store.

Up until this weekend it accepted the main administrative account (xyz@someisp.com and pwd) login, but now it says that login has been disabled.
Why, we don't know other than maybe some misstep in assigning admin groups.

When I query the ac_user table it shows

UserId StoreId UserName LoweredUserName Email LoweredEmail
1 1 xyz@someisp.com xyz@someips.com abc@gmail.comr abc@gmail.com


where xyz is the main admin user and abc is another user.

Anyone know how to we should this?
Thanks

[jmestep]

Can you post info on how many users in the table are disabled and what your admin password maximum password age is and if there are any non-admin users locked out? I'm asking because we have been trying to track down a problem with non-admin user accounts getting disabled as long as admin accounts and maybe this is related. Able has not been able to duplicate the problem I have been seeing and it has happened 3 times to the same site when they had the max password age set to a month. I switched it to 24 months so that customers wouldn't be getting locked out.