Retrieve comments marked as spam?

  • Resolved redthruviolet

    (@redthruviolet)


    14 years, 8 months ago

    Today I accidentally deleted a legitimate comment as spam.
    We just have the vanilla WordPress Comment core, ie, we do not use Azimith.

    I have looked everywhere in our WordPress and on the Forums and Documentation, but have not yet found a way to retrieve the comment marked as spam by mistake.

    Is there a way to retrieve a comment marked as spam by mistake?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter redthruviolet

    (@redthruviolet)

    Whoops, I met akismet, not Asimith!….

    Thread Starter redthruviolet

    (@redthruviolet)

    Dear WordPress Forum:

    I found the solution –

    1. Login to the WordPress database, using PhPMyAdmin

    2. Find the comment in the wp_comments table, and edit it as below

    3. In the wp_comments record, edit the field, comment_approved, from spam to 1 (1 means approved)

    4. Logout of the WordPress database

    5. Login to WordPress

    6. Under Manage Comments, find your restored comment, and unapprove it, then approve it again

    7. Logout of WordPress

    8. That’s it!….

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Retrieve comments marked as spam?’ is closed to new replies.

Tags