Site Works, but Admin missing all posts/pages/etc

  • anoff

    (@anoff)


    12 years ago

    I have a site that was working fine until yesterday. We went into to look at a media file that was uploaded, but the media library was empty. The front end was still working fine, the files were still on the server when I checked via FTP, and there is still all the meta info in the wp_post and wp_postmeta DB tables.

    Realizing that the media uploads are basically just a custom post, I checked the pages and post sections, and they were having the same problem. All the users are missing too!

    When I use the uploader to add files, they appear on the server, but wordpress just sits there “crunching” forever. And when I create a new page, it only allows me to ‘Submit for Review’. It then ask if “Are you sure you want to do this?”, with a link to ‘Please Try Again’. Clicking the link takes me to a blank page creation screen.

    Things I’ve tried:
    check/repair the DB tables
    explicitly point the uploads folder to where they are (the default)
    Adjust my admin permissions via phpMyAdmin

    Again, the site is working, just the backend is screwed up. Hosting is on AWS, so I don’t think it’s a capacity limit issue. I’m cloning the site to a dev server so that I can start picking it apart.

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • WPyogi

    (@wpyogi)

    Have you checked as to whether it might have been hacked? Or tried deactivating all plug-ins?

    Thread Starter anoff

    (@anoff)

    Nothing seems to indicate a hack; is there something in particular I should be looking for?

    I’m going to start deactivating plugins tonight, but no plugins were installed or changed recently.

    WPyogi

    (@wpyogi)

    Securi is a good site to use for that:

    https://sitecheck.sucuri.net/scanner/

    Thread Starter anoff

    (@anoff)

    scanner came up empty. Interesting though, when I export the the database, and then import it into the dev server, a lot of the tables are not coming over, including wp_posts and wp_postmeta. I verified that they are in the .sql file, but they aren’t importing. When I do the tables individual (individual export, then import), they come through fine.

    Don’t know if that helps

    Thread Starter anoff

    (@anoff)

    The admin log entry in the wp_options database is HUUUUUGE. So much so that the import of the table times out on that key. Could that be the issue? And should I clear it out either way?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Site Works, but Admin missing all posts/pages/etc’ is closed to new replies.