Elxis CMS Forum

Support => Administration => Topic started by: yiannos on February 09, 2007, 11:12:34

Title: [Solved] How to delete the Super Administrator
Post by: yiannos on February 09, 2007, 11:12:34

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

Title: Re: How to delete the Super Administrator
Post by: datahell on February 09, 2007, 11:58:51

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.

Title: Re: How to delete the Super Administrator
Post by: yiannos on February 09, 2007, 12:49:50

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.

Title: Re: How to delete the Super Administrator
Post by: datahell on February 09, 2007, 18:35:37

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.

Title: Re: How to delete the Super Administrator
Post by: yiannos on February 12, 2007, 10:14:34

OK this was it!

Thank you for your reply and assistance!

Title: Re: [Solved] How to delete the Super Administrator
Post by: Jakejus1 on April 29, 2007, 19:32:48

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

Title: Re: [Solved] How to delete the Super Administrator
Post by: eliasan on April 29, 2007, 19:40:39

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".