Many time due to some issue or mistakes we lost the super admin status of Joomla administrator. Here we present a "Do It Yourself Guide to Recover The Super Administrator Status"
Below tables are important (jos_ is default prefix of table, you might have some other prefix)
jos_core_acl_aro
We need to find these things :
- user id
- group_id
- aro_id
Four Steps to recover
1. Find the Joomla Administrator User-ID and Group-ID, from table jos_users
In above snapshot UserID is 62 and GroupID is 25
2. Go to table 'jos_core_acl_aro_groups' and find the GrouID for super administrato. It is 25 in above snapshot. This is also called GroupID for super-administrator. We need to set this value 25, into the table of step-1 , in snapshot thats already 25.
3. Now go to table "jos_core_acl_aro". In this table we will find the aro-id for our administrator whose user id is 62. Search 62 in value column, and get the id against this record. This is 10 as highlighted in below snapshot.
4. Now go to 'jos_core_acl_groups_aro_map" table, here we will search for aro-id (we find that in step-3). Then in that record set group-id to the value found in step-2.
Thats all.
Now try to log in into your Administration backend.
Enjoy
Shyam
