{"id":849,"date":"2006-12-01T18:09:17","date_gmt":"2006-12-01T16:09:17","guid":{"rendered":"http:\/\/www.mummila.net\/nuudelisoppa\/index.php\/?p=849"},"modified":"2006-12-01T18:09:17","modified_gmt":"2006-12-01T16:09:17","slug":"wordpress-mass-edit-allow-pings-fields-with-sql","status":"publish","type":"post","link":"https:\/\/mummila.net\/nuudelisoppa\/2006\/12\/01\/wordpress-mass-edit-allow-pings-fields-with-sql\/","title":{"rendered":"WordPress: mass edit &#39;Allow Pings&#39; fields with SQL"},"content":{"rendered":"<p>I&#8217;d previously closed pinging for all ancient posts to prevent trackback spam, but after installing <a href=\"http:\/\/akismet.com\/\">Akismet<\/a> my blogs have ceased to suffer from it, so I decided it was time to re-open them.<\/p>\n<p>Took me some time to find the appropriate SQL spells, but I finally came across the right ones at WP&#8217;s support forums: by applying <a href=\"http:\/\/wordpress.org\/support\/topic\/19950#post-114170\"><b>btvillarin&#8217;s<\/b> SQL instructions<\/a> I was able to achieve somewhat the reverse of what he was aiming at:<\/p>\n<p><code>UPDATE wp_posts<br \/>\nSET ping_status = &quot;open&quot;<br \/>\nWHERE ping_status = &quot;closed&quot;;<\/code><\/p>\n<p>This causes all posts with their ping status currently closed be changed so that they&#8217;re once again open for pings.<\/p>\n<p>Note that you might have to replace wp_posts in the above with <i>yourtableprefix<\/i>_posts, in case you have changed the default table prefix.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;d previously closed pinging for all ancient posts to prevent trackback spam, but after installing Akismet my blogs have ceased to suffer from it, so I decided it was time to re-open them. Took me some time to find the appropriate SQL spells, but I finally came across the right ones at WP&#8217;s support forums: [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[9387],"class_list":["post-849","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-blog"],"_links":{"self":[{"href":"https:\/\/mummila.net\/nuudelisoppa\/wp-json\/wp\/v2\/posts\/849","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mummila.net\/nuudelisoppa\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mummila.net\/nuudelisoppa\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mummila.net\/nuudelisoppa\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mummila.net\/nuudelisoppa\/wp-json\/wp\/v2\/comments?post=849"}],"version-history":[{"count":0,"href":"https:\/\/mummila.net\/nuudelisoppa\/wp-json\/wp\/v2\/posts\/849\/revisions"}],"wp:attachment":[{"href":"https:\/\/mummila.net\/nuudelisoppa\/wp-json\/wp\/v2\/media?parent=849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mummila.net\/nuudelisoppa\/wp-json\/wp\/v2\/categories?post=849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mummila.net\/nuudelisoppa\/wp-json\/wp\/v2\/tags?post=849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}