WordPress.org

Ready to get started?Download WordPress

Forums

Where are pending comments stored in the wordpress database? (4 posts)

  1. calisuri
    Member
    Posted 1 year ago #

    When I am logged into WordPress as an admin, i see i have 4099 comments waiting.

    If I chose the 'Comments -> All Comments' I do see a bunch of ping backs/trackbacks that are awaiting my approval. ( I have Disqus installed which handles most of my regular comments)

    If i click on 'edit' on one of these pending items, I am take to this type of URL where the c variable changes based on the item:
    /wp-admin/comment.php?action=editcomment&c=21859

    So I assumed that in my wordpress database i could look up this comment using this sql select:

    mysql> select * from wp_comments where comment_ID='21859';
    Empty set (0.00 sec)

    The result is no results.

    Does anyone know where I can find these in my database?

    Thanks!

  2. vtxyzzy
    Member
    Posted 1 year ago #

    Try the query without the quotes around the ID.

  3. calisuri
    Member
    Posted 1 year ago #

    Same result.

    Thank you so much for replying btw - I just couldn't believe this was not some easy solve!

    mysql> select * from wp_comments where comment_ID=21859;
    Empty set (0.00 sec)

  4. vtxyzzy
    Member
    Posted 1 year ago #

    Really odd - it works for me.

Topic Closed

This topic has been closed to new replies.

About this Topic