Lost SOME posts, not all sites

  • Resolved rmiddleton

    (@rmiddleton)


    12 years, 7 months ago

    Was experiencing heavy CPU usage (all 4 were pegged often). I turned off about all plugins and the problem ceased, but I also lost all posts on many sites, but some sites are fine. Turning plugins back on did NOT recover the posts. Using phpMyAdmin I see the posts are all there, just not displaying. I tried repairing the database to no avail. I had to restore to a week old backup to get back in business.
    Thoughts? Suggestions to get current data back?

Viewing 14 replies - 1 through 14 (of 14 total)
  • Thread Starter rmiddleton

    (@rmiddleton)

    12 years, 7 months ago

    New info… restored earlier backup (as I said), ran a repair and optimize… lost it all again.
    Hope that helps identify the problem!

    Andrea Rennick

    (@andrea_r)

    12 years, 7 months ago

    your posts are displayed via the htaccess file. thats it.

    resave your permalinks too.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 7 months ago

    Your posts live in your database. Check the DB to see if they’re there.

    The only way plugins can make the posts vanish would be if you’re using a CPT plugin and those are custom posts.

    Thread Starter rmiddleton

    (@rmiddleton)

    12 years, 7 months ago

    Didn’t change anything in htaccess.
    Posts appear to be fine in database.
    Why would repair / optimize cause them to cease displaying?
    WP-DBManager Version 2.63 | By Lester ‘GaMerZ’ Chan

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 7 months ago

    Try re-saving the permalinks as Andrea suggested.

    Do the posts show on the back end (ie when you edit the site?)

    Thread Starter rmiddleton

    (@rmiddleton)

    12 years, 7 months ago

    Any fast way? almost 500 sites and who knows how many posts!?!
    Only thing I have found in searching is to save them on the individual posts, one at a time. There has to be a better way!
    Does turning off all plugins matter when doing a database repair?
    Restoring the newer database now so I can answer the question about the backend edit. Back as soon as it is done.

    Thread Starter rmiddleton

    (@rmiddleton)

    12 years, 7 months ago

    Post and Pages do NOT appear in the backend on SOME sites.
    The are there on some.
    Strange, eh?

    Thread Starter rmiddleton

    (@rmiddleton)

    12 years, 7 months ago

    Ex: websites.msdpt.k12.in.us/sh shows 62 published pages in the header, but none in the list.

    Thread Starter rmiddleton

    (@rmiddleton)

    12 years, 7 months ago

    Ah!!! Has to be a plugin. Deactivated all and got everything back.
    Thanks for the guidance, now for more detective trial & error!

    Thread Starter rmiddleton

    (@rmiddleton)

    12 years, 7 months ago

    Seems WP-Sticky Version 1.50 is the culprit. Must not play nice with 3.2.1

    Andrea Rennick

    (@andrea_r)

    12 years, 7 months ago

    Considering sticky posts are built in, I would image a plugin is not needed.

    Thread Starter rmiddleton

    (@rmiddleton)

    12 years, 7 months ago

    Interesting. Didn’t know it had been added to “built in”. That happen in v3?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 7 months ago

    2.8 I think. Maybe 2.7

    Andrea Rennick

    (@andrea_r)

    12 years, 7 months ago

    It was while back. Couple years anyway.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Lost SOME posts, not all sites’ is closed to new replies.