Crashed usermeta table

  • Resolved joaoramos

    (@joaoramos)


    14 years, 2 months ago

    I’m getting a “You have no permission to access this page” error when trying to login. After numerous failed login attempts, I renamed my plugins folder and then reset my password through password recovery and by directly setting the password in phpMyAdmin. Still the same.

    Then someone told me on #wordpress (freenode) to check the user capabilities and that’s how I realized that the ‘usermeta’ table was crashed. Any ideas on how to fix it? I only need to access the dashboard to export the blog to a XML file and delete it, so there’s no problem on resetting or rebuilding the users tables.

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

  • Use PhpMyAdmin or whatever database management tool your host provides to access the db. There’s a table repair option in PhpMyAdmin.

    Thread Starter joaoramos

    (@joaoramos)

    I tried it, but it’s still the same. Is it possible to export the users + usermeta from an healthy WP database and import over these two tables?

    In theory, yes. In practice, not something I’d even attempt. There are just too many possible variables. Do you have any recent backups of this db?

    Thread Starter joaoramos

    (@joaoramos)

    Yes, [Link removed]. Could you please help me out on this? ?? I just have no idea what to do.

    Eek! Take that backup down and change your passwords immediately! You’ve just handed the wider world the login details for your site! I’ve removed the link from your post but there’s no knowing who or what grabbed the db dump before I got to it.

    Backup your (corrupted) database next, then empty the usermeta table. Import just the usermeta table from your backup into the now empty usermeta table. Try logging in.

    If the login works and the site is up and running, change all passwords for any users above the level of Subscriber.

    Thread Starter joaoramos

    (@joaoramos)

    Oops, I completely forgot! Well, I’m about to delete the blog anyway. Well, I’ve tried to restore the usermeta table, but this is all I got from the backup. Any other suggestions? ??

    I’m going to try to restore that table with a similar healthy table.

    Thread Starter joaoramos

    (@joaoramos)

    I’ve just restored the usermeta table from a parallel WP healthy installation, but it didn’t work out. Any suggestions other than copy/pasting the posts by hand or exporting/importing all my tables one by one?

    How about restoring an older backup to an fresh db and amending the wp-confog.php file to point to the new db?

    Thread Starter joaoramos

    (@joaoramos)

    Nope, I’ll just do it manually, then. Thanks!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Crashed usermeta table’ is closed to new replies.