Topic: re-sorting posts by date? · bbPress.org

Skip to:: Content; Pages; Categories; Search; Top; Bottom

re-sorting posts by date?

affacat
Member

@affacat

16 years, 8 months 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)

Viewing 1 replies (of 1 total)

affacat
Member

@affacat

16 years, 8 months 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)

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.