[wp-trac] [WordPress Trac] #42936: get_adjacent_post won't find any posts that are published in the same minute

[WordPress Trac]

#42936: get_adjacent_post won't find any posts that are published in the same
minute
----------------------------------------+---------------------
 Reporter:  sheepysheep60               |       Owner:  (none)
     Type:  defect (bug)                |      Status:  new
 Priority:  normal                      |   Milestone:  5.6
Component:  Posts, Post Types           |     Version:  4.9.1
 Severity:  normal                      |  Resolution:
 Keywords:  needs-patch good-first-bug  |     Focuses:
----------------------------------------+---------------------

Comment (by engahmeds3ed):

 Replying to [comment:4 peterwilsoncc]:
 > * change the clause to `WHERE p.post_date >= $current_post_date AND p.ID
 != $current_post_id ORDER BY p.post_date, p.ID`
 > * use the `WHERE` clause @talldanwp suggests above and use PHP to remove
 the current post ID

 I tried both solutions on this video
 https://www.youtube.com/watch?v=ASMoo0RmXkM and I think this generates
 another issue.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/42936#comment:5>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform