Help! My Admin user has been changed to Subscriber!

Note: This issue has been resolved - if you are still experiencing it - please make sure you have the latest version of the bridge installed. If you do, please see below to rectify and submit a support request.

There are certain scenarios where the admin WP user had it's rights over-written and changed to Subscriber when running a sync from WHMCS back to WordPress.

To fix your Admin user please do the following

  1. Access your MySQL database for your WordPress site.
  2. Locate the wp_users table and browse for your administrator user to find the value of the "ID" column (if you are using certain security plugins for WP, the "wp_" prefix may be something else, eg: rnd213_users)
  3. Locate the wp_usermeta table and find the rows that have the wp_capabilities and wp_user_level meta_key for your user_id found in step 2 (again, the "wp_" prefix may have changed depending on your security plugins). You can use the following SQL to find these rows:
    SELECT * FROM wp_usermeta WHERE (meta_key LIKE "%_capabilities" OR meta_key LIKE "%_user_level") AND user_id = 1
    Note: the "1" mentioned above should be the ID you found in step 2. 
  4. Change the wp_user_level meta_value to 10 and save the update.
  5. Change the wp_capabilities meta_value to a:1:{s:13:"administrator";b:1;} and save the update.

To avoid this happening again please use these tips
  1. Always make sure you have the latest version of our plugins installed
  2. Avoid having WHMCS users that use aliases (eg: gmail aliases) of your Admin users email address (eg: johnsmith+admin@gmail.com)
  3. If you have followed all of the steps above but it is still happening, please disable Sync and submit a support request for us to debug the issue. We will need FTP access to both your WHMCS and WordPress site, as well as Database access and Admin logins. Please make sure you have created temporary logins for all for us to debug with so you may remove them once we have completed.

We are working towards finding the reason for this issue but unfortunately due to its intermittent nature it has not yet been definitively resolved.
  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

I have trouble with the formatting when viewing an invoice or a quote

You probably have the bridge helper addon for WHMCS installed and pages are redirecting to your...

"Login as Client" and bridge redirect

Note that when you "login as client" from the WHMCS back-end you will not be redirected to your...

The encoded file **** is corrupt.

This error typically occurs when you used FTP to transfer to software to your software but used...

What about support and other emails? How do I get these to blend in with my WordPress site?

To make sure that your support, billing and other emails direct the customer to your WordPress...

I have a blank page displaying!

1. It could be a theme issue. Verify that in your theme's header.php file, you see the...