Comments not showing

  • Image here

    I have a clients WP install, currently the theme has been reset to TwentySeventeen, and all plugins disabled.

    If you go to view comments in wp-admin, none show, except under “Approved” only.

    I’m logged in as an Administrator, and admins have all user role capabilities.

    This is puzzling.

    Any suggestions where to look next?

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

  • Hey @ttremain,

    Can you try to apply the solution presented here? https://nabtron.com/wordpress-no-comments-found-error-solved/ This seems to do the trick for some other users having the same problem.

    Thread Starter ttremain

    (@ttremain)

    I solved it earlier this evening. I found that in the comments table, many of the comments had outrageously high comment_ID’s.

    I had suspected it was something caused by a plugin the client had been using, that synced comments to Facebook comments, partly because it was the only plugin that had anything to do with comments, and the plugin had been abandoned a couple years back by it’s author (according to a WordFence scan.)

    So I reduced the comment_ID numbers, as well as the comment_parent numbers, and reset the AUTO_INCREMENT value.

    After this, I could see the posts, in both, the backend AND the frontend of the site.

    I can only suspect that 1 or more revisions back, WP did something in an update that limited these high numbers, or else the client moved hosts, and was maybe affected by a different version of MySQL (or even PHP?)

    But anyway, it’s resolved.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Comments not showing’ is closed to new replies.