Hey there,
I've had an issue recently with a plugin that duplicates indefinitely meta_keys for my Woocommerce products, so this plugin seemed like the right solution (I'm not sure how to do this myself in phpmyadmin..)

I have like 40000 duplicates.
But.. when I sweep, nothing happens, no error message, nothing..

I'm running this on a private SQL server.

Thank you for your help !
Bonjour de GamerZ !

Hello,
i try to install your plugin on Wordpress Multisite 4.7.1 and i have this issue when i try to activate.
L’extension n’a pas pu être activée, car elle a déclenché une erreur fatale.

Thank you.

Hi,

After sweeping orphaned term relationships, I get 63.190 Orphaned Term Relationships Processed, but the details line still shows Orphaned Term Relationship 63,190
The count was originally 64,000+ and after several sweeps got down to 63.190, but no matter how many more sweeps I do, it sticks to 63.190.

I've run your query from issue #1 , replaced wp_ prefix with my own table prefix and this is the result http://pastebin.com/tZETkmg5 Note that the same database is used by 3 wordpress installs with different table prefixes.

In a table: Transient Options - 31,036
After cleaning them up got this message: 31 Transient Options Processed

Problem with number_format()?

Many sites leave the wordpress defaults, it might be good to add a sweep to check for them and remove them if they exist:

• Hello World Post
• Sample Page
• Default Mr. WordPress Comment
• Default Tagline

Hi

I'm using WP Sweep to delete a lot of revisions (nearly 1300) in a local environment (xampp).

After some hours the process was not completed, so I closed the page and I have found that only 50 revisions were deleted

How can I make it work?

thanks for your plugin and time

Sometimes we come across sites that have bad encoding issues in the content, would be great to sweep for these.

UPDATE wp_posts SET post_content = REPLACE(post_content, '“', '“');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'â€�', '”');
UPDATE wp_posts SET post_content = REPLACE(post_content, '’', '’');
UPDATE wp_posts SET post_content = REPLACE(post_content, '‘', '‘');
UPDATE wp_posts SET post_content = REPLACE(post_content, '—', '–');
UPDATE wp_posts SET post_content = REPLACE(post_content, '–', '—');
UPDATE wp_posts SET post_content = REPLACE(post_content, '•', '-');
UPDATE wp_posts SET post_content = REPLACE(post_content, '…', '…');

UPDATE wp_comments SET comment_content = REPLACE(comment_content, '“', '“');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, 'â€�', '”');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '’', '’');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '‘', '‘');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '—', '–');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '–', '—');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '•', '-');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '…', '…');

Could you add expiry filter when delete transients? As option or as built-in behavior.

$time = isset ( $_SERVER['REQUEST_TIME'] ) ? (int)$_SERVER['REQUEST_TIME'] : time() ;
$expired = $wpdb->get_col( "SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE '_transient_timeout%' AND option_value < {$time};" );

foreach( $expired as $transient ) {
       $key = str_replace('_transient_timeout_', '', $transient);
       delete_transient($key);
}

https://wordpress.stackexchange.com/a/6652

Hi

I did a network activation for a multisite.
I would like to see a screen in the multisite section for cleaning the full multisite.
Can this be done? Do I have to go to each sub site and run it there? Or can it be run from the Network Admin?

Thanks.

Currently, I think the UX can be confusing. In my opinion, the main issue is related to the WordPress notices. For one "section" (for instance Comment Sweep), multiple notices don't stack. Instead, the latest notice overwrite the previous one.

Therefore, users can easily miss bits of information. For instance, my screen shows "2 Auto Drafts Processed", while there was also "3 Revisions Processed".

A few possible improvements

• Move the Sweep All button to the top. Users should have to scroll all the way to do this. I'm pretty sure most users will end up using "Sweep All" only.
• When users click on Sweep All, show all notices at the top (instead of being on top of every section). Because currently, users has to scroll to see what happened.

A quick example

Lemme know what you think...

At all. Doing something quite long.

Than shows this messages: 8 Orphaned Term Relationships Processed
Although in a table I see this: Orphaned Term Relationship - 8003

Initially posted here: https://wordpress.org/support/topic/orphaned-term-relationship-are-not-deleted?replies=1

A custom builder method could

• make it secure (each item sanitized and escaped) and
• more readable.

// implode( '\',\'', $this->get_excluded_taxonomies() )
$this->build_sql_list( $this->get_excluded_taxonomies() )

