Unable to access Admin following upgrade to version 10

Hi Jamie,

Its a role and user privilege level issues , I recommend you to take backup of your Database before executing this query.

Check with this query and update your user privilege or admin user privilege using below query.

Update cms_user SET UserPrivilegeLevel=3 WHERE username='administrator'

Thanks

Happy to help you

Hi Prashant,

Thanks for your help. Unfortunately the administrator user already has UserPrivilegeLevel=3.

Do you have any other suggestions?

Thanks,

Set blank password in database for another admin rights users those having UserPrivilegeLevel=3 using

Update cms_user set userpassword='' where username=@Username OR UserID= @userid

I recommend you to update your kentico 10 with latest hotfix version 10.0.35

Thanks

I already tried that and get the same error:

Access denied to resource 'CMS'

Permission for UI element 'Administration' is required.

The hotfix shouldnt affect this simple login, at least according to the list of bugs fixed in the hotfix. I agree the issue is related to permissions and roles but as far as I can see, the administrator user in in the correct admin roles and those admin roles have rows in the RoleUIElement table for the administration ui element as well.

What else could be missing?

have you tried the emergency admin reset? you add a app key in the web.config that resets a password and sets the level. it's in documentation in password reset (on mobile so hard to link)

I've had this same issue. I'm upgrading my solution manually, as it's a slightly different file structure and have followed the instructions here. I tried the emergency admin reset, but it resulted in the following server error:

Server Error in '/' Application.

Invalid column name 'UserIsEditor'.
Invalid column name 'UserIsGlobalAdministrator'.
Invalid column name 'UserSiteManagerDisabled'.

I'm aware these columns have been removed as part of the Kentico 10 upgrade, which suggests that there's legacy code/dlls still in my solution.

I've been through the dlls being referenced (they're all v10) and currently double checking the code files, but would be grateful if anyone has any ideas as-to what I might have missed.

This is probably a big indicator that the manual upgrade failed, did you do both files and database and follow instructions exactly? Easy to miss a step, may need to redo your upgrade :(

Thanks Trevor, I went through the instructions again and realised that I had indeed missed the step to merge the CMSApp_AppCode project into the main CMSApp project. Having done that, I can now login to admin and the site runs fine.

Awesome, please mark the answer as correct if it's resolved!

It's not resolved by your answer Trevor, because Peter jumped in on my question with his own one...

However, I did manage to resolve the issue outlined in the original question. During the upgrade process it seemed that the UpgradeProcedure.cs was never executed (or even updated to the v10 one) during the upgrade process. I changed my local UpgradeProcedure.cs to the one provided in the upgrade installer directory and forced it to run. After this has ran, I was able to access the administration section.

Ah, sorry Jamie i did missed that it was another question that was answered, not your original. Glad yours was able to be resolved!