Recover Super Admin Status of Joomla 1.5 Administrator

Swati Goyal , 02 June, 2009

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"
<div>
    Below tables are important (jos_ is default prefix of table, you might
    have some other prefix)
</div>
  • jos_users
  •     <li><span>jos_core_acl_aro_groups</span></li>
    
        <li><span>jos_core_acl_groups_aro_map</span></li>
    
        <li style="list-style: none; display: inline">
            <div>
                <span>jos_core_acl_aro</span>
            </div><br/><div style="text-decoration: underline">
                We need to find these things :
            </div>
    
            <ol style="color: #333333; font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px; line-height: 15.800000190734863px;"><li>user id</li>
    
                <li>group_id</li>
    
                <li>aro_id</li>
            </ol><div style="text-decoration: underline">
                <strong>Four Steps to recover</strong>
            </div>
    
            <div>
                <strong>1.</strong> Find the Joomla
                Administrator <strong>User-ID</strong> and <strong>Group-ID, </strong>from
                table jos_users
            </div>
    
            <div><img src="recover-super-admin-status-of-joomla-15/recover-super-admin-3.jpg"/></div>
    
            <div>
                <br/></div>
    
            <div>
                In above snapshot UserID is 62 and GroupID is 25
            </div>
    
            <div>
                <strong>2</strong>.  Go to
                table <span>'jos_core_acl_aro_groups' and find the GrouID
                for super administrato. </span>It is 25 in above snapshot.
                This is also called GroupID for
                super-administrator. <strong>We need to set this value 25,
                into the table of step-1 , in snapshot thats already
                25.</strong>
            </div>
    
            <div><img src="recover-super-admin-status-of-joomla-15/recover-super-admin-3.jpg"/></div>
    
            <div>
                <br/></div>
    
            <div>
                <strong>3.</strong> Now go to table
                "jos_<span>core_acl_aro". </span>In this table we will
                find the <strong>aro-id</strong> for our
                administrator whose user id is <strong>62</strong>. Search
                62 in <strong>value</strong> column, and get the id
                against this record. This is <strong>10</strong> as
                highlighted in below snapshot.
            </div>
    
            <div><img src="recover-super-admin-status-of-joomla-15/recover-super-admin-3.jpg"/></div>
    
            <div>
                <br/></div>
    
            <div>
                <strong>4.</strong> Now go
                to <strong>'jos_core_acl_groups_aro_map"</strong> 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.
            </div>
    
            <div><img src="recover-super-admin-status-of-joomla-15/recover-super-admin-3.jpg"/></div>
    
            <div>
                <br/></div>
    
            <div>
                Thats all.<br/>
                Now try to log in into your Administration backend.
            </div>
    
            <div>
                Enjoy<br/>
                Shyam
            </div>
        </li>
    </ul>
blog comments powered by Disqus