Plugins Garbage Collector WordPress plugin

Plugins Garbage Collector

Plugins Garbage Collector

Plugins Garbage Collector

Plugins Garbage Collector

This plugin scans your WordPress database and shows the tables which not belong to the core WordPress installation.
Some WordPress plugins create and use its own database tables. Those tables (small and large) are left in your database after plugin deactivation and deletion often. If your blog is more than 1 day old you have some plugins garbage in your WordPress database probably. With the help of this plugin you can check your database and discover if it is clean or not. Plugin shows not WordPress tables list with quant of its records, size they occupy in Kb. Plugin name and plugin state are shown too if those data are available.
Changes made to the core WordPress database tables (columns added) could be discovered too.

Version 0.9.7 is available. Click the Download button below if you wish to try it.

Attention! Starting from version 0.9.2 plugin works with WordPress 3.0 and higher only. For earlier WordPress versions use plugin version 0.9.1 from here.

Quick Links

FAQ
download

Look at “Plugins Garbage Collector” plugin in action screenshot:

Plugins Garbage Collector in action
  • Red color rows with high probability show old deleted plugins forgotten tables, so-called plugins garbage, which can be deleted from your WordPress database with the help of Delete Tables button or some of your favorite database tools, e.g. phpMyAdmin.
  • Blue color rows show tables which belong to deactivated plugins. Those tables are probably candidates for deletion after you decide to delete theirs parent plugins.
  • Green color rows show tables which belong to active plugins. Those tables are now in use. You do not need to touch them.

How Plugins Garbage Collector works? It selects all table names from your WordPress database, excludes core WordPress installation tables, then scans your plugins directory .php files text for table names and shows you the result as written above.

Delete Tables button appears if you have red color rows in the scan results table only. You need to turn on checkbox near the table name if you decided to drop it before click the Delete Tables button.
Attention! Delete table operation can not be rolled back. Please double think what are you doing before use Delete Tables button.
Plugins Garbage Collector is the decision support tool only and its conclusion about table usage can be wrong in some (I hope rare) cases. For example, if plugin developer uses some sophisticated scheme to assign names for his tables, not puts simple text into source code e.g. ‘my_plugin_table_name’, but calculates it with some algorithm e.g. ‘my’.'_’.'plugin’.'_’.'table’, etc… Final decision is for you – blog owner.

It is highly recommended to make database backup before apply any actions to your WordPress database.

Do you have a suggestion what useful feature we can add to this plugin? Please, left your comments.

Translations

Dear plugin User,
if you wish to help me with this plugin translation I very appreciate it. Please contact me via Contact form and I will answer you by email. Do not forget include your site link in order I can show it with greetings for the translation help at shinephp.com, plugin settings page and in this readme.txt file. If you have better translation for some phrases send it to me. You are welcome!

Special Thanks to

  • alx359 – for contribution to the source code which fixed AJAX empty response for WordPress multi-site with subdomains and other stuff.

You are welcome! Help me in the bug hunting, share with me new ideas about plugin further development, contribute to the source code and link to your site will appear here.

ChangeLog

  • 0.9.7 = 28.07.2011
    - AJAX empty response for WordPress multi-site with subdomains is fixed – thanks to alx359.
    - AJAX error processing is enhanced slightly.
    - Minor enhancements to plugin page CSS are made.
  • 0.9.5 = 16.01.2011
    - Chinese Simple translation is added.
    - Minor change to pgc-ajax.js error processing is made.
  • 0.9.4 = 28.12.2010
    - Italian translation is updated.
    - Latin translation is added.
  • 0.9.3 = 14.10.2010
    - Bug fix: database table name had been processed in the lowercase format and table could not be deleted if have uppercase letters in its name. It is fixed now. If database table has ‘dbTableWithSomeData’ name, you will see it as ‘dbTableWithSomeData’, not as ‘dbtablewithsomedata’. Thanks to [Deirdre](http://unlimitedwhispers.com) who found this bug.
  • 0.9.2 = 27.09.2010
    - Technical update for WordPress 3.0 full compatibility. Staff deprecated since WordPress v.3.0 is excluded.
    - Italian translation update. Thanks to Alessandro Mariani.
  • 0.9.1 = 07.07.2010
    - options form layout problem is fixed. That was wrong pgc-admin.css file version issue.
  • 0.9 = 01.07.2010
    - You can mark tables which you do not wish to see as scan results as hidden.
    - You can search extra columns in the core WordPress tables, which could be added by plugins.
    - Czech translation is added.
  • 0.6 = 25.05.2010
    - Dutch translation is updated.
  • 0.5.2 = 18.05.2010
    - Italian translation is updated.
  • 0.5.1 = 14.05.2010
    - German translation is updated.
  • 0.5 = 12.05.2010
    - Italian translation is added.
    - Lost translation domain inserted into a few places in the source code. Translators a welcome to update their work :) .
  • 0.4 = 03.05.2010
    - “Delete Tables” button is added
    - General code cleanup
  • 0.3 = 02.05.2010
    - German, Japanese translations are added
    - Another text domain ‘pgc’ missing bug is fixed
  • 0.2 = 01.05.2010
    - French, Indonesian, Spanish translations are added
    - Text domain ‘pgc’ missing bug is fixed
  • 0.1 = 29.04.2010
    - 1st pre-release of the “Plugins Garbage Collector” WordPress Plugin.

