bbPress

Info

• 2 posts
• 1 voice
• Started 4 years ago by affacat
• Latest reply from affacat
• This topic is not resolved

Tags

• Posts in this topic

re-sorting posts by date?

1. • 
   • affacat
   • Member

   • Posted 4 years ago #

   after successfully importing smf->phpbb2->bbpress I have one lingering problem: posts are sorted by creation date, not most recent post.

   Is there an easy solution to fix this?

   (my integration escapades can be found here:
   http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress
   )

   (I'm also having issues getting pretty permalinks to work but that's for another day)
2. • 
   • affacat
   • Member

   • Posted 4 years ago #

   this appears to do the trick:

   UPDATE
   bb_topics
   set topic_time =
   (SELECT bb_posts.post_time
   from bb_posts
   where bb_posts.topic_id=bb_topics.topic_id
   ORDER BY bb_posts.post_time DESC LIMIT 1)

3. You must log in to post.