Duplicate content metadata cleaning does not work

There are four types of duplicated meta checks, which one you are referring to? You can see the query being run here https://github.com/lesterchan/wp-sweep/blob/master/wp-sweep.php#L446 that determines the details.

It can be when the plugin sweeps it, it just gets recreated by other plugins. Not sure if that is the case, but it happens before.

Hello Lester Chan,

Thanks for your help.

There’s 2 348 duplicated elements.
The clean button action is duplicated_postmeta

Regards,

Olivier

Can you run SELECT GROUP_CONCAT(meta_id ORDER BY meta_id DESC) AS ids, post_id, COUNT(*) AS count FROM wp_postmeta GROUP BY post_id, meta_key, meta_value HAVING count > 1 in phpmyadmin to see what it returns?

Hello Lester,

Sorry, the result of this is an error:

Error SQL query: Documentation

SELECT GROUP_CONCAT(meta_id ORDER BY meta_id DESC) AS ids, post_id, COUNT(*) AS count FROM wp_postmeta GROUP BY post_id, meta_key, meta_value HAVING count > 1 LIMIT 0, 25
MySQL said: Documentation

#3 - Error writing file '/tmp/MYVk2BMk' (Errcode: 28 "No space left on device")

Looks like a server issue, you have to contact your host.