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.
The latest version: 0.10.3. Click the Download button below if you wish to try it.
Quant of downloads: 95375
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.
Look at “Plugins Garbage Collector” plugin in action screenshot:
- 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 Tablesbutton 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.
Do you have a suggestion what useful feature we can add to this plugin? Please, left your comments.
- Chinese Simple: Owen
- Czech: Jindřich “Masterbill” Rubeš
- French: Simon
- Dutch: Arthur
- German: Christian
- Japanese: Yoichi
- Indonesian: Masino Sinaga
- Italian: Alessandro Mariani
- Latin: Alessandro Mariani
- Russian: Vladimir Garagulya
- Spanish: Melvis E. Leon Lopez
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!
- 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.
- Fix: 1st plugin in the alphabetically ordered plugins list was always skipped at the scan process.
- Fix: missed text was added to a translation
- Japanese translation was added.
- Fix: Wrong “Scan” link under plugin row at the “Plugins” page was updated.
- use WordPress AJAX API and JSON for data exchange
- move some logic to the client and split the whole task for the smaller parts to exclude server time limit PHP error for the sites with large quant of plugins installed.
- use jQuery UI progress bar
- restructure code
- escape translated text
- Fix for fatal error during activation with fresh install of WordPress 4.0 (missed WPLANG constant caused plugin to stop execution).
Unfortunately it worked fine under WP 4.0 with wp-config.php from previous version with WPLANG defined.
- Polish translation was updated. Thanks to Grzegorz Janoszka.
- Dutch – Nederlands translation was updated. Thanks to Harald Labout.
- load_plugin_textdomain() call moved to the ‘plugins_loaded’ hook for higher compatibility with translation plugins.
- In case other plugin had some uppercase letters at the DB table name PGC failed to define that plugin as table owner. It is fixed now.
- Minor code cleanup and unused piece of code removing
- Polish translation is added, thanks to Esej Konrad Łącki.
- Lithuanian translation is added, thanks to Vincent G.
- 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.
- Chinese Simple translation is added.
- Minor change to pgc-ajax.js errors processing is made.
- Italian translation is updated.
- Latin translation is added.
- Thanks to Alessandro Mariani for these translations update.
- Bug fix: database table names had been processed in the lowercase format and tables could not be deleted if have uppercase letters in it. It is fixed now. If database table has ‘dbTableWithSomeData’ name, you will see it as ‘dbTableWithSomeData’, not as ‘dbtablewithsomedata’. Thanks to Deirdre who found this bug.
- Technical update for WordPress 3.0 full compatibility. Staff deprecated since WordPress v.3.0 is excluded.
- Italian translation update. Thanks to Alessandro Mariani.
- options form layout problem is fixed. That was wrong pgc-admin.css file version issue.
- 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
- Dutch translation is updated.
- Italian translation is updated
- German translation is updated
- Italian translation is added
- Lost translation domain inserted into a few places in the source code. Translators are welcome to update their work :).
- “Delete Tables” button is added
- General code cleanup
- German, Japanese translations are added
- Another text domain ‘pgc’ missing bug is fixed
- French, Indonesian, Spanish translations are added
- Text domain ‘pgc’ missing bug is fixed
- 1st pre-release.
Coming soon. Just ask it. I will search the answer.
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.