[@affacat Member 17 years ago]

I noticed my import didn’t import a forum’s most recent post time correctly (it was set equal to forum start date instead)

i ran this to fix it:

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)