Orphaned Term Relationship are not deleted about wp-sweep HOT 5 CLOSED

Let's discuss it over here. It works fine on my host but I only tested on one site since I don't have access to more big sites.

It takes a long time for huge sites because it does a sub query. If you click Sweep a couple of times, does it process the remaining one or it is stuck at 8003 orphaned term relationship?

Can you run this query and tell me the output?

SELECT tr.object_id, tr.term_taxonomy_id, tt.taxonomy FROM wp_term_relationships AS tr INNER JOIN wp_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 wp_posts) LIMIT 100;

from wp-sweep.

It sticks to that number.
Here is the output: http://pastebin.com/MNPdS6i3

from wp-sweep.

Cool, thanks. I can reproduce it with the data. I will fix it tomorrow and update here again.

from wp-sweep.

@slaFFik fixed, can you try download the zip file https://github.com/lesterchan/wp-sweep/archive/master.zip and replace wp-sweep.php to the plugin folder to see if it works now before I release 1.0.2 to the public?

from wp-sweep.

Tested. Works fine.

from wp-sweep.