[solved] Please Help (admin permissions removed / no access / empty left menu)

This site is best viewed in a modern browser with JavaScript enabled.

[solved] Please Help (admin permissions removed / no access / empty left menu)

skang

I was setting up user permissions and accidently removed all access for my admin profile. I do not have a database backup but I have access to the backend (using MySQL)

Thanks in advance

francoisjacquet

Hello skang

It is not possible to remove access/edit to the Users > User Profiles program when editing the Administrator profile.

So, if your admin user belongs to the Administrator profile, you should still have access to this program to restore access.

skang

francoisjacquet I’m not sure how I did it but I removed that somehow

francoisjacquet

Or is it you've edited your User Info, and set your "User Profile" to "No Access"??

francoisjacquet

skang to better understand, can you log into the system at all?

If you can't log in, here is an SQL query you can run:

UPDATE staff
SET PROFILE='admin',
WHERE USERNAME='my_username';

This will set the my_username user (edit accordingly) back to the admin profile.

skang

francoisjacquet I can log in but am unable to access any module, the sidebar is just blank.

francoisjacquet

skang if you can log in but cannot access the Users > User Profiles program, it may indicate your admin user has custom permissions.

UPDATE staff
SET PROFILE_ID='1',
WHERE USERNAME='my_username';

This will set the my_username user (edit accordingly) back to the admin permissions.

skang

francoisjacquet This worked! Thanks for all the help