Difference between revisions of "WordPress Multisite Troubleshooting"
(Created page with " == Setting A Network Super Admin == WordPress websites with Multisite enabled have a lot of extra user roles in place. If the user you log in with does not have the menu op...") |
|||
| Line 8: | Line 8: | ||
2. Access the database directly. Navigate to the wp_sitemeta table. Find the row labelled "site_admins" and make the following update. | 2. Access the database directly. Navigate to the wp_sitemeta table. Find the row labelled "site_admins" and make the following update. | ||
| − | + | <code>a:1:{i:0;s:12:"currentadmin";}</code> | |
to | to | ||
| − | + | <code>a:1:{i:0;s:7:"newadmin";}</code> | |
with the names "currentadmin" and "newadmin" being updated from the old user to the new user respectively. Also, '''very important''', The number directly before the username (e.g. 7 for newadmin) must be the number of characters in the username (4 for "name", 7 for "newadmin", 31 for "iwonderifthyisusernameistoolong", etc.). I don't know why this is a rule, but it won't work otherwise. | with the names "currentadmin" and "newadmin" being updated from the old user to the new user respectively. Also, '''very important''', The number directly before the username (e.g. 7 for newadmin) must be the number of characters in the username (4 for "name", 7 for "newadmin", 31 for "iwonderifthyisusernameistoolong", etc.). I don't know why this is a rule, but it won't work otherwise. | ||
Latest revision as of 15:36, 11 July 2016
Setting A Network Super Admin
WordPress websites with Multisite enabled have a lot of extra user roles in place. If the user you log in with does not have the menu options "My Sites" > "Network Admin" (or similar) they won't have full access to making updates and adding plugins. To resolve this you can do one of the following:
1. Log in to the current Network Admin account assign Network/Super Admin privileges to the desired account.
2. Access the database directly. Navigate to the wp_sitemeta table. Find the row labelled "site_admins" and make the following update.
a:1:{i:0;s:12:"currentadmin";}
to
a:1:{i:0;s:7:"newadmin";}
with the names "currentadmin" and "newadmin" being updated from the old user to the new user respectively. Also, very important, The number directly before the username (e.g. 7 for newadmin) must be the number of characters in the username (4 for "name", 7 for "newadmin", 31 for "iwonderifthyisusernameistoolong", etc.). I don't know why this is a rule, but it won't work otherwise.
