wp_set_object_terms timing out?

Dealing with terms is known to be very heavy operation. The common tweak recommended is to use wp_defer_term_counting() to temporarily disable updating of terms count (which is stored persistently in database and so must be updated when you change terms).

SQL Bulk Move old posts by one author to another category

Try something like this: global $wpdb; $from_user = 2; $to_user = 5; $posts_table = $wpdb->prefix . ‘posts’; $users_table = $wpdb->prefix . ‘users’; $strQuery = “UPDATE `$posts_table` SET post_author = $to_user WHERE post_author = $from_user AND $posts_table.post_date < ’01/01/2013′ AND $wpdb->term_taxonomy.term_id IN (1,2,3) AND $wpdb->term_taxonomy.taxonomy = ‘category'”; echo $strQuery; $wpdb->query($strQuery); For more info please visit this … Read more

Adding custom Bulk Actions

Unfortunately it’s still not really doable in a clean way. You can see the latest about this here in this trac ticket #16031 I just checked the source and the filter is still basically the same.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)