[wp-trac] [WordPress Trac] #11302: Bulk editing posts should pre-fill fields with the same value / allow for removal
WordPress Trac
noreply at wordpress.org
Fri Sep 20 12:46:25 UTC 2019
#11302: Bulk editing posts should pre-fill fields with the same value / allow for
removal
-----------------------------+-----------------------------
Reporter: pavelevap | Owner: (none)
Type: enhancement | Status: new
Priority: normal | Milestone: Future Release
Component: Quick/Bulk Edit | Version: 2.9
Severity: normal | Resolution:
Keywords: needs-patch | Focuses:
-----------------------------+-----------------------------
Comment (by samba45):
Possibile soluzione, interrompere la relazione SQL tra post e category con
script da phpmyadmin.
Del tipo:
Supponiamo di avere il prefisso della tabella wp_blog, lanciando il
comando “delete from wp_blog_term_relationships where term_taxonomy_id = 1
and object_id in (select id from wp_blog_posts where post_type = 'post'
and post_status = 'publish’);” rompiamo la correlazione fra i due elementi
(post e uncategorized) questa azione ha valore solo su il post settati su
“pubblicati”.
Riportiamo il valore counter della categoria uncategorized.
Da phpmyadmin:
“update wp_blog_term_taxonomy set count = 0 where term_taxonomy_id = 1;”
Metodo da usare con cautela, rischio danneggiamento database SQL, fare
backup prima di qualsiasi azione.
Risultato : Rimuove “uncategorized dai post”
--
Ticket URL: <https://core.trac.wordpress.org/ticket/11302#comment:47>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform
More information about the wp-trac
mailing list