Database Cleanup for JomSocial
- JomSocial 1.5
- JomSocial 1.6
- JomSocial 1.8
JomSocial leaves behind unnecessary database entries from old private messages (even if they've been deleted in the front-end) and old community activities (also even if they've been hidden in the front-end) that clog your database.
Allowing these entries to pile up will lead to a bloated database (which especially becomes a problem in shared-hosting environments) that will slow down your community as it grows and interacts. To help cure this deficiency and give you more control of how your community backend runs, we've created the Cleanup for JomSocial plugin, which allows you to finally take hold of a database running wild.
1. Cleanup JomSocial every X days
2. Clean private messages that were deleted in your front-end
3. Clean read private messages X days old:
4. Remove deleted activities
5. Remove activities X days old
6. Automatically Purge the Mail Que
7. Optimize the cleaned tables
8. Email a Cleanup Overview
Check out the download page for more information on this plugin's capabilities.
I think the code itself inside the cleanup.php file is mostly sound. There are a few bulky functions that could have been done more efficiently, and more complete features could have easily been added.
To sum: The code is amateur at best, will not fully install/uninstall correctly, and doesn't have all the features you will be wanting in the end. I would save the $5 and wait form someone to make a better product.
Amazing that you had trouble and nobody else did. The plugin is meant to cleanup database junk that JomSocial leaves behind, and it does just that, efficiently and effectively. Oh, and read your JomSocial documentation, which explains the Cron procedure. Otherwise, just email me if you need help with something you don't understand. Thanks!
