{"id":24557,"date":"2020-04-23T16:40:21","date_gmt":"2020-04-23T14:40:21","guid":{"rendered":"https:\/\/exoconsult.com\/?p=24557"},"modified":"2020-10-31T15:23:16","modified_gmt":"2020-10-31T14:23:16","slug":"trouver-et-supprimer-les-post_meta-dupliquees","status":"publish","type":"post","link":"https:\/\/exoconsult.com\/fr\/non-classe\/trouver-et-supprimer-les-post_meta-dupliquees\/","title":{"rendered":"Trouver et supprimer les post_meta dupliqu\u00e9es"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Si vous voyez des cl\u00e9s meta dupliqu\u00e9es dans la table post_meta de WordPress, voici une requ\u00eate permettant de s\u00e9lectionner les cl\u00e9s \u00e0 supprimer.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM (SELECT meta_id FROM (SELECT meta_table_1.* FROM p1ct0f_postmeta meta_table_1, p1ct0f_postmeta meta_table_2 WHERE ( meta_table_1.post_id = meta_table_2.post_id AND meta_table_1.meta_value = meta_table_2.meta_value AND meta_table_1.meta_key = meta_table_2.meta_key ) ORDER BY meta_table_2.post_id) Table_All_Duplicates GROUP BY meta_id HAVING COUNT(*)>1) Unique_Dupes WHERE meta_id NOT IN (SELECT min(meta_id) AS min_meta_id FROM p1ct0f_postmeta GROUP BY post_id,meta_key,meta_value HAVING COUNT(post_id) > 1 AND COUNT(meta_key) > 1 AND COUNT(meta_value) > 1 AND COUNT(meta_key >= 1));<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Comme on ne peut pas supprimer des lignes d&rsquo;une table en se basant sur un SELECT, la solution trouv\u00e9e rapidement est de r\u00e9cup\u00e9rer les meta_id dans un fichier Excel et de cr\u00e9er la requ\u00eate SQL :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=CONCATENATE(\"DELETE FROM `wp_postmeta` WHERE `meta_id` = \" ; A2 ; \";\")<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Source : <a href=\"https:\/\/derrick.blog\/2019\/04\/17\/finding-duplicate-wordpress-post-meta\/\">https:\/\/derrick.blog\/2019\/04\/17\/finding-duplicate-wordpress-post-meta\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Si vous voyez des cl\u00e9s meta dupliqu\u00e9es dans la table post_meta de WordPress, voici une requ\u00eate permettant de s\u00e9lectionner les cl\u00e9s \u00e0 supprimer. Comme on ne peut pas supprimer des lignes d&rsquo;une table en se basant sur un SELECT, la solution trouv\u00e9e rapidement est de r\u00e9cup\u00e9rer les meta_id dans un fichier Excel et de cr\u00e9er [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":24642,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"page_builder":"","wds_primary_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-24557","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/posts\/24557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/comments?post=24557"}],"version-history":[{"count":1,"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/posts\/24557\/revisions"}],"predecessor-version":[{"id":24558,"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/posts\/24557\/revisions\/24558"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/media\/24642"}],"wp:attachment":[{"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/media?parent=24557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/categories?post=24557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exoconsult.com\/fr\/wp-json\/wp\/v2\/tags?post=24557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}