StudioPress

Forum navigation

Are You Using The WordPress Block Editor?

Genesis now offers plugins that help you build better sites faster with the WordPress block editor (Gutenberg). Try the feature-rich free versions of each plugin for yourself!

Genesis Blocks Genesis Custom Blocks

Comments have still disappeared

Welcome!

These forums are for general discussion on WordPress and Genesis. Official support for StudioPress themes is offered exclusively at My StudioPress. Responses in this forum are not guaranteed. Please note that this forum will require a new username, separate from the one used for My.StudioPress.

Community Forums › Forums › Archived Forums › General Discussion › Comments have still disappeared

This topic is: not resolved

Tagged: , ,

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • November 20, 2018 at 5:45 am #224471
    unklee
    Member

    I previously asked about comments that have disappeared (see https://studiopress.community/topic/comments-have-disappeared/).

    My comments no longer appear because the database has been corrupted, so that the field "comment_post_ID" is now set to zero for all approved comments (spam and trashed comments still retain their ID Number!). I am trying to find out the cause so it doesn't happen again.

    I did nothing to the database at the time (I didn't open phpMyAdmin until I found the problem), the only thing I did was to install Genesis 2.7. I don't know if the problem occurred after the new install, but it was around that time.

    Victor suggested the problem was unlikely to be caused by the install, but when I approached my host they suggested the Genesis install was most likely. I am not interested in blaming anyone, just understanding what could have caused this.

    Has anyone got any insight into how such a corruption could have occurred please? Thanks.

    http://www.is-there-a-god.info/blog/
    November 20, 2018 at 8:30 am #224474
    Victor Font
    Moderator

    Installing/updating Genesis does not alter WordPress tables or change content in the database unless it's Genesis specific, which comments are not. Can't you restore from a backup?

    Regards,

    Victor
    https://victorfont.com/
    Call us toll free: 844-VIC-FONT (842-3668)
    Have you requested your free website audit yet?

    November 20, 2018 at 4:18 pm #224495
    unklee
    Member

    Hi Victor, thanks for taking this interest.

    What you say about a Genesis update not touching the database seems right to me, but I want to find out what happened so it doesn't happen again. It doesn't seem to be a random corruption because all the approved comment_post_IDs have been turned to zero, which seems very systematic. If I didn't do anything myself apart from the update, then there has to be some other cause. And if my host has done something systematic to corrupt the table I want to know that too.

    I can restore from backup, but with some difficulty. My auto backup software didn't do the crucial update (no idea why), so I have had about 6 comments since the previous update. So I can restore all the older comments, then manually enter the correct ID Nos for the recent few. So I need to be careful not to lose anything, and I don't want to do it until the problem is resolved.

    If you, or anyone else, had any general ideas about how a database could be corrupted in this way, I would appreciate it. Thanks.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • The forum ‘General Discussion’ is closed to new topics and replies.