Support » Fixing WordPress » No dashboard

  • After upgrade I ran into serious db issues. Now the site is fine, however when I login, it shows that I am logged in, but I have no dashboard.

Viewing 14 replies - 1 through 14 (of 14 total)
  • Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    Try manually resetting your plugins (no Dashboard access required). If that resolves the issue, reactivate each one individually until you find the cause.

    If that does not resolve the issue, access your server via SFTP or FTP, or a file manager in your hosting account’s control panel, navigate to /wp-content/themes/ and rename the directory of your currently active theme. This will force the default theme to activate and hopefully rule-out a theme-specific issue (theme functions can interfere like plugins).

    thank you for the response. I did renamed the plugins dir. still same problem. And, I don’t have a “default theme”, however, I did rename the theme I’m using, and it didn’t even get me to the login screen. any other ideas?
    can you help with user names in the phpmyadmin? I dont know how to confirm users and access. When I change the password, and MD5, it reverts back to something else. Unlike other db I use, when I change the pw, it seems to keep the new pw.

    Are you using any caching or CDN service?
    If so try to disable it and check again.
    Enable debug in wp-config.php and check for any error output.
    Don’t rename the plugins directory. Try it by renaming the plugins seperately.

    I changed wp-config.php and it gave me this error:

    Notice: Trying to get property of non-object in /home/perfil/public_html/wp-content/plugins/all-in-one-seo-pack/aioseop_class.php on line 1625

    I then renamed that plugin, and still was not able to reach the dash board. However, it still allowed me to login and see the site.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    Does your Dashboard load normally, but you don’t have access to the features you need?

    If so, and if you are not using Multisite, access your database via phpMyAdmin (most hosting providers offer this in their control panel), go to the wp_users table and find the row for your user_login. Note the ID of this row. Now, go to the wp_usermeta table and find the wp_capabilities row for your user_id. Set the value of this row to:

    a:1:{s:13:"administrator";b:1;}

    This might be a wild guess, but, since the db has issues after the upgrade, I’m curious to know, how the db username, passwords, align with the WordPress credentials. There might be an issue there. I know wp-config has the DB_NAME, USER, PASSWORD, but how do they relate (if at all) to the WP login credentials? I might have issues on the db side that might not be giving me the proper permission. Thank you for any help you provide.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    Well, that depends on what you mean by “relate” I suppose.

    The database login credentials in wp-config.php are what WordPress uses to connect to your MySQL database. Inside that MySQL database is the users table, where the username and password that you login to WordPress with are stored.

    Unless you specifically set it up that way, the database login credentials will not be same as you use to log in to your site. Even if you do set them to be exactly the same though, the two are still entirely separate “sets of keys.”

    I did change the value. And it allows me to login. But no dashboard. It looks as if I’m logged in, with the top border and icon for the dashboard and WP icon, but no go.

    ok, so if I go into the phpMyAdmin, in the wp_users table, the user name and password should match up with whats inside the wp-config file? I’d like a simple way to double check this, just in case they were entered/changed incorrectly.

    When I *change the password, it doesn’t seem to keep it. I tried this with another db and it held the (changed) password. Am I missing something simple here?

    *change the password inside the table in wp_users

    • This reply was modified 3 years, 6 months ago by cwmb.

    disabled each plugin individually, no change.

    My site appears, with a border at the top, but doesn’t allow me access to the Dashboard

    Does your Dashboard load normally, but you don’t have access to the features you need?

    BREAKING…
    this resolved the issue. Somehow, the ID was not correct. Thank you! x 100

    go to the wp_users table and find the row for your user_login. Note the ID of this row. Now, go to the wp_usermeta table and find the wp_capabilities row for your user_id. Set the value of this row to:

    a:1:{s:13:”administrator”;b:1;}

    …my ID is not 1, should it be? Does it matter?

    • This reply was modified 3 years, 6 months ago by cwmb.
    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    Your ID does not have to be 1, that’s why the steps included “go to the wp_users table and find the row for your user_login. Note the ID of this row.” πŸ˜‰

    Sorry to hijack this thread, but I’m having what appears to be a very similar problem. However, I don’t have the knowledge of the above users, so much of the conversation (lets face it, nearly all of it!) doesn’t mean much to me.

    Any help would be appreciated (in simple terms πŸ˜‰ )

    I’ve re-named the plugins in FTP, but that’s pretty much the limit of my knowledge

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘No dashboard’ is closed to new replies.