- This topic has 2 replies, 2 voices, and was last updated 5 years ago by .
- The forum ‘General Discussion’ is closed to new topics and replies.
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.
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/
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?
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.
© 2023 WPEngine, Inc.