{"id":966,"date":"2019-06-26T06:37:51","date_gmt":"2019-06-26T13:37:51","guid":{"rendered":"https:\/\/umy.vxg.mybluehost.me\/website_74479d39\/?p=966"},"modified":"2019-06-26T06:37:57","modified_gmt":"2019-06-26T13:37:57","slug":"mu-wordpress-lost-roles-on-one-of-the-sites","status":"publish","type":"post","link":"https:\/\/layne.eqlik.us\/index.php\/archives\/966","title":{"rendered":"MU WordPress Lost Roles on One of the Sites"},"content":{"rendered":"\n<p>I run a MU WordPress with several websites.  One day I noticed that I was unable to add roles to the people on one of my sites.  No matter what I did couldn&#8217;t get any roles to appear in the selector.<\/p>\n\n\n\n<p>Some how in one of my updates the prefix for this particular site wasn&#8217;t updated.  I found a post telling me this:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"692\" height=\"394\" src=\"https:\/\/umy.vxg.mybluehost.me\/website_74479d39\/wp-content\/uploads\/2019\/06\/Solutions.png\" alt=\"\" class=\"wp-image-967\" srcset=\"https:\/\/layne.eqlik.us\/wp-content\/uploads\/2019\/06\/Solutions.png 692w, https:\/\/layne.eqlik.us\/wp-content\/uploads\/2019\/06\/Solutions-600x342.png 600w, https:\/\/layne.eqlik.us\/wp-content\/uploads\/2019\/06\/Solutions-300x171.png 300w\" sizes=\"auto, (max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n\n\n<p>Following this line of thinking led me to change that particular database table name.  Sure enough renaming the table worked!<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"702\" height=\"218\" src=\"https:\/\/umy.vxg.mybluehost.me\/website_74479d39\/wp-content\/uploads\/2019\/06\/Database.png\" alt=\"\" class=\"wp-image-968\" srcset=\"https:\/\/layne.eqlik.us\/wp-content\/uploads\/2019\/06\/Database.png 702w, https:\/\/layne.eqlik.us\/wp-content\/uploads\/2019\/06\/Database-600x186.png 600w, https:\/\/layne.eqlik.us\/wp-content\/uploads\/2019\/06\/Database-300x93.png 300w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/figure>\n\n\n\n<p>Previously it was named <em><strong>wp_89_user_roles<\/strong><\/em>.  It needed to be named <strong><em>64d_89_user_roles<\/em><\/strong>.<\/p>\n\n\n\n<p>Problems solved!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I run a MU WordPress with several websites. One day I noticed that I was unable to add roles to the people on one of my sites. No matter what I did couldn&#8217;t get any roles to appear in the selector. Some how in one of my updates the prefix for this particular site wasn&#8217;t updated. I found a post telling me this: Following this line of thinking led me to change that particular database table name. Sure enough renaming the table worked! Previously it was named wp_89_user_roles. It needed to be named 64d_89_user_roles. Problems solved!<\/p>\n","protected":false},"author":120,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,90,88],"tags":[91],"class_list":["post-966","post","type-post","status-publish","format-standard","hentry","category-computers","category-mu-wordpress-wordpress","category-wordpress","tag-user-roles"],"acf":[],"_links":{"self":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/users\/120"}],"replies":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/comments?post=966"}],"version-history":[{"count":2,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/966\/revisions"}],"predecessor-version":[{"id":970,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/966\/revisions\/970"}],"wp:attachment":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media?parent=966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/categories?post=966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/tags?post=966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}