• I’ss been like a years since I last went into my wordpress dashboard. I already updated my WP to the latests version, but in the I can’t seem to have the option to edit my Template, Pages, Plugins, etc. How did this happen? and haw can I fix it?

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator bcworkz

    (@bcworkz)

    It sounds like your user has lost its role capabilities for some reason. The DB updates may have done so. Don’t panic, but sometimes the cause is due to a site being hacked. We don’t know this for a fact at this point, all may be fine. Your site looks OK.

    Is there another administrator role user you could try? If not, we can patch your user role directly in the DB. You need to gain access to phpMyadmin, usually through your hosting account. Identify the WP database in the left panel and expand that entry to see the table list. Click on the users table (usually prefixed with “wp_”, but that can vary) and determine the ID for your user. The original admin user is usually ID 1. While in the user table, ensure there are no users that should not be there.

    Go to the usermeta table, then click search tab. Enter your ID in the user_id field. Click Go, then find the row where meta_key field is wp_capabilities. Click the edit link for that row and replace all of the content of the meta_value field with this:
    a:1:{s:13:"administrator";b:1;}
    Do not change anything else. Click Go. Flush your browser cache and clear all cookies for your site. When you log in again, you should have access to edit the usual things.

    If your usermeta already has the above value or you still don’t have proper access, your site’s problems run deeper. We’ll have to decide on what to do next in such a case.

    Thread Starter epere126

    (@epere126)

    I did see the code a:1:{s:13:”administrator”;b:1;} for this meta_key: VCRQkSKDcapabilities I am not sure if this is my ID or not.
    Im unsure what I should do at this point.

    Thread Starter epere126

    (@epere126)

    whenever I log into my WP dashboard, I have this message, not sure what this meanis either

    Warning: array_pop() expects parameter 1 to be array, null given in /homepages/42/d704256643/htdocs/clickandbuilds/glamourtables/wp-content/plugins/1and1-wordpress-assistant/inc/dashboard-widget.php on line 102

    Moderator bcworkz

    (@bcworkz)

    If VCRQkSKD is assigned to $table_prefix in wp-config.php, then that is the correct meta_key value. Sorry for any confusion I may have caused. We do need to be sure you are looking at your user’s meta data though. Go to the users table and locate your login in the list. The ID to the left of your login is your user ID. This is the same value that should be set for user_id in the usermeta table along with the “{$table_prefix}capabilities” meta_key.

    If that all checks out, go to the options table and find the row where option_name is VCRQkSKDuser_roles. Click the edit link for that row so you can see all the data. Disregarding text like a:7:{s:13:, the first actual words should be “administrator”,”name”,”Administrator”,”capabilities”, though it’s not necessarily wrong if these are not first. What we need to check for is within all the capabilities listed after the Administrator role, but before the next role listed (usually “editor”). It should be an extensive list. Some essential capabilities would be “edit_posts”, “edit_pages”, “update_plugins”, “update_themes”, “manage_options”. If any of these in particular are missing, you are prevented from doing the related task. Do not attempt to edit anything in this field! We are just checking for discrepancies right now.

    If that too checks out, we are at the limit of what we can do without affecting the front end appearance and functionality. Further attempts to regain control will cause the front end to appear quite different until the issue can be resolved. Before proceeding further, you should make a complete backup of the DB data and WP files for safety’s sake. Rest assured the site will not be broken any more than it already is, but the front end appearance will be quite different.

    The array_pop() warning doesn’t appear to be crucial to anything but the 1and1 dashboard widget. I can’t be sure since I cannot access the source code. If the warning persists after the site is otherwise working properly, it may be something to take up with 1and1.

    Thread Starter epere126

    (@epere126)

    thank you so much for all your help.

    After much searching and trying to fix the problem myself, the solution was to simply call 1and1 and have them make me an admin of the site, for some reason I was not listed as the admin on my hosting account.

    Moderator bcworkz

    (@bcworkz)

    Ha! Very odd. You’re welcome.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Menu is lacking functions – Can’t access Pages, Appearance, Plugins, Users, Tool’ is closed to new replies.