WordPress.org

1. rmiddleton
   Member
   Posted 9 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?

2. rmiddleton
   Member
   Posted 9 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!

3. Andrea_r
   team pirate
   Posted 9 months ago #

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

   resave your permalinks too.

4. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 9 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.

5. rmiddleton
   Member
   Posted 9 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

6. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 9 months ago #

   Try re-saving the permalinks as Andrea suggested.

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

7. rmiddleton
   Member
   Posted 9 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.

8. rmiddleton
   Member
   Posted 9 months ago #

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

9. rmiddleton
   Member
   Posted 9 months ago #

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

10. rmiddleton
    Member
    Posted 9 months ago #

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

11. rmiddleton
    Member
    Posted 9 months ago #

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

12. Andrea_r
    team pirate
    Posted 9 months ago #

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

13. rmiddleton
    Member
    Posted 9 months ago #

    Interesting. Didn't know it had been added to "built in". That happen in v3?

14. Ipstenu
    Half-Elf Support Rogue & Mod
    Posted 9 months ago #

    2.8 I think. Maybe 2.7

15. Andrea_r
    team pirate
    Posted 9 months ago #

    It was while back. Couple years anyway.

Reply

You must log in to post.