FAQ

Coming soon. Just ask it. I will search the answer.

download

I am ready to answer on your questions about this plugin usage and help with possible problems. Use Plugins Garbage Collector plugin forum or this page comments and site contact form for that please.

Thanks,
Vladimir, ShinePHP.com.

If looking for quick success then make best use of testking 640-822 notes, testking 642-813 dumps and testking 642-832 practice exam to hit your goal on first try.

Tags: WordPress, wordpress plugin

  • Pingback: Как почистить базу от ненужных данных | Plugins Garbage Collector | темный Незнайка светлый Wordpress | n-wp.ru

  • Gene

    A delete button would be fantastic. A lot of users are not tech savvy and wouldn’t know how to use PhpMyAdmin to remove the DB entries.

  • Geoffrey Plauche

    “Do you have a suggestion what useful feature we can add to this plugin? May be you wish to have Delete button for not used tables right here to not go to phpMyAdmin?”

    This would be a really nice feature.

  • shinephp

    Thank you, Gene and Geoffrey, for your support. I will implement the “Delete” feature for unused tables definitely in one of the next update.

  • IndianGirlsclub

    Thank you very much. This is the plugin i'm looking for.
    Recently after my site was hacked twice, i'm learning about database and cleaning them.

    I deleted some of the tables in myphp without any clue if it's wanted or unwanted.

    Yes, A “Delete” button would be very helpful.

    Thanks Shinephp !

  • shinephp

    Thanks. I appreciate your support. I'm working on delete tables functionality and it will be added in a few next days.

  • Pingback: Plugins Garbage Collector v. 0.4 is available | ShinePHP.com

  • http://shinephp.com Vladimir Garagulya

    Interesting… Please send the screenshot with PGC scan results to vladimir[at-sign]shinephp.com
    Any additinal information, may be PHP error log messages will be useful too.

  • willchapman

    I installed version .2 and have used the automatic upgrade option for versions .3. and .4.

    In both cases the upgrade has taken place successfully but the plugin page still shows the old version as being installed and that there is an update available (looking at the source code header indicates 0.4 installed correctly).

  • http://waterwaywatch.org qbuster

    My installation (0.4 running on the Atahualpa Theme with Buddypress/WP on a Linux server) seems to be working but only partially.

    The results of my scan just shows a list of tables with only two columns – Table Name and Plugin Name. In all cases the Plugin Name is 'Unknown'. Everything is in RED and the tables listed appear to those that are empty.

    I could send you a screen image if you tell me where to send it.

  • http://shinephp.com Vladimir Garagulya

    Do you use any cashing engine? Try to make full refresh for plugins page. Or clear your browser cach before open it. May be it will help. Is this issue exists for the PCG plugin only? What you WP shows for other plugins updated recently?

  • http://waterwaywatch.org qbuster

    Dear Vladimir,

  • http://shinephp.com Vladimir Garagulya

    Hi Hema,

    Yes, PGC is compatible with WP 2.9.2. I developed it under 2.9.2 and use it myself under 2.9.2.
    Is it your 1st try to Scan database with PGC plugin or previous versions worked for you?
    Can you check PHP error log on your webhost? If yes, please send to it to my email vladimir[at]shinephp.com
    If it is suitable for you I'm ready to check the problem directly on your site.

  • http://www.indiangirlsclub.com Hema Latha

    Hi Vladimir,

    Nothing happens after clicking Scan. It's just plain without any tables displayed.

    Screenshot: http://i44.tinypic.com/1gr4f6.jpg

    Is Plugins Garbage Collector 0.4 compatible with version 2.9.2 ?

  • http://shinephp.com Vladimir Garagulya

    Thanks Will. You helped me to identify the problem with PGC plugin for webhosts running under MySQL 4. I will update the code to use “show table status” statement instead of direct query to information_schema.tables as information_schema database doesn't exist under MySQL 4.

  • http://waterwaywatch.org qbuster

    The good news is that my webhost (Dataflame they deserve a mention!) responded magnificently and less than 12 hours after I identified the problem (they were using MySQL 4.x) have upgraded MYsql to 5.2x and PHP to 5.2.9.

    As a result PGC is working perfectly!

    I am now trying your User Role Editor – so far, so good!

    Thanks

    Will

  • http://www.indiangirlsclub.com Hema Latha

    Hi Vladimir,

    Sorry for the late reply. I was in the process of changing the host.

    Earlier i complained that the plugin is not working. Now it's working PERFECTLY FINE.
    Just in few seconds i cleared off the tables.

    That's really a fantastic job.

    Thank you very much for making this plugin :)

  • Pingback: Удалить плагин WordPress | meteorr - Feel the force Sith

  • Wpae

    Hi Vladimir, I'm using Plugin Garbage Collector on WordPress 2.9.2
    Every time I try to “Scan” I get a 504 Gateway Timeout error.
    Thank you for help.

  • http://shinephp.com Vladimir Garagulya

    Hi Wpae,
    It seems that you have a lot of plugins installed and PHP script execution time limit is exausted. PGC plugin tries to scan all plugins .php file for table names inclusion. It needs time.
    Please confirm the large quant of plugins installed at your WP. I met one guy with 100+ plugins in /plugins folder, the most of which were deactivated.
    Can you increase PHP script execution time limit? Of course it is possible for dedicated server only.
    Possibly I should check the execution time left and return at least partial scanning results…
    Thanks for the signal.

  • wpae

    Hi Vladimir, every time I try to “Scan” I get a 504 gateway timeout error. How's possibile?

  • http://shinephp.com Vladimir Garagulya

    Hi!
    Please read my answer on your previous comment below. I wait your next message.

  • wpae

    Oh I'm sorry, I didn't see it.
    No, I've got just 30 plugin installed, 23 activated and 7 deactivated.

  • http://shinephp.com Vladimir Garagulya

    What value for PHP max_execution_time parameter is set on your host?
    Is it possible for you to email me your plugins list? I will build test environment similar to yours and check the issue.

  • wpae

    Ok, I'm sending… thank you very much

  • http://shinephp.com Vladimir Garagulya

    Thanks. I received it. I will return with my investigations result in a couple of days.

  • Pingback: Plugins Garbage Collector Italian | ShinePHP.com

  • http://shinephp.com Vladimir Garagulya

    I made a test with 63 plugins installed, 30 from which are from your list. Look at screenshot
    http://www.shinephp.com/wp-content/uploads/2010…
    Scan process took 14 seconds only on my PC. Real server should fulfil this work much faster. Please check your web host PHP max_execution_time parameter.

  • wpae

    the value of max_execution_time is 1800

  • http://shinephp.com Vladimir Garagulya

    I see that max_execution_time limit is not the problem in this case. Some other timeout is working here probably. I will refactor the scan operation with AJAX in order to show current progress of scanning process which should exclude such behaviour.
    Thank you for the patience :) .
    P.S. Why do you not use 'Reply' button to keep our discission in the one thread?

  • wpae

    I will use it, I promise! :)
    Thank you for help.

  • http://shinephp.com Vladimir Garagulya

    Hi,
    I updated plugin to work via AJAX with showing current progress. Please find time to try this beta version
    http://www.shinephp.com/wp-content/downloads/wo…
    Let me know how it works on your site and if timeout error is gone.

  • Pingback: Plugins Garbage Collector Dutch | ShinePHP.com

  • http://shinephp.com Vladimir Garagulya

    Problem was in table meta data SQL query compatibility with MySQL version. It is fixed. I use more universal form now. Update will be published with next plugin version.

  • Pingback: Plugins Garbage Collector česky | Jindrova životní cesta

  • Pingback: Les plugins Wordpress indispensables

  • Pingback: Plugins Garbage Collector für WordPress

  • http://twitter.com/Deirdre_B_Pride Deirdre

    I have tried to delete the red garbage collected, but it keeps showing back up and I have errors on my site. I know that once the garbage is gone the errors will go away. They always do, but for some reason they wont delete…………………HELP PLEASE

  • http://shinephp.com Vladimir Garagulya

    Are there any error messages after you click ‘Delete’ in PGC plugin?
    I need administrator access to your WordPress installaton to check the problem and try to help. If it is suitable for you send URL, login and password via this site contact form.

  • http://twitter.com/Deirdre_B_Pride Deirdre

    Are there any error messages after you click ‘Delete’ in PGC plugin?I need administrator access to your WordPress installaton to check the problem and try to help. If it is suitable for you send URL, login and password via this site contact form. _______________________________________________________________http://unlimitedwhispers.com, login: mpromp2 Password: carlton1968

  • http://shinephp.com Vladimir Garagulya

    Thanks for the trust, Deirdre. It is very dangerous to show your blog admin credentials at the Web. I had meant that you use “Contact” link to send it to my email. I recommend you to change your admin password ASAP.You helped me to fix the bug. Please update ‘Plugins Garbage Collector’ to the 0.9.3 version and try to delete unused db table with it. Previous version could not delete table if it has uppercase letters in its name. It is fixed now.Thank you for the help.Regards,Vladimir.

  • Will Chapman

    The Garbage collector is excellent but I got myself in a hassle when I deleted some tables that belong to Buddypress forums (see below) which, because they weren’t shown as being linked to a plugin, I deleted..

    Buddypress is a strange hybrid being both plugin and child theme which is probably why it Garbage Collector didn’t pick it up.

    Buddypress and is likely to become even more popular than it already is as the developer is now working fulltime for WordPress.

    wp_bb_forums 0 1 unknown deleted?
    wp_bb_meta 2 6.15 unknown deleted?
    wp_bb_posts 0 1 unknown deleted?
    wp_bb_term_relationships 0 1 unknown deleted?
    wp_bb_term_taxonomy 0 1 unknown deleted?
    wp_bb_terms 0 1 unknown deleted?
    wp_bb_topics 0 1 unknown deleted?

  • roberte

    hi. does this work with wp 3.0.1 multisite + buddypress 1.2.6? if so, do you activate JUST on the main blog or network wide? i am guessing activation just on the main blog will be fine, but just want to make sure. thanks!

  • http://shinephp.com Vladimir Garagulya

    Hi,
    It should work with WP 3.0.1 multisite + buddypress. As for BuddyPress, please, be aware that plugin shows bbPress forum db tables as unknown (as bbPress is not a WP plugin) and allows to delete it. Do not do that.
    Plugin not work with all network at once it work just with current blog you login or selected as superadmin. Thus it works not with main blog only, but with any sub-blog or site in your multi-site environment, for which site PGC plugin is activated.

  • http://twitter.com/VeraSoul VeraSoul

    Hi Vladimir, Мне очень нравится этот плагин, but i´ve found 3 incompatible plugins while I was using it into my blog http://www.verasoul.com The result of having the next 3 plugings installed (doesnt matter active or not) it popups a window error.

    1. wp-ecommerce (it was deactivated). I have to deleted from plugin options and scan again.
    2. wp super edit wordpress emoticons (it was deactivated). Ive done the same that before.
    3. wp super cache (it is activated). This one is very important because many people have it installed

    It is a pleasure to check your plugins and they´ll have a post as long as I check them ;) . Thanks

  • http://shinephp.com Vladimir Garagulya

    Thanks for the signal. I will test this plugin with 1,2,3 from your list together and return with the results or PGC plugin update.

  • Pingback: 9 WordPress Plugins for Routine Maintenance Checks | Submit Press Release.in

  • Nope

    does not work with WPMU. Nothing appears in tools.

  • http://shinephp.com Vladimir Garagulya

    Thank you for the information. I checked the subject and confirm – this plugin doesn’t work with WordPress in the multi-site configuration. It was never tested with that. From other side, why not? I will investigate the problem and try to adopt “Plugins Garbage Collector” to the multi-site environment.

  • Pingback: Top WordPress Plugins