Longest post/comments (ID)

I checked the post id which WP SlimStat found as oldest and this ID dont exist so then is the question from where pics WP Slimstat post id from?

I have check in database and I can see the ID in WP posts but its not a normal post so I think you need to add a condition perhaps for post_type=post

Good catch. Fixed in 3.5.8.

Hi Camu

I double checked your sql query and it seems to be a combination of the oldest and longest post which is published so just a short question should it be that or only the oldest?

I dont get the oldest post id I suspect I get the oldest post which have the longest lenghts, wonder what interest this is to know as for comments its only the oldest and not with lenght combination.

Hi Camu,

Can you look into this last comment I did, the oldest post seems still be a combination of oldest and longest. I assume it should only be the oldest?

If not then we should show the oldest in combination with lenghts for comments as well.

Per

SELECT UNIX_TIMESTAMP(post_date) FROM wp_posts WHERE post_status = 'publish' AND post_type = 'post' ORDER BY post_date ASC LIMIT 0,1

This is the SQL code I’m using, and as you can see there’s no mention about content length ?? It’s just the OLDEST.

Yeah for post its ok but for comments its lenghts:
$your_content[‘longest_comment_id’] = $GLOBALS[‘wpdb’]->get_var(“SELECT comment_ID FROM {$GLOBALS[‘wpdb’]->comments} ORDER BY LENGTH(comment_content) DESC LIMIT 0,1”);

In fact, the English Title of that report is ‘Longest Comment ID’ ?? I’m not sure I understand the problem.

Problem was that I thought it was the oldest as for post but as you say it it the longest comment that should be visible. So no problem case closed

Thank you for keeping an eye on these things! Really appreciated ??