Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: rebuilding topics DB


_ck_
Participant

@_ck_

BBpress has no mass search/delete feature, unlike several wordpress plugins that are available. Even the upcoming search feature that was posting on the blog doesn’t seem to have an “action” ability, just search, which doesn’t make sense, so maybe there will be more to it.

Trying searching and deleting 50+ posts by hand, not worth it.

Recount will only update counts, not pointers.

I am just about finished with a new function to do this however.

Right now it only updates the last poster id and name, the trickiest part was figuring out the proper mysql expression to grab the last item while grouping by topic_id. Took an hour of research.

But in fact my routine could be extended further to rebuild the entire topics database from scratch if need be since all the data is in the posts and it’s just kept in the topics table for speed.

I just find it surprising there isn’t such a routine already and I am hoping I am not duplicating efforts already done.

Skip to toolbar