Posts, Pages, Media gone after re-install

  • I’m not sure how or why but last week my dashboard began acting up (loading slow >2-3 minutes) and even then not loading completely. My site still seemed functional though.

    In an effort to resolve the issue, I disabled all plug-ins (the wp equivalent of “did you reboot your computer?). That sped things up, but the dashboard was still not completely loading. Trying to re-activate the plug-ins and that’s when things went truly south. My entire site seemed broken now.

    I attempted a clean/fresh re-install of wordpress. I had a backup of my entire public_html folder, so I deleted all my wp files and did a fresh installation via my host cPanel. I then had my host restore my db. I now have a fresh wp install, and restored db. I updated my wp_config.php file to make sure my db name matches. Lastly I re-uploaded via ftp my content folder.

    Strangely all the plugins show up, but nothing else. Posts, pages, media…all gone. It’s been physically uploaded via ftp. The files are there, but wordpress doesn’t see any of it.

    Any ideas? My host is washing their hands of it, saying restoring the db is the extent of what they can do as they don’t offer web developing services.

Viewing 15 replies - 1 through 15 (of 17 total)

  • Do you see posts in the database?

    Also, the techical dificulties page makes it more difficult to check your site.

    Thread Starter wednesdaysheroes

    (@wednesdaysheroes)

    I do see the posts in the database.

    “technical difficulties” removed.

    Thread Starter wednesdaysheroes

    (@wednesdaysheroes)

    not sure if this is a helpful clue, but when I’m looking at “appearance/themes” the twenty-sixteen theme is the only installed/active theme, but the big preview image just shows the “broken image” icon.

    You need to upload the twenty sixteen theme again. The css is missing along with other parts of the theme.

    Somewhere there is a database problem. First get a back-up/copy of the database. When you reinstalled wp did you build a new database? It looks to me like your site is using a brand new almost empty database.

    Thread Starter wednesdaysheroes

    (@wednesdaysheroes)

    When I re-installed wp, yes, I created a new db, but that’s not the database that I’m using. I deleted that new/empty db. The restored/old db “wednesda_whdb” is what’s there now (145MB~) and that’s what’s being called in my wp-config.php file.

    I literally just re-installed 4.6.1, should that not have reinstalled the twenty-sixteen theme?

    Thread Starter wednesdaysheroes

    (@wednesdaysheroes)

    Just installed and activated the twenty-fifteen theme and same “broken image” icon appears for both themes. Seems like the issue isn’t specific to any particular theme, but wordpress as a whole.

    Not sure where it’s pulling my favicon from, but strangely that’s working (teeny icon on browser tab).

    Yes, that should have added all the regular themes.

    This file is missing.
    https://wednesdaysheroes.com/wp-content/themes/twentyfifteen/style.css?ver=4.6.1

    Normally when you do a total reinstall you would export the database and then import it into the new db. Your db is that large? Mine is only about 23 meg and it has been up since 2006. I’ll ask someone else to look at this.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Check the table prefix in the database with the table prefix set in wp-config.php. If you see posts in the database but not on the site, it’s likely that you’re pointing to the wrong set of tables. (The default prefix is “wp_”.) How are your tables named?

    It also appears you’ve set the theme to twentyfifteen but the theme is not installed.

    Also go to Cloudflare and suspend your service.

    Thread Starter wednesdaysheroes

    (@wednesdaysheroes)

    Paused cloudflare.

    I just installed and activated twenty-fifteen. How can I select and activate a theme if it’s not installed?

    prefix is set to “wpg5” I see numerous tables with that prefix (mostly woocommerce tables), but the vast marjority are indeed “wp”. Is it possible to have two different prefixes? That doesn’t make sense to me.

    Thread Starter wednesdaysheroes

    (@wednesdaysheroes)

    paused cloudflare and now when I try to go to wednesdaysheroes.com it switches to wednesdaysheroes.dev and gives me an error message.

    This site can’t be reached

    This site on the company, organization or school intranet has the same URL as an external website.

    Try contacting your system administrator.
    ERR_ICANN_NAME_COLLISION

    (I also changed the prefix to wp_ instead of wpg5_, but switched it back to check if that was causing the issue…it wasn’t) – that leave the cloudflare change as the culprit.

    Any ideas where it’s pulling that incorrect url from?

    Turn Cloudflare back on. Your at Cloudflare must be wrong but that isn’t the issue now. What Steve meant is the CSS was not installed.

    No. You have to have the same prefix. Here are some plugins that will let you change that. I have not personally used any of these.
    Better WP Security
    Website Defender WordPress Security
    WP Security Scan
    WP Prefix Changer
    Change DB Prefix

    Thread Starter wednesdaysheroes

    (@wednesdaysheroes)

    This just keeps getting weirder and weirder.

    I looked at the wp_options table and it was pointing to wednesdaysheroes.dev. I edited that and things came back. My posts, my pages, my media, my products. All of it.

    BUT…outside of my dashboard my browser keeps flipping .com to .dev and I cannot access anything. Also, both the twenty-fifteen and twenty-sixteen themes still seem broken.

    Looking at the db tables…it looks as though all the tables with the wpg5 prefix are duplicates of tables with the normal wp_ prefix.

    I have NO idea how all of this became such a mess. Things were working just fine a week ago.

    Thread Starter wednesdaysheroes

    (@wednesdaysheroes)

    making progress. manually installed wordpress again via ftp and seemed to have fixed it.

    Seems right now the last problem I have is the .dev vs .com issue.

    err…that and all those tables with the wpg5 prefix. I’m starting to think I can/should just remove them all?

    Thoughts?

    Moderator bcworkz

    (@bcworkz)

    Don’t remove them just yet. If your wp-config.php prefix is something else, as far as WP is concerned those tables are essentially not there.

    Check your .htaccess file (if your hosting plan is Apache) to see if some rewrite rule is causing the .com to .dev switch.

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Posts, Pages, Media gone after re-install’ is closed to new replies.