JOOMLA Error: “You do not have access to the administrator section of this site.”

If you got that problem then probably you tried to insert an administrator account in jos_user table. You can try my solution below. I expect you to have some knowledge in manipulating your database, if not then do it at your own risk.
Solution:
1) jos_user
– check that the account jos_user.gid=25 (Super Administrator)
2) jos_core_acl_aro:
– check that your jos_user.id is map to another jos_core_acl_aro.id
– if record don’t exist then create one.
3) jos_core_acl_groups_aro_map:
– look for jos_core_acl_groups_aro_map.aro_id = jos_core_acl_aro.id
– there should be only one record, If there’s multiple entry delete them.
– make sure that group_id=25
4) if record don’t exist then create one.

Try to login and good luck.



Facebook Comments

22 Responses to “JOOMLA Error: “You do not have access to the administrator section of this site.””

  1. naimeh says:

    no such table exists :”jos_core_acl_aro”
    I installed joomla on localhost but can’t access its administration area.
    I use joomla1.6
    thanks

  2. Thank you. With your help I have saved several hours of work.

  3. oldlaxr says:

    AM I hacked or have I messed something up.

    keep getting

    You do not have access to the administrator section of this site.

    Using 1.7

    I go in and run query to set up new Super Admin.

    Can log in but once I log out and try to log back in – get vaunted error message

    Thanks

  4. Thanks a lot for your GOOD post here.
    It resolved my issue!!

    Do you work with the databases?

  5. Thanks a lot. I have several sites with joomla, And i get this message in one of them. Your solution works for me. I will be crazy is not. Thanks.

    P.D. Sorry for my english.

  6. staha says:

    If you receiving joomla 1.7 error “You do not have access to the administrator section of this site.” but password and name maches and are OK (you are sure pass and usrname you ENTERING are 100% correct and there is no anny error message like “your pass and usrname do not match or no such user”), then it might be done some mess in jour _assets table.

    I used fast way to solve this problem via phpMyAdmin pannel. I have deleted contents of table (your prefix) _assets and then using SQL querry inserted into (your prefix) _assets data from original joomla install directory, from file >> sample_data.sql

    I am able to log in to my admin backend again.
    It might be, some would needed look for problems in _assets table, if such error appears. Then one just should do minor changes (repair some incorrect values) to take administrator privileges again, but i was rush in time so i just “restored” _assets to after install state.
    One shoul do SQL manipulations carefully if you ar nor sure 100% what are you doing.
    One should make full DB backups before interventions, for restoring!

  7. Bilal says:

    you are an angel. i have been facing this problem since 3 weeks now, and now its solved, i tried so many solutions from the internet but no use.

    Thanks again Rocky.

  8. Krapht says:

    Many thanks!!! Had missing records in these tables. Recreated and matched the ids and restored admin access on 1.5(.14)!!

  9. Carol says:

    This worked after weeks of trying all solutions on this earth.. Thanks Alot!

  10. Matt says:

    STAHA RECOMMENDATION IS a+++

    It was the assest table, i was lucky because I had a local setup, so I imported table and works right away.

  11. Xaver says:

    Thank you for super tip

  12. mariappan says:

    Thanks lot…..

  13. Thanks for the marvelous posting! I seriously enjoyed reading it, you can be a great author.
    I will ensure that I bookmark your blog and definitely will come back sometime soon.
    I want to encourage that you continue your great job, have a nice morning!

  14. Hassan says:

    I was having the same problem with Joomla 2.5, however when i tried to login from different browser it worked fine. So, I cleared cache from my main browser and it’s now letting me in.

  15. Alok says:

    Thank you. With your help I have saved several hours of work.

    Alok Mishra A1 inc

  16. solo ads says:

    I read this article completely on the topic of the comparison
    of most up-to-date and preceding technologies, it’s amazing article.

  17. Anurag says:

    Hi i read complete post and made many changes , created new user reset assets table clear cache but still cant logged in in the admin panel get the following error:-

    JUser: :_load: Unable to load user with ID: 8057
    JUser: :_load: Unable to load user with ID: 8057
    You do not have access to the administrator section of this site.
    JUser: :_load: Unable to load user with ID: 8057

  18. Oh my goodness! Incredible article dude! Thank you, However I am encountering troubles with your RSS.
    I don’t understand the reason why I cannot join it. Is there anybody having identical RSS issues?
    Anybody who knows the solution will you kindly respond? Thanx!!

  19. Kenny says:

    Amazing! Thank you so much!

  20. I think the admin of this web site is truly working hard for his site, for the reason that here every material is quality based data.

Leave a Reply


Related Posts