how to revert the removed/renamed Admin user change?

When you activated the iTSec plugin Advanced > Admin User feature it made permanent changes in your database.

That is also why the Advanced > Admin User feature recommends to create a database backup before using it …

Only restoring a database backup will undo the database changes …

But … perhaps we can solve the problem you have.

Is your problem identical to the issue as described in this topic ?

dwinden

thanks @dwinden

is not the same problem.
i did back up before installing ithemes but that was a long time ago. i have made many changes it would be hard for me to start over.

i can access to my site, so no, the problem is not identical to the one you described.

my problem is that my theme need the #1 admin to use some featured of the theme.

is there a way to change this manually? and a tutorial on how to do it?

thanks

@vizcano

I think it is possible to revert the database changes from phpMyAdmin if you know EXACTLY what you are doing (and after first making a database backup …).

But if your theme is hardcoded to use #1 admin then I think that theme is not well coded … I would even call it a bug in the theme.

dwinden

ummm i see… to fix that would be a lot of work… i will leave it just the way it is and wait for the theme maker to fix that in an update. thanks @dwinden

@dwinden

Hi, i realize that i need to revert this change or i will have to delete all wordpress and start all over again (way too much work). Because I installed ithemes before installing my theme and set it all as what it is now.

Please can you tell me what to do to revert this change? I need admin id to be 1. Or else many functions of my theme won’t work. And i need them, i though i could be without it but i need those functions. ??

as i am not sure this will be readed i will make a new post about it.

@vizcano

Make sure to create a database backup before taking the next steps:

• 1. Log into phpMyAdmin
• 2. Click on the [prefix]users table and take a note of the following 10 field values for your current administrator user (ID > 1):

  [ID]
  [user_login]
  [user_pass]
  [user_nicename]
  [user_email]
  [user_url]
  [user_registered]
  [user_activation_key]
  [user_status]
  [display_name]

  [prefix] should be substituted with the database tables prefix (eg wp_)

• 3. Execute the following SQL command:

  insert into [prefix]users (‘ID’,’user_login’,’user_pass’,’user_nicename’,’user_email’,’user_url’,’user_registered’,’user_activation_key’,’user_status’,’display_name’)
  VALUES (‘1’,[user_login],[user_pass],[user_nicename],[user_email],[user_url],[user_registered],[user_activation_key],[user_status],[display_name]);

  Where [prefix] should be substituted with the database tables prefix (eg wp_) and where [field_name] should be substituted with the values as noted in step 2.
  All field values should be entered between single quotes (”) except user_status.

• 4. Verify you now have 2 identical rows in the [prefix]users table. Only the ID is different.
• 5. Delete the Administrator user row as identified in step 2 (ID > 1).
• 6. To complete, execute the following SQL commands:

  update [prefix]usermeta set user_id=’1′ where user_id=?;
  update [prefix]comments set user_id=’1′ where user_id=?;
  update [prefix]links set link_owner=’1′ where link_owner=?;
  update [prefix]posts set post_author=’1′ where post_author=?;

  [prefix] should be substituted with the database tables prefix (eg wp_).
  ? should be substituted with the id of the administrator user as identified in step 2 (ID > 1).

• 7. Try and log into WP Dashboard.

Needless to say you should follow these instructions at your own risk.

dwinden

thanks a lot i will try! @dwinden