If this tutorial is not what you were looking for, you still have any questions, suggestions or concerns - feel free to let us know. Please help us to serve you better!

Your Name

Your Email

Your Message (required)

captcha

Featured templates

Joomla Troubleshooter. How to deal with “You do not have access to the administrator section of this Site” error

If your Joomla site does not let you log into the backend, and you see an error message like “You Do Not Have Access to the Administrator Section of This Site?, there are couple of things you can do, regardless to Joomla version:

Joomla Troubleshooter.1

  1. Your sessions table is damaged

    Go to your Hosting panel, enter phpMyadmin tool, find the #__session table and replace the #_ with your table prefix, then launch that Truncate command:

    Joomla Troubleshooter.2

    The worst side-effect you might have is that your currently logged-in users will be kicked out.

  2. Check if the user is really an administrator

    SuperAdmin user group has ID 8 (in older Joomla versions 25). First of all, go to #__users table, and grab the “id” for the user which has troubles with logging into the backend. Then go to #__users_usergroup table, look for the “user_id” you found above, and look for the value in the “group_id” column. This should be 8 if you did not change the ACL schema:

    Joomla Troubleshooter.3

    You can double check that by looking to the #__usergroups table as you need to see what is the ID for Super Administrators group:

    Joomla Troubleshooter.4

  3. Check if the ACL tables are not corrupt

    If the login problem is because of ACL corruption, then in 99% of cases the error lies somewhere in jos_viewlevels and/or jos_usergroups tables. We suggest that you look at a clean Joomla database and compare the two tables of that database with those in your website’s database.

    If the ACL tables are corrupt, then you can manually fix them but we don’t recommend doing that since this should be done only by an expert.

  4. Check the jos_assets table

    1. If all previous tricks are failing, there is the last and less probable way-out. A possible cause of this error is that your #__assets table was somehow corrupted. This table is, by far, the most complex table in Joomla.

      The two most common reasons that might lead to this problem are the following:

    2. Missing entry for com_admin row.

    3. Wrong rules field for com_admin row. The rules field for that row should just contain ‘{}’.

    The row should have the value ‘2’ in the id column, and on last column {} . If you see anything wrong, delete the row from the database and reinsert it using this SQL command (again, replace the ‘#_’ part with your table prefix).

  • Sohrab Abedini

    This helped a lot , thanks. I had dropped the user table and the user group was not matching with the user ID.

    No votes yet.
    Please wait...
 
Start chat