Forums
-
- Forum
- Posts
-
- Installation
- 28,255
- Troubleshooting
- 61,766
- Themes
- 10,301
- Plugins
- 15,220
- Requests & Feedback
- 14,815
- Showcase
- 3,252
-
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)
See also: WordPress.org • bbPress.org • BuddyPress.org • Matt • Blog RSS