Warning: Division by zero in /home/***/public_html/wp-content/plugins/wp-sweep/admin.php on line 184

I use Disqus in my blog, so I don't keep comments in my database. Naturally, when WP-Sweep uses the code below:

<?php echo round( ( $deleted_comments/$total_comments ) * 100, 2 ); ?>

It returns a warning of "division by zero". This is of course, one of the five lines of code that checks the comments table.

The code below works better:

<?php echo ( $total_comments > 0 ? round( ( $deleted_comments / $total_comments ) * 100, 2 ) : 0 ); ?>%

But I suggest you use a simple function that you can use anywhere to make the code cleaner:

<?php

function check_percentage( $check, $total ) {

    return ( $total > 0 ? round( ( $check / $total ) * 100, 2 ) : 0 ) . '%';

}

?>

The Orphaned Term Relationship count is 87. Every time I run the Sweep plugin, it says "Orphaned Term Relationship processing" but the count stays at 87. Any help with this issue will be appreciated.

URL: http://www.vanndigital.com/

Hi @lesterchan

First of all, I love your plugin, love the slick design and specially that it is under top level Tools.

My question is simple.

Is there a difference in the sweeping between WP Sweep and WP-Optimize ?

Let me elaborate that:

Right now i install both plugins, since i'm a perfectionist that likes to keep the database as clean as possible. Now, i'm afraid of using just Sweep (which is the one i prefer to use) since i'm not sure if it cleans and optimize DB exactly the same as WP-Optimize. See what i mean ?

Does they clean different stuff that overlap most of them, or they clean the same ?

I just want to get rid of WP-Optimize, but i feel it cleans stuffs that WP Sweep don't. Hopefully viceversa.

Thanks in advance for the reply.

CodeClimate is free for open source projects, and now supports WordPress standards for PHPCodeSniffer. It would be great, and can be done by creating a simple config file.

Repo on CodeClimate
https://codeclimate.com/github/lesterchan/wp-sweep/

Example .codeclimate.yml
https://docs.codeclimate.com/docs/example-codeclimateyml

PHP Code Sniffer config instructions:
https://github.com/codeclimate/codeclimate-phpcodesniffer

Adding a feature request for WP-CLI support.

It would be great to have a small documentation and an example.

We could develop a Behat test suite like in WP-CLI
https://github.com/wp-cli/wp-cli/blob/master/features/db-check.feature

or at least a small shell script using wp-cli.

I develop lots of projects that use oEmbed. It would be nice if WP-Sweep will allow me to clear oembed cache stored in the WP database.

It's not hard to implement this, you just need the search in wp_postmeta table all the fields starting with oembed and delete them. Just like you delete transians and draft's.

For more info, i found this post on the web:
https://siteorigin.com/clearing-oembed-cache/

I use this SQL to clear my embed cache:

DELETE
FROM   'wp_postmeta' 
WHERE  'meta_key' 
LIKE   '%_oembed_%'

Rami Y.
GenerateWP.com

Hi,

Haven't checked too much the plugin, but does it have functionality to whitelist and not delete specified meta info for posts? From a quick look the impression is that it deletes everything, which may break some websites.

For example it deletes meta data for nav_item created with this plugin https://wordpress.org/support/topic/wp-sweep-delets-if-menus/
Is there a possibility that plugins can do something like this?

<?php

add_filter('wp_sweep_whitelist_meta_keys', function($metas = []) {
  $metas[] = 'this-meta-key';
  $metas[] = 'that-meta-key';
  return $metas;
});

Cheers

Would be great if there was an option to bypass running everything through PHP and just do a single query to delete orphan/duplicate data when relevant. For example: I run queries to delete or find orphan meta fairly regularly on a range of quality / scale of sites. In all those times I've never cared about the actions that would have fired on deletion for those specific cases and a single MySQL query would have been just fine. As a way to offer a faster/more efficient option his seems like a simple feature that could be added if you would find it useful for your users.

I would love to see support for the rest api, here is a quick working code example:

/**
 * Sweep Rest Routes initialization class.
 */
class Sweep_Rest_Api {

