Issue WordPress Toolkit shows list of admin users but can't update as says user doesn't exist

[MHC_1]

Server operating system version

aalmalinux 9

Plesk version and microupdate number

18

WordPress Toolkit shows admin users, but it can't update them. Says can't find them despite them existing.

WordPress toolkit can't log in to the Wordpress dashboard (presents the setup dialogue as below instead).

The SQL data for the _users and _usermeta tables both appear correct in PhpMyAdmin




How can I resolve this? I have tried to clear the WP toolkit cache for this ( as per site https://support.plesk.com/hc/en-us/articles/12377346626071-How-to-clear-WordPress-cache-in-Plesk ) but makes no change.

 

[scsa20]

If possible log in directly into Plesk and make sure it has the administrator role. As another test you can also remove all other roles that account has and retry and see what happens.

 

[Sebahat.hadzhi]

@MHC_1 , what else you might want to check is the database prefix defined in the wp-config.php file and make sure that it matches the actual database prefix (for example, through phpMyAdmin) for all tables.

 

[MHC_1]

@MHC_1 , what else you might want to check is the database prefix defined in the wp-config.php file and make sure that it matches the actual database prefix (for example, through phpMyAdmin) for all tables.

Hello. Yes this has already been done. To be clear; the drop down list of Adminstrators correctly lists the (3) admins on the system but it doesn't seem to be able to log in with any of them. I have also checked the `_metadata` table on the DB and all admin have the correct admin flag on their data.

If possible log in directly into Plesk and make sure it has the administrator role. As another test you can also remove all other roles that account has and retry and see what happens.

I'm not sure I understand, you mean log directly in to the Wordpress ( site.co.uk/wp-login.php ) to access the dashboard? I have just tried this and the login simply resets to the home page without any notices.

... Maybe this is a Wordpress rather than a Toolkit problem.....

 

[scsa20]

If logging in directly by going to site.tld/wp-admin then something is broken with either your wordpress installation or the use of .htaccess (if using Apache) or NGINX rewrite rules or something which you'll want to get that fixed before getting WPToolKit fixed. It's also possible you have some sort of database corruption. In either case, need to fix WordPress first before anything else.

 

[MHC_1]

If logging in directly by going to site.tld/wp-admin then something is broken with either your wordpress installation or the use of .htaccess (if using Apache) or NGINX rewrite rules or something which you'll want to get that fixed before getting WPToolKit fixed. It's also possible you have some sort of database corruption. In either case, need to fix WordPress first before anything else.

Thanks. We've turned off all plugins and reset wordpress to core . Wordpress user_metadata is set up correctly the user is the administrator but logins only ever go to the home page rather than any sort of dashboard.

At a loss how to get the dashboard to work. Everything else works fine.

 

[MHC_1]

The issue might be WordFence -- I am trying to reset the password of the admin account, and I get an email from WordFence Plugin (to the same email address) telling me that someone requested a password reset but I never get the email with the actual password reset details. How can we do this?

 

[MHC_1]

Further to the above; I have literally just created a new admin account - on the Database - WordPress Toolkit can see that the admin account is there, immediately, but then it claims it can't see it to update it. Extremely frustrating.

This screenshot is literally for a user account created on the `_users` table with a single line in the `_users_metadata` table saying it's an administrator. Yes WordPress Toolkit can't seem to be able to update it.

 

[Sebahat.hadzhi]

@MHC_1 , please run the following command:

plesk ext wp-toolkit --wp-cli -instance-id 1 -- user list

If you are not sure about the instance ID, you can confirm it with the first entry the following command returns:

plesk ext wp-toolkit --list | grep 'example.com'

Please confirm if the "administrator" is returned under the "roles" column.

 

[MHC_1]

@MHC_1 , please run the following command:

plesk ext wp-toolkit --wp-cli -instance-id 1 -- user list

If you are not sure about the instance ID, you can confirm it with the first entry the following command returns:

plesk ext wp-toolkit --list | grep 'example.com'

Please confirm if the "administrator" is returned under the "roles" column.

Hello
The three users (all admins) are correctly showing but none are showing up as "administrators". None have any "roles" in the terminal output .

How do I set the WP_toolkit to reaffirm they/we are admins? To confirm - the _usermeta WP table correctly shows we are all Admin.

Thank you!

 

[Sebahat.hadzhi]

Thank you. Please create a backup of your WordPress database (just in case) and then try the following:

plesk ext wp-toolkit --wp-cli -instance-id 1 -- user set-role 3 administrator

set-role 3 should correspond to the output from the previous command.