{"id":1877,"date":"2024-08-22T08:55:46","date_gmt":"2024-08-22T06:55:46","guid":{"rendered":"https:\/\/yellotab.se\/x056\/?p=1877"},"modified":"2024-08-22T12:11:31","modified_gmt":"2024-08-22T10:11:31","slug":"restore-userroles","status":"publish","type":"post","link":"https:\/\/yellotab.se\/x056\/2024\/08\/22\/restore-userroles\/","title":{"rendered":"Restore userroles"},"content":{"rendered":"<p><strong>K\u00e4lla:<\/strong> <a href=\"https:\/\/jetpack.com\/blog\/wordpress-user-roles-the-ultimate-guide\/\">Jetpack<\/a> |<a href=\"https:\/\/role-editor.com\/how-to-restore-deleted-wordpress-user-roles\/\"> role-editor<\/a> |<a href=\"https:\/\/wordpress.org\/plugins\/user-role-editor\/\"> Plugin<\/a> | <a href=\"https:\/\/wordpress.org\/documentation\/article\/roles-and-capabilities\/\">WordPress<\/a> | <a href=\"https:\/\/shinephp.com\/how-to-change-wordpress-user-role-capabilities\/\">shine php<\/a> | <a href=\"https:\/\/www.role-editor.com\/restore-lost-wordpress-admin-permissions\/\">SQL<\/a> |<\/p>\n<hr \/>\n<p><strong>Problem:<\/strong> Tydligen kan alla roller utom 1 f\u00f6rsvinna i listan p\u00e5 roller. Superadministrat\u00f6r verkar finnas kavar, men t.ex Administratrat\u00f6rs-rollen f\u00f6rsvinner vilket g\u00f6r att saker slutar fungera. Tydligen verkar 1 roll finnas kvar, os\u00e4kert om det \u00e4r olika eller samma, men vid senaste tillf\u00e4llet l\u00e5g &#8221;subscriber&#8221; kvar som roll<\/p>\n<p>&nbsp;<\/p>\n<p>Det finns ett antal sk default wordpress roller, och sen finns ett antal roller som skapas av plugin, t.ex wocommerce och Jetpack CRM<\/p>\n<p><strong>Hur:<\/strong> \u00e5terst\u00e4ller man de ursprungliga roller som fanns innan bortfallet.<\/p>\n<p><strong>Metod 1<\/strong>: Klona Administrator rollen i<\/p>\n<p><strong>Metod 2:<\/strong> (ej testat) <a href=\"https:\/\/www.role-editor.com\/restore-lost-wordpress-admin-permissions\/\">uppdatera SQL tabeller<\/a><\/p>\n<p><strong>Metod 3<\/strong>: <a href=\"https:\/\/app.wpremote.com\/app\/sites\">Wp Remote<\/a>: l\u00e4gg till roll &#8221;Administrator&#8221; p\u00e5 \u00f6nskad anv\u00e4ndare<\/p>\n<p><strong>Metod 4<\/strong>: chatgpt: (ej testat)\u00a0 uppdatera SQL tabeller<\/p>\n<h3>2. <strong>\u00c5terst\u00e4lla administrat\u00f6rsrollen via PHPMyAdmin<\/strong><\/h3>\n<p>Om rollen \u00e4r borta och du inte har n\u00e5gon administrat\u00f6r p\u00e5 din webbplats, kan du \u00e5terst\u00e4lla den genom att redigera databasen direkt via PHPMyAdmin.<\/p>\n<ul>\n<li><strong>Steg f\u00f6r steg<\/strong>:\n<ol>\n<li>Logga in p\u00e5 ditt webbhotellskonto och \u00f6ppna PHPMyAdmin.<\/li>\n<li>V\u00e4lj databasen f\u00f6r din WordPress-webbplats.<\/li>\n<li>Leta upp tabellen <code class=\"\" data-line=\"\">wp_usermeta<\/code> (den kan ha ett annat prefix beroende p\u00e5 din installation).<\/li>\n<li>Leta upp posten som motsvarar ditt anv\u00e4ndarnamn.<\/li>\n<li>Hitta f\u00e4ltet <code class=\"\" data-line=\"\">wp_capabilities<\/code> och redigera v\u00e4rdet till:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"flex items-center relative text-token-text-secondary bg-token-main-surface-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md\">\n<p>json<\/p>\n<div class=\"flex items-center\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center\">Kopiera kod<\/button><\/span><\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"\" data-line=\"\">a&lt;span class=&quot;hljs-punctuation&quot;&gt;:&lt;\/span&gt;&lt;span class=&quot;hljs-number&quot;&gt;1&lt;\/span&gt;&lt;span class=&quot;hljs-punctuation&quot;&gt;:&lt;\/span&gt;&lt;span class=&quot;hljs-punctuation&quot;&gt;{&lt;\/span&gt;s&lt;span class=&quot;hljs-punctuation&quot;&gt;:&lt;\/span&gt;&lt;span class=&quot;hljs-number&quot;&gt;13&lt;\/span&gt;&lt;span class=&quot;hljs-punctuation&quot;&gt;:&lt;\/span&gt;&lt;span class=&quot;hljs-string&quot;&gt;&quot;administrator&quot;&lt;\/span&gt;;s&lt;span class=&quot;hljs-punctuation&quot;&gt;:&lt;\/span&gt;&lt;span class=&quot;hljs-number&quot;&gt;1&lt;\/span&gt;&lt;span class=&quot;hljs-punctuation&quot;&gt;:&lt;\/span&gt;&lt;span class=&quot;hljs-string&quot;&gt;&quot;1&quot;&lt;\/span&gt;;&lt;span class=&quot;hljs-punctuation&quot;&gt;}&lt;\/span&gt;<br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li>Kontrollera att f\u00e4ltet <code class=\"\" data-line=\"\">wp_user_level<\/code> \u00e4r satt till <code class=\"\" data-line=\"\">10<\/code>.<\/li>\n<li>Spara \u00e4ndringarna och f\u00f6rs\u00f6k logga in igen.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<hr \/>\n<figure id=\"attachment_1883\" aria-describedby=\"caption-attachment-1883\" style=\"width: 3022px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/xn--hlsoboken-v2a.se\/wp-admin\/network\/settings.php?page=settings-user-role-editor.php\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1883\" data-permalink=\"https:\/\/yellotab.se\/x056\/2024\/08\/22\/restore-userroles\/skarmavbild-2024-08-22-kl-09-30-30\/\" data-orig-file=\"https:\/\/i0.wp.com\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22093103\/Skarmavbild-2024-08-22-kl.-09.30.30.png?fit=3022%2C784&amp;ssl=1\" data-orig-size=\"3022,784\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Ska\u0308rmavbild 2024-08-22 kl. 09.30.30\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;User role editor&lt;\/p&gt;\n\" data-large-file=\"https:\/\/i0.wp.com\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22093103\/Skarmavbild-2024-08-22-kl.-09.30.30.png?fit=1024%2C266&amp;ssl=1\" class=\"size-full wp-image-1883\" src=\"https:\/\/i0.wp.com\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22093103\/Skarmavbild-2024-08-22-kl.-09.30.30.png?resize=3022%2C784&#038;ssl=1\" alt=\"\" width=\"3022\" height=\"784\" srcset=\"https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22093103\/Skarmavbild-2024-08-22-kl.-09.30.30.png 3022w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22093103\/Skarmavbild-2024-08-22-kl.-09.30.30.png 300w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22093103\/Skarmavbild-2024-08-22-kl.-09.30.30.png 1024w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22093103\/Skarmavbild-2024-08-22-kl.-09.30.30.png 768w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22093103\/Skarmavbild-2024-08-22-kl.-09.30.30.png 1536w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22093103\/Skarmavbild-2024-08-22-kl.-09.30.30.png 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><figcaption id=\"caption-attachment-1883\" class=\"wp-caption-text\">User role editor<\/figcaption><\/figure>\n<hr \/>\n<p>Nedan finns 1 anv\u00e4ndare som visas f\u00f6r rollen administrat\u00f6r, men n\u00e4r man klickar p\u00e5 l\u00e4nken saknas anv\u00e4ndare f\u00f6r den rollen. Detta \u00e4r problemet<\/p>\n<p><a href=\"https:\/\/xn--hlsoboken-v2a.se\/wp-admin\/admin.php?page=roles&amp;action=edit&amp;role=administrator\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1886\" data-permalink=\"https:\/\/yellotab.se\/x056\/2024\/08\/22\/restore-userroles\/skarmavbild-2024-08-22-kl-09-51-19\/\" data-orig-file=\"https:\/\/i0.wp.com\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22095154\/Skarmavbild-2024-08-22-kl.-09.51.19.png?fit=2992%2C2126&amp;ssl=1\" data-orig-size=\"2992,2126\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Ska\u0308rmavbild 2024-08-22 kl. 09.51.19\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22095154\/Skarmavbild-2024-08-22-kl.-09.51.19.png?fit=1024%2C728&amp;ssl=1\" class=\"alignnone wp-image-1886 size-full\" src=\"https:\/\/i0.wp.com\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22095154\/Skarmavbild-2024-08-22-kl.-09.51.19.png?resize=2992%2C2126&#038;ssl=1\" alt=\"\" width=\"2992\" height=\"2126\" srcset=\"https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22095154\/Skarmavbild-2024-08-22-kl.-09.51.19.png 2992w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22095154\/Skarmavbild-2024-08-22-kl.-09.51.19.png 300w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22095154\/Skarmavbild-2024-08-22-kl.-09.51.19.png 1024w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22095154\/Skarmavbild-2024-08-22-kl.-09.51.19.png 768w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22095154\/Skarmavbild-2024-08-22-kl.-09.51.19.png 1536w, https:\/\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2024\/08\/22095154\/Skarmavbild-2024-08-22-kl.-09.51.19.png 2048w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00c5terskapa rolles som f\u00f6svunnit, t.ex Administrator<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[138],"tags":[201],"class_list":["post-1877","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-administration"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts\/1877","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/comments?post=1877"}],"version-history":[{"count":12,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts\/1877\/revisions"}],"predecessor-version":[{"id":1891,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts\/1877\/revisions\/1891"}],"wp:attachment":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/media?parent=1877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/categories?post=1877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/tags?post=1877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}