{"id":153,"date":"2010-04-16T11:19:53","date_gmt":"2010-04-16T10:19:53","guid":{"rendered":"http:\/\/blog.rabihtawil.com\/?p=153"},"modified":"2010-04-16T11:19:53","modified_gmt":"2010-04-16T10:19:53","slug":"you-do-not-have-sufficient-permissions-to-access-this-page%e2%80%9d-after-wordpress-upgrade","status":"publish","type":"post","link":"http:\/\/www.raytawil.com\/?p=153","title":{"rendered":"You do not have sufficient permissions to access this page\u201d after WordPress upgrade"},"content":{"rendered":"<p>If you\u2019ve done a wordpress upgrade which included either copying  another wp database or changing the current one\u2019s table prefix (as well  as changing the $table_prefix PHP variable in your config file,) you  will most likely be met with this warning when you try to log in:<\/p>\n<blockquote><p>You do not have sufficient permissions to access this  page.<\/p><\/blockquote>\n<p>The reason for this is that everything in wordpress that accesses  info in the db does so from PHP using the $table_prefix variable, and  when you first installed your blog, a couple of options are set in the  database that include that value, which makes it not really so dynamic!  \ud83d\ude09<\/p>\n<p>After rooting through my db, I found 5 or 6 values that still had the  old table prefix in \u2013 mostly in the `usermeta` table, but also one in  the `options` table. To make sure I got them all, I ran these simple SQL  statements in phpMyAdmin to update all the values:<\/p>\n<pre class=\"sql\" style=\"font-family: monospace;\"><span style=\"color: #ff0000;\">_usermeta table and _options table<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>If you\u2019ve done a wordpress upgrade which included either copying another wp database or changing the current one\u2019s table prefix (as well as changing the $table_prefix PHP variable in your config file,) you will most likely be met with this warning when you try to log in: You do not have sufficient permissions to access [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[124],"tags":[14,29,33,36,51,53,56,57,59,69,75,81,85,86,93,108,109],"_links":{"self":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/153"}],"collection":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=153"}],"version-history":[{"count":0,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/153\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=153"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}