WordPress.org

Support

Support » Requests and Feedback » Recently Discussed

Recently Discussed

  • I was wondering if anyone knows of anything or can create a hack that would enable me to display the top 5 most recently discussed posts. Meaning, every time a post was commented on, it would go to the top of the list, and it would display how many posts. For an example of what I mean, check out the top right of http://www.deadyetliving.com/test/index.shtml

Viewing 12 replies - 1 through 12 (of 12 total)
  • You mean a recents comments ?
    http://mtdewvirus.com/wp-hacks/

    not really. Not only is there no post title displayed with that plugin, but it would often list the same post right under itself.
    So while I would want something like this:
    First Post (3 comments)
    Second Post (4 comments)
    Third Post (3 comments)
    Even if it did display post titles, it would do something like this:
    First Post (3 comments)
    First Post (3 comments)
    Third Post (3 comments)

    Just yesterday I added an option to show it with commentor name and post title. Not quite what you are looking for…but another option.

    Awesome, that will definately be a big help.

    Unfortunately, it’s giving me some MySQL syntax errors. Any idea why?

    Just so you know, here’s the message it’s giving me:
    Database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ WHERE .ID=.comment_post_ID AND post_status = ‘publish’ AND po]
    SELECT ID, comment_ID, comment_content, comment_author, post_title FROM , WHERE .ID=.comment_post_ID AND post_status = ‘publish’ AND post_password =” AND comment_approved = ‘1’ ORDER BY comment_ID DESC LIMIT 5
    Warning: Invalid argument supplied for foreach() in /home/deadyet/domains/deadyetliving.com/public_html/wordpress/wp-content/plugins/recent-comments.php on line 18

    I think I should have been doing a LEFT JOIN on the tables instead of the WHERE. I updated it to version 1.11. Let me know how it works.

    It’s still givin me the same problem. Where can I check to make sure I got the right version?

    In plugins when logged into WP it should tell you the version #

    Do you have any comments on your site? It will probably error if there aren’t any comments.

    No, there’s comments. And it was indeed the right version. :-/

    I had a few things messed up…try the latest version. My fault…sorry!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Recently Discussed’ is closed to new replies.
Skip to toolbar