Hi Andrew,
At the moment, MediaPress uses Taxonomy( mpp-status) to store the privacy and privacy is stored as terms underscored with their actual value. E.g private is a term with slug _private and so on.

Please look into wp_terms_taxonomy for mpp-status and you will find the term_taxonomy_id for the terms here.

We need this to update the wp_term_relationships relation table. In this table, WordPress keeps object(say post type instance) to terms association. The object id is post id.

It is way much easier to do it in php using either WordPress API or MediaPress API.

Please look into it and let me know if you need any assistance from me.

Regards
BRajesh

PS:- Got your email too. Let us keep the conversation here for now.

Hi Andrew, I will break into 3 queries and post. It is much easier if you used the calculated value from the first 2 in the 3rd query

1. Find the term_taxonomy_id for _private term in the mpp_status taxonomy

SELECT tt.term_taxonomy_id FROM  wp_term_taxonomy AS tt, wp_terms AS t WHERE tt.term_id = t.term_id AND tt.taxonomy="mpp-status" AND t.slug="_private"

Let us say, it gives you value t1

2. Find the value of term_taxonomy_id for _public

SELECT tt.term_taxonomy_id FROM  wp_term_taxonomy AS tt, wp_terms AS t WHERE tt.term_id = t.term_id AND tt.taxonomy="mpp-status" AND t.slug="_public"

Let us say you got the value t2.

Now, all we need to do is update the terms_relationships table and set the new tetm_taxonomy_id

Example

UPDATE wp_term_relationships set term_taxonomy_id = t2 WHERE term_taxonomy_id = t1;

Please make sure to replace the value and use proper prefix.

Future Notes:- We are moving away from the current taxonomy based approach to flat table in the 2.0. The PHP API will remain same but the above queries won’t work.

Hi Andrew,
Thank you.

I did not specify the object id as I had assumed you wanted to do the bulk update.

Glad that you got it working.

Regards
Brajesh