JomSocial won its third CMSexpo Award. Enjoy 20% Discount Sitewide until 24th May! Learn More
Home Download Addons Core enhancements Database Cleanup for JomSocial
This addon is submitted by a 3rd party developer, which means it is not part of JomSocial official product lines. Please forward your bug reports or support request to their respective support channels (forum/ticket/etc).

Database Cleanup for JomSocial

Visited
1031
Version
1.0
Compatibility
  • JomSocial 1.5
  • JomSocial 1.6
  • JomSocial 1.8
License
Commercial
Modify core files
No
JomSocial is a wonderful community component for the Joomla! content management system, but it's not easy on your site's database, especially if you have a large and active community.

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.
Screenshots
Reviews
byjthm0138, August 9, 2010
2 of 2 people found this review helpful
I have no idea how anyone allowed this to be released. To start the documentation never tells you what to run as a cronjob (if using the cronjob version). The product does not install in the format set forth by joomla, and thus if you need to uninstall you WILL get errors and have to not only remove files manually but clear cleanup out of you database manually before you can install the non cronjob version.

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.
Owner's reply

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!