[Solved] How to delete the Super Administrator

[yiannos]

Hi,

in the course of testing my other problem (https://forum.elxis.org/index.php?topic=534.msg2865#msg2865), I promoted a user to super admin and now I cannot demote him back to normal.

I understand it can be done in the database. How exactly?

TIA

[datahell]

You can change his group by the phpMyadmin interface. Elxis does not allows you to delete a super administrator.
Alternative: block the user and tell him to re-register with a different username.

[yiannos]

Thanks for your answer.

Some clarification though:

I already said that I can change it through the database, I am just asking which tables exactly as I do not want to disturb any dependencies in case there is something in more than one tables.

[datahell]

This is how you make him Registred (you can after delete him from Elxis if you wish).

Table #__users
column: gid, change value from 25 to 18 (Registered)
Change the value of the column sendemail from 1 to 0 (if it is 1).
Also write down in a paper (inorder to remember it) the user's ID (column id).

Table #__core_acl_aro
Find the aro_id where the column "value" has value equal to the user's ID (the number you found previously)

Table #__core_acl_groups_aro_map
Change the value of the column group_id from 25 to 18 where aro_id is equal to the value you found in the previous step.

Finished.
User from group Super Administrator become Registered. You can now delete or edit him from Elxis's administration.

[yiannos]

OK this was it!

Thank you for your reply and assistance!

[Jakejus1]

I'm with same problem but don't know where to find that tables...I'm still not good experienced with this..

[eliasan]

Hi,

I guess that you can access your database with phpMyAdmin.

"#__users" table, stands for "elx_users". The same applies for all the rest.

General Note:
When you see a table name like #__table, it means that you have to interpret it as:
[MySQL Database Prefix]_table.
If for example the "MySQL Database Prefix" is "elx_" (default value during installation), then the real name of a table is "elx_table".