@Bri Beaut. This looks like the exact kind of thing to crib from.
Hello, after months of running NodeBB instance, I've acculumated quite a few data from my database. But perhaps I've made something wrong with my mongodb, there are still some failure to our forum, i.e, I could not delete certain user from our chat room whereas I can when adding user to chat room.
Is there any plugin or tool that can clean and tidy the database of my own, cleaning the dirty data from our database? Thanks.
Yeah, a cleanup plugin would be nice to verify consistency of the database. Good idea
Anybody good ideas? As the forum develops, the data that once is useful would be discarded when we upgrade the forum. So consistency is important.
@jiangcaiyang I am pretty sure that this already exists for MongoDB:
But to be honest I doubt that it is that heavily needed unless you run a really big database. What would indeed be quite useful would be an option to purge deleted posts and topics all at once over the AdminCP.
@AOKP It is, that I would make the mongo database dirty, I mean, by accidentally insert-delete some data from MongoDB, and result in unreasonable failure on NodeBB, the data zombie I could tell, so I need a tool to clean them.
I will use this tool then.
Difficult to know what data is used, and what isn't. Plugins are able to add data anywhere in the db, and many do just that (instead of keeping everything in their
settings:pluginName hash), as it is just a suggestion.
I feel like this is way outside of the intended use for plugins. Although you can make a plugin to do this, there are already tons of standalone tools for database maintenance that will be better than anything you could possibly make with a plugin.
I could not delete certain user from our chat room whereas I can when adding user to chat room.
I faced the same problem when upgrade to 1.10. But I could delete user after create a new room. So I think it must be caused by the consistence of data in DB.