Hope this below SQL query will solve your problem- INSERT INTO wp_postmeta (post_id, meta_key, meta_value) (SELECT post_id, ‘tnid’, meta_value FROM wp_postmeta WHERE meta_key = ‘name’ AND post_id IN (SELECT id FROM wp_posts WHERE post_type LIKE ‘post’)) Please try it first. I haven’t got the chance to try it.
First of all, anything that involves LIKE just can’t be fast. If you want fast queries, avoid LIKE. On top of that, basically your combined query just don’t care if there is a repeat or not, so just one variation without checking the repeat field should be enough. Now why does the server crash is … Read more
Compare old meta with new post meta
get_post_metadata causing some meta data to fail
You can do all that within the loop using if conditions. So let’s say in the loop you have an article element wrap with the title and content inside. If you have if conditions that check for something, like meta data for example, output one article wrap, and another for another if statement, or else … Read more
So the easiest way i found is: $field = get_post_meta( $propostid, ‘_pf_error_log’, true ); $field[] = ‘new raw string’; update_post_meta( $propostid, ‘_pf_error_log’, $field ); But i will be happy to get a more simple and elegant solution…
Unfortunately you cannot perform a meta_query using a LIKE comparison on the meta_key value when using WP_Query. I’ve been down this road… Instead you have a couple other options if you want to maintain like status relationships as post meta and not user meta and or meta in a custom table. Option 1 requires no … Read more
Run Shortcode of post’s custom field in functions.php / Plugin
reading through your code … if ( is_wp_error($change_ok) ) { WriteErrorLog($change_ok->get_error_message()); } is not applicable as $change_ok will always be true. ref https://codex.wordpress.org/Function_Reference/switch_to_blog as the comments state it is better to use get_posts() and this may fix your issue, otherwise use $wpdb->prepare before your get_results. also a comment is that your SQL statement will not … Read more
Issue with using add_rewrite_rule() for post querying custom fields