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.

The latest version: 0.10.2. Click the Download button below if you wish to try it.
Quant of downloads: 77088
download
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

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.10.2 [08.01.2016]

  • Fix: missed text was added to a translation
  • Japanese translation was added.

0.10.1 [16.11.2015]

  • Fix: Wrong "Scan" link under plugin row at the "Plugins" page was updated.

0.10 [29.10.2015]

  • 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

0.9.15

  • 01.12.2014
  • 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.

0.9.14

  • 30.06.2014
  • Polish translation was updated. Thanks to Grzegorz Janoszka.

0.9.12

  • 2.12.2012
  • 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.

0.9.11

  • 31.10.2012
  • 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.

0.9.10

  • 22.08.2012
  • Minor code cleanup and unused piece of code removing

0.9.9

  • 16.07.2012
  • Polish translation is added, thanks to Esej Konrad Łącki.

0.9.8

  • 15.04.2012
  • Lithuanian translation is added, thanks to Vincent G.

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 errors processing is made.

0.9.4

  • 28.12.2010
  • Italian translation is updated.
  • Latin translation is added.
  • Thanks to Alessandro Mariani for these translations update.

0.9.3

  • 14.10.2010
  • 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.

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 are 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.

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.

Tags: ,

  • 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()

  • 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).

  • 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.

  • 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?

  • Dear Vladimir,

  • 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.

  • 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 ?

  • 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.

  • 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

  • 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.

  • 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?

  • 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.

  • 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

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

  • Pingback: Plugins Garbage Collector Italian | ShinePHP.com()

  • 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

  • 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.

  • 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()

  • 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()

  • 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

  • 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.

  • 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

  • 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!

  • 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.

  • 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

  • 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.

  • 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()

  • Pingback: Top 10 WordPress Plugins to Spring Clean Your Blog()

  • Pingback: Free and Premium WordPress Plugins - Top WP Plugins |()

  • Pingback: How to Build Your Own Small Business Website in a Weekend | Small Business Marketing, Trunch, North Walsham, Norfolk.()

  • Pingback: Web Marketing - Top Free and Premium WordPress Plugins()

  • Pingback: SEO – Optimierung für WordPress Blogs | SEO Optimizer Blog()

  • Hi,
    Yes, you defined the problem correctly. Edit path to ‘wp-config.php’ in the ‘pgc-ajax.php’ to fix it. You can input full absolute path, or try this ‘../../../../wp-config.php’ there.

  • Yuri

    hi Vladimir
    i just installed the plugin and hit the “delete tables” button for the statpress plugin table.  Is this action exactly the same as if i went into myphpadmin, selected “wp_statpress” and then clicked on “drop”?  Or is it a different action in some/any way?

    Also, with your plugin it seems i can only delete the tables of deleted plugins.  Can i delete the table of an active or disabled plugin?   Or is there a reason i should not do that?

    I have the mbp-ping-optimizer plugin (disabled) which has a large table size (nearly 1 gig).  How can i get rid of this table?  Do i have to delete the plugin and then delete the table, and then re-install the plugin if i want to use it again?

    Or would you recommend “dropping” the table in myphpadmin and then enable the plugin again if i want to use it again?

    thanks for your help
    Yuri

  • Hi Yuri,

    >>Is this action exactly the same as if i went into myphpadmin, selected “wp_statpress” and then clicked on “drop”?
    Yes, this action is exactly the same. I execute ‘drop table “table_name”‘ command for selected table in this case.

    >> Can i delete the table of an active or disabled plugin?
    Deleting table of an active plugin will most probably lead to the PHP error and blog misfunction.
    I don’t allow to delete tables of disabled plugin as sometime it could be deactivated temporaly (for buggish plugin isolation fro example). In this case user can delete table just by mistake.
    So yes, you should deleted plugin first in order to get ability to delete its tables with help of PGC plugin.
    Some good made plugins deletes their tables themselves when you press ‘delete’ link in WordPress plugins panel.

    You may use as PGC as MyPhpAdmin, what’s more convenient for your purposes.

  • Yuri

    Hi Vladimir
    thank you for your response!  I have another question, not exactly related to your plugin but related to MyPhpAdmin, if you would be kind enough to help.

    I have some wp sites that i’ve “let go”. Domain is expired, i’ve deleted the website file in cpanel file manager, and i’ve removed the addon domain.  But when i was MyPhpAdmin,  i noticed the tables are still there for that site.

    Is there any reason i should leave the tables there?

    Or should i delete them?  If so,  after i “check all” do i then apply the “drop” or the “empty” action?  I don’t know what the difference is between “drop” and “empty”

    If “dropping” the table means to delete it,  and “emptying” the table means to keep it but empty it’s contents….  is it safe to “empty” the table on a plugin which is still active?

    thank you
    Yuri

  • If you don’t plan to restore data from the deleted domain sometime somewhere there is no reason to keep those tables in the database. Just drop them. 
    Drop command deletes the table itself – “delete table ‘table_name'” SQL command is executed.
    Empty command deletes all records/data/content from the table – “delete from ‘table_name'” SQL command is executed.
    It’s not safe to delete data from DB table which belongs to active plugin in the most of cases. Plugin could store some critical data there without which it could not work for example.
    So it’s more safe to deactivate plugin and delete its tables, then activate plugin, in order it will be fully re-installed from the scratch. 
    If you are sure that some DB table was empty after the plugin activation you can empty it without plugin work break, of course.

  • kent T

    hi, good day!

    I installed your plugin but it seems it doesn’t work. 

    It just stays on Plugins Garbage Collector page with the circling loading icon, but it doesn’t seem to work. I left it for 5 hours and when i get back it is still circling circling circling.

    Any advice? By the way i’m on wordpress 3.3

  • Anonymous

    @Kent T I also have WP 3.3 running and Garbage Collector is working fine on at least two different websites.

  • Thanks for sharing this information.

  • Hi Kent!

    As one of the reasons: if you have a lot of plugins installed, script could be interrupted by PHP execution time limit of your server. So, please answer how much plugins you have of your blog, including deactivated plugins?Is it possible to activate temporally DEBUG option in wp-config.php and execute PGC check again? May be you get some error message then, which could help to identify problem.

  • cd_user

    I’ve installed PGC on 2 separate websites recently, both running WP 3.3.1.  Both time PGC has shown 1 table in my database that I could delete.  (I know there’s others) 

    Is this plugin compatible with WP 3.3.1?

  • Yes, it works fine with WP 3.3.1 on my own sites.

  • I use a custom table prefix for security reasons and the plugin cannot seem to get past that? thx

  • It should. What it doesn’t recognize correctly now – situation when you have more than one WordPress DB instances with different DB prefixes at the same MySQL database simulteneously. Is it your situation?
    Does plugin show as a garbage some tables from WordPress core list for your active WP database or for other blog at the same MySQL DB?

    P.S. I’m at the holiday’s trip. So may answer with some delays.

  • beyond activating sucessfully, the plugin doesnt currently work for me at all. It crashes using all settings. I use the same prefix across the entire db. WP 3.41, garden variety apache cpanel shared hosting. thx

  • The *database* prefix (assigned by by host / cpanel / fantastico – my server username on the shared hosting server…) which I cannot change unless I do a custom WP Install and create the database myself…
    is one name; my *table* prefixes, as I mentioned before have been customized for security reasons

  • Alex

    Hi, I’m not sure if you’re still online on this thing but I’ve downloaded your latest version of this plug-in and it doesn’t seem to be working. I’ve clicked on scan and it doesn’t seem to be doing anything; that “busy” circle keeps going on on and on and on long before I click scan anyway.

    P.S. I have read the previous entry regarding this program and activating debugging mode didn’t work either.

  • Hello Alex,

    Are you agree to try version with additional debug output inserted in order to isolate the problem?

  • Alex

    Sure. Where can I find it? Or what can I do in order to make your plug in work properly?

  • I suppose that plugin has some problem with AJAX at your site. Let’s try to check. Download file pgc-ajax.php with debug output from this link
    http://www.shinephp.com/wp-content/downloads/wordpress/plugins/pgc-ajax.zip
    unpack and put it into plugin directory. Try to press ‘Scan’ button. Do you see ‘debug step 1’ output?
    If you don’t, let me know. If Yes, try to change constant definition at line 8 of pgc-ajax.php
    define(‘PGC_DEBUG_STEP’, 1);
    to
    define(‘PGC_DEBUG_STEP’, 2);
    and try to scan again.
    If you see ‘debug step 2’ continue to steps 3,4,5 and let me know about results.
    Thanks for your help.

  • Alex

    I’ve sent you an e-mail.

  • OK. Let’s proceed via e-mail.

  • Per

    Hi,
    I’m using Wordfence plugin (activated) and can you check why this plugins db turn up as red in your scan?

  • Hi,
    Thanks for your help in bugs hunting. Please try the updated 0.9.11 version.

  • Per

    Thxs,

    Works fine but I discovered 1 more plugin with same issue: DRP WordPress User Management

  • Per

    Have you had any chance to look into the issue with DRP WordPress User Management?
    Per

  • I find db table name at plugin code this way:

    get non-WordPress table name from your database, exclude configurable WordPress db-prefix, e.g. ‘wp_’ from it, then make text search through all plugin source code php-files.

    DRP WPUM plugin split its own db table names into 2 parts: its own db-prefix, which consists of WordPress db-prefix and ‘wpum’ constant, and the rest part of table name. Look on the sourse code from DRP WPUM:

    $this->_db_prefix = $wpdb->prefix.’wpum_’; // result is ‘wp_wpum’

    $sql = “CREATE TABLE “.$this->_db_prefix.”banned_ips (

    Thus I don’t see the universal way to define that ‘wpum_banned_ips’ db table belongs to DRP WPUM plugin, as plugin author doesn’t use ‘wpum_banned_ips’ string constant directly in his code.

  • Per

    Ok I understand. But can an other solutions be if your plugin allow us user to decide which plugin this redmarked table belongs to or as it works now the delete options?

  • Brilliant idea! I will definitely add this feature – plugin will use expert help from user. User will have variant for table from unknown plugin to decide himself, which installed plugin such db table could belong to and exclude it that way from the “red list”.

  • Looking forward to next release if this option can be available there… :-). If you need some pre-test just contact me and I can help you if needed.

  • Bob

    I downloaded Plugins Garbage Collector and ran a Search none-WP tables scan. I deleted the red items. Then I re-ran another scan..and all the same red items showed up again…as if they have not been deleted. Is this normal? How do I know your plugin is working correctly?

  • No, it is not normal. Did you see the notice like this ‘Tables are deleted successfully: ‘ after you press ‘Delete Tables’ button? Plugin should delete selected table in red really. It seems that some error occur in your case.

  • vajrasar

    what if I accidently clicked a green row? I did and it disappeared, was it deleted?

  • No, you just move that table to hidden mode. Turn on ‘show hidden tables’ checkbox and rescan again. You should see that disappeared table.

  • Victory

    hi! I downloaded Plugins Garbage Collector and pressed the button “scan”, but received the following answer “error – not found”

    could you help me please?

  • Hi,
    Show the screenshot with error message please.

  • lilo

    Hi, I just installed your plugin and scanned my database, mainly becuase statpress is taking huge amounts of my capacity, eventhough I deleted it 2 month ago. Now the result of the scan sais, that statpress is active and i cannot delete the tables. Do you have some advice, what i could do?

  • grigione

    Plugin don’t really clean all plugin uninstalled

    I have unistalled plugin Ether Content Builder WordPress Plugin but in
    my pages editor i have some custom fields values that ether plugin have
    created

    So i have tried to delete them by your plugin but it can’t find them in database

  • grafcom

    Hello, please see the support section https://wordpress.org/support/plugin/plugins-garbage-collector

    I tried to install the plugin and activate and it would not activate as it gives a fatal error. All other plugins deactivated but no luck.
    Different themes also no luck.
    PHP version 5.5
    WP version 4.0.1
    Thanks

  • Show PHP fatal error message please.
    Set WP_DEBUG to true at wp-config.php to see more details if needed.

  • This bug was fixed with version 0.9.15 release.

  • merismos

    I removed all the plugins on my wordpress site (deactivated, deleted) and only left PGC active…Still get the never ending spinnign circle…tried the suggestions shown here and none of them fixed it.
    I am using Version 4.0.

  • Please check browser JavaScript console. Are there any JavaScript errors? Try to set WP_DEBUG constant at wp-config.php to 1. May be WordPress will show PHP error message then, if it takes place.

  • J.R.R SANTACRUZ

    wp last version Error: Empty answer is received

  • After what action you get this error?

  • Łukasz Wenerski

    Hi, I have installed PGC, scaned, checked unused db and try to delete, and i have:
    403 ForbiddenYou don’t have permission to access this document.
    The same if want to uninstall plugin?
    Please help

  • Some file permissions problem take place possibly.
    You may delete plugin folder via FTP. It will be deactivated by WordPress automatically then.

  • Łukasz Wenerski

    I did it, thansk a lot for quick answer. 🙂

  • Installed plugin on WP 4.3.1 PHP 5.3 and run the plugin. It runs a few sec’s and then gives and error – “Internal server error” . I have no idea how to fix this issue or what is causing it. Can you please explain or offer a fix for it ?? Thank you

  • Try to activate PHP errors output, to get more information about a possible problem:
    https://codex.wordpress.org/Debugging_in_WordPress

  • Эдуард Манятовский

    Hi, I got an error

  • Open JavaScript console at your browser – “Tools -> JavaScript console” at Google Chrome and find at the “Network” tab the server answer which was caused the error: may be in red color or definitely differs from the correct server answer (look at screenshot). Show it me please.

  • Эдуард Манятовский

    It here

  • Эдуард Манятовский

    it here

  • I wished to look on the server response for the last request for pgc-ajax.php.
    2nd, try to deactivate all other plugins. Will the error repeat? If error will go away with plugins deactivated, reactivate theme one by one to find a plugin, with which PGC produces conflict.
    I will try to reproduce the issue then.

  • Эдуард Манятовский

    I disabled all plugins, but the error has remained

  • Эдуард Манятовский

    do so normal?

  • Эдуард Манятовский

    last request for pgc-ajax.php

  • Эдуард Манятовский

    two pop-up windows error

  • Thanks. There is not enough information at screenshots. Please click the latest request from pgc-ajax.php and select the Response tab for it, in order I may see what data server sent in its answer.

  • Эдуард Манятовский

    it

  • Strange things. It’s a correct answer, which should not produce an error.
    OK. I will rewrite plugin to use a true JSON instead of own custom format. I hope it will help. I will publish an update this week.
    Thanks for your help.

  • Try development version 0.10. It is available here:
    https://downloads.wordpress.org/plugin/plugins-garbage-collector.zip

  • Эдуард Манятовский

    All OK! Thank you!

  • Thanks for your help.

  • Hi, just installed your plugin but after I click ‘scan’ a message appears saying ‘you do not have sufficient rights’. Which is awkward as I’m logged in as admin. Any ideas? Thanks.

  • Hi Roeland,

    I suppose that you clicked ‘Scan’ link just under plugin row at the Plugins list. It contains invalid link which was fixed at the development version already. Open plugin page via “Tools->Plugins Garbage Collector” menu. Then click ‘Scan’.

  • Yeah exactly, that’s what happened. Thanks, your solution indeed worked.

  • Hi, i just installed the plugin I successfully ran a scan and found some tables to delete. My issue is that I cannot delete the necessary tables from the database (neither singularly or as a group). Am I missing something?-)

  • Hi,

    Can you show any error messages? May be from server logs…

    One possible problem – if you turned on a checkbox “Prevent the page from creating additonal dialogs” at the confirmation box, then plugin will not work until you clear browser cookies.