Database Cleanup
Has anyone written an app to clean up the database?
I've experienced an error with deleting users. It doesn't remove everything about the user. While this error needs to be fixed, it leaves strange things around in its wake.
For example, I have "blank" friends in my friends list. I have "blank" followers, etc...
It would be cool if there were an app that on occasion would take a look at the users in the database, and make sure all of the friends, follows, groups, albums, etc... all still have an owner assigned to them. If not, delete the orphans. That way any errors that show their ugly face during day to day operation would ultimately be cleaned up over time.
Does such a thing exist? I'm not a developer, so if not, go for it!
-
I too have been concerned with this, especially over a long period of time and large number of members. I've been testing deleting users from back end, and deleting from front-end (user deletes his own profile).
The results are not as I expected. There are a lot of ghosts left behind.
-
Yes, there is such a thing. There are quite a few pages that have two URLs. Here are examples of such pages: https://unacms.com/i/so-is-there-anyway-to-get-rid-of-such It turns out that when deleting an account or user, some URLs still give a 200 response, not 404.
-
I also wrote somewhere here that when you delete a comment, it is deleted, but the page remains. Here is an example: https://unacms.com/cmts-view/gxfvoz?sys=bx_forum&cmt_id=49592
-
That's a bug for sure. All these ghosts need addressed.
-
Good idea. This should be standard equipment, perfectly integrated with the latest versions of UNA. Executed from the Dashboard, at the push of a button.
Even if a paid app, it would be well worth the money. One obvious problem though, is where there is two of something, each item be fixed individually.