	/**
	 * Create the rest API routes.
	 *
	 * @access public
	 * @return void
	 */
	public function __construct() {

		
		add_action( 'rest_api_init', function(){
			register_rest_route( 'sweep/v1', 'sweep', array(
				'methods'  => array( 'get', 'delete' ),
				'callback' => array( $this, 'sweep' ),
				'permission_callback' => array( $this, 'permission_check' ),
				'args'     => array(
					'name' => array(
						'required'    => true,
						'default'     => '', 
						'description' => 'What would you like to sweep?',
						'type'        => 'string',
					),
				),
			));
		});
		
				
	}

	
	/**
	 * get_stream function.
	 * 
	 * @access public
	 * @return void
	 */
	public function sweep( WP_REST_Request $request ) {
		
		$name = $request['name'];
		
		$sweep = new WPSweep();
		
		$results = $sweep->sweep( $name );
		
		return rest_ensure_response( $results );
	
	}

	/**
	 * Check whether the function is allowed to be run.
	 *
	 * Must have either capabilities to enact action, or a valid nonce.
	 *
	 * @param  [type] $data [description]
	 * @return [type]       [description]
	 */
	public function permission_check( $data ) {
		if ( ! current_user_can( 'manage_options' ) ) {
			return new WP_Error( 'forbidden', 'You are not allowed to do that.', array( 'status' => 403 ) );
		}
		return true;
	}
	
}	
new Sweep_Rest_Api();

Some times we can not delete revisions as some of them could be useful. But for sure, 1 year old revisions are not longer need it. Maybe a good way to decrease database and to keep important work is to be able to delete just older revisions.

thanks

Hi! Any danger cleaning up orphaned relationship data or post meta data with the 2 plugins on the subject?

Thank you

The Sweep page under tools has this message:

Before you do any sweep, please backup your database first because any sweep done is irreversible.

But if it's installed, Sweep could referer to the local install menu of WP-DBManager.

Hi,

I'm Andrea from yithemes.com
I write to you because I need to add the support for your plugin and our multi vendor plugin.

The YITH WooCommerce Multi Vendor Premium plugin create a new product taxonomy to simulate a marketplace and, when an user create it for first time, this taxonomy haven't any product linked to it, but this not means it's an orphan terms.

How can I exclude the yith vendor term ?

Let me know.
Thanks
Have a nice day

AG

Hi @lesterchan,

In these lines, shouldn' it be %1$s and %2$s?
https://github.com/lesterchan/wp-sweep/blob/master/admin.php#L73
https://github.com/lesterchan/wp-sweep/blob/master/admin.php#L80
https://github.com/lesterchan/wp-sweep/blob/master/admin.php#L217
https://github.com/lesterchan/wp-sweep/blob/master/admin.php#L334
https://github.com/lesterchan/wp-sweep/blob/master/admin.php#L391

While reviewing the changes made in a recent version of the plugin because it was flagged by one of our security monitoring systems, we ran across a minor security issue in the plugin. The AJAX accessible functions ajax_sweep_details() and ajax_sweep() now in the file /inc/class-wpsweep.php are lacking a capabilities check to make sure only the intended users have access to them. You do have a nonce check in those functions. While a nonce check would normally do the equivalent of a capabilities check, the documentation for that states it shouldn't be relied on for that:

Nonces should never be relied on for authentication, authorization, or access control.

If you are cleaning a large database, sweeping can take a while. Adding a status or progress indicator would be great.
Something to know the process didn't hang.

Like: xx of yyyy left.

Generate POT file using https://wordpress.org/plugins/wp-sweep/admin/?action=pot

So we can translate the plugin to other languages.

• Auto Draft details all say Auto Draft rather than the post/page name.
  A: Yeap, that is what is being stored in WordPress.
• Sweep of Orphaned Term Relationship does not appear to work.
  A: Looks like you got the same error thrown by WordPress as well.
• If Details are displayed and you press Sweep for that area, you might want to clear the details, since they no longer apply.
  A: Good point.
• Unused Terms - Uncategorized is shown as a term that will be deleted, but I believe that is a WordPress default, so should probably be excluded.
  A: I will take a look at it
• Unused Terms - One of the post formats supported by my theme, post-format-gallery, is shown as a term that will be deleted. Is that safe to delete? Will it be recreated?
  A: That I am not sure, it depends on the theme actually.
• Unused Terms - I have a parent category that has nothing assigned directly to it, but it has children. It is shown as a term that will be deleted, but since it is a parent, it is actually used and should not be deleted.
  A: Good pickup. Unused Terms to be honest is tricky, so many possible cases. Thanks for picking it up. I will fix it. Maybe I will use unused tags.

Source: https://wordpress.org/support/topic/beta-testing-for-103?replies=11

Hello, Lester!
I have 2 feature requests I hope you will take under consideration:

1. Add a checkbox under the Sweep All button to ignore unused terms ( checked by default )
2. Add the possibility to do a Sweep All ( that ignores unused terms ) on a skedule ( daily, weekly, every 2nd week and monthly )

Best regards,
Eusebiu

Hello, Lester!
First of all I want to say congrats for creating this plugin. I played with it on a test environment and I noticed there are warnings at the Comment Sweep section when no comments exist.
Warning: Division by zero in \wp-sweep\admin.php on lines 184, 202, 220, 238 and 256.

I'm also curious if you plan on adding automated sweeps like WP Optimize does.

I think language and post_translations are swept out in "Orphaned Term Relationship" while belonging to Polylang.

Maybe Polylang should hook wp_sweep_excluded_taxonomies?

Hi!

I am the author of Polylang. A user reported some issues when using WP Sweep and Polylang together. In fact, he lost the language and translations relations of his categories and post tags.

Polylang is a multilingual plugin entirely based on taxonomies. It does defines taxonomies for posts (as usual) but also taxonomies for terms (it's not frequently used by developers but possible). I am not the inventor of the concept and I have also seen plugins having taxonomies for users (although I don't remember which one). I have never seen it in a plugin, but we could also imagine to create taxonomies on comments.

I had a very quick look at your code and found:
$query = $wpdb->get_results( "SELECT tr.object_id, tr.term_taxonomy_id, tt.term_id, tt.taxonomy FROM $wpdb->term_relationships AS tr INNER JOIN $wpdb->term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy != 'link_category' AND tr.object_id NOT IN (SELECT ID FROM $wpdb->posts)" );
Some other queries are similar in the way they exclude taxonomies and object ids.

I foresee 2 solutions to the issue:

1. Add a filter to exclude more taxonomies than just 'link_category' which I could use to add Polylang taxonomies to the exclusion list.
2. Add more object ids in your exclusion list. Not only posts but also terms and users. Potentially links (in case a plugin creates another taxonomy than 'link_category') and comments if you want to be on the safe side.

I would like to see added support to clear out completed action-scheduler events. This is used by several popular plugins, WooCommerce being the biggest.

Please add codeclimate and trvis bagdes to readme.
Move badges to the top!

Hi @lesterchan

I recently switched from using Wp-Optimize to use Wp-Sweep, but after find this on the documentation of WooCommerce Follow-Up Emails plugin, i'm concerned.

Is this true ? I'm just concerned as i manage a lot of Woocommerce websites and wouldn't want data to be erased while doing an sweep.

Thanks for your reply in advanced.

As you mentioned in the documentation of this plugin that it does not work with elementor plugin on wordpress, is still not compatible yet till now? I need this plugin to clean up my junk database because of elementor plugin, my database become huge (for about 40 Gb) with elementor and multisite inside my hosting. Please let me know this compatibility, Thankyou before

For example

function render_sweep_admin( $group, $slug, $title, $count, $total ) {

            ?>
            <tr>
                <td>
                    <strong><?php esc_html( $title ); ?></strong>
                    <p class="sweep-details" style="display: none;"></p>
                </td>
                <td>
                    <span class="sweep-count"><?php echo esc_html( number_format_i18n( $count ) ); ?></span>
                </td>
                <td>
                    <span class="sweep-percentage"><?php echo esc_html( WPSweep::get_instance()->format_percentage( $count, $total ) ); ?></span>
                </td>
                <td>
                    <?php if ( empty( $count ) ) : ?>
                        <?php _e( 'N/A', 'wp-sweep' ); ?>
                    <?php else : ?>
                        <button data-action="sweep" data-sweep_name="<?php echo $slug; ?>"
                            data-sweep_type="posts" data-nonce="<?php echo esc_attr( wp_create_nonce( 'wp_sweep_' . $slug ) ); ?>"
                            class="button button-primary btn-sweep"><?php _e( 'Sweep', 'wp-sweep' ); ?></button>
                        <button data-action="sweep_details" data-sweep_name="<?php echo $slug; ?>"
                            data-sweep_type="posts" data-nonce="<?php echo wp_create_nonce( 'wp_sweep_details_' . $slug ); ?>"
                            class="button btn-sweep-details"><?php _e( 'Details', 'wp-sweep' ); ?></button>
                    <?php endif; ?>
                </td>
            </tr>
            <?php
}

render_sweep_admin( 'post', 'revisions', __( 'Revisions', 'wp-sweep' ), $revisions, $total_posts );