Lost post but present in DB

  • Resolved ghusse

    (@ghusse)


    13 years, 10 months ago

    Hi,

    I have a critical issue, after quick editing a post on my blog. This post just disappeared from my blog.
    It just does not appear the admin section, in the posts list. It does not appear in my blog. But, this post is still present in DB and I can edit it !

    I tried to edit it and save modifications, but it did not solve the issue. I tried to Check/repair all tables in the DB, I tried to export/import all data in DB (as I can not flush the tables). But I always have the same issue.

    After trying all this, I suppose that it comes from a data issue. Something may not have been correctly written ? Something that is only written when a post is created and not when it is updated ?

    Any idea of what I can do ?

    Thanks.

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

  • Hi ghusse,

    Are you sure the entry in the DB is the actual post and not a post revision?

    Can you copy the post content from the database entry and create a new post?

    Thread Starter ghusse

    (@ghusse)

    I can do that, but I also have a comment on this post. I’ll need to modify the post id foreign key value for it. I’d rather try a better solution before doing that.

    About the revision, I checked in the DB, I have a bunch of revisions pointing to an ID which is present in DB. It is flagged as “post” and not “revision”, with the published status.

    Thread Starter ghusse

    (@ghusse)

    If I stick it, this post appear in the first page. But if I remove this status, the post just disappear again !

    If you set it to sticky, does it also show in the frontend and the admin or just the frontend?

    I know it sounds simple, but for the sake of trouble shooting I would disable your plugins and re-activate one at a time to see one is causing the issue. You could also try switching to the default theme to test.

    Thread Starter ghusse

    (@ghusse)

    Nope, if I set it to sticky, it does not appear in the admin frontend either. So I don’t think that it comes from my theme, as the admin section is also affected.

    I’ll try to deactivate plugins, but I doubt it come from them because I have not updated them recently.

    Thread Starter ghusse

    (@ghusse)

    Plugins deactivation has no effect on this post.

    What version of WP are you running?

    Thread Starter ghusse

    (@ghusse)

    3.0.4

    Thread Starter ghusse

    (@ghusse)

    I finally found the problem.
    It seems that my quick edit have overridden the publishing date to 2009 !

    I changed it and everything just works like a charm !

    The only thing I can think of is to grab another post from the DB and compare values.

    ie)

    Make sure post_type = post, post_parent = 0, and so on…

    EDIT: Just realised you fixed it, well done!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Lost post but present in DB’ is closed to new replies.