Does WordPress $wpdb functions wait when table is locked?
By itself wodb doesn’t do (and probably can’t) anything extra to what the DB will do. When the table is locked you will probably wait longer for a response or fail on timeout.
Database
$wpdb select all meta for each post
This is really simple. get_post_meta($postid); This will return all values in about the same syntax. In a more workable loop: <?php $custom = new WP_Query(array(“posts_per_page” => -1)) if( $custom->have_posts() ) { while ( $custom->have_posts() ) { the_post(); $data = get_post_meta(get_the_ID()); } } else { /* No posts found */ } ?>
How Yoast SEO plugin works with variable %%name%%?
It does not create tables, it stores data the “WordPress way” in the postmeta table, which is common to all WordPress functions. Because it’s common to all WordPress functions, the ID’s are going to be out of sequence for Yoast data, because it’s going to be “commingled” with much other data that gets stored in … Read more
How to update the values when the featured image has changed?
How to update the values when the featured image has changed?
How to translate this mySQL query to $wpdb query
How to translate this mySQL query to $wpdb query
Is there a way to recover the table wp_term_relationships?
I can’t offer you an explanation for what happened. But what I can unfortunately tell you is that you’ll have no luck on the WP side of things. There is no backup of that data. I guess your best bet is still trying to save this MySQL table. Have you contacted the hosting provider? Maybe … Read more
Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
wp_insert_post causing There was an error connecting to the database: Access denied for user ‘root’@’localhost’ (using password: NO)
wp_insert_post causing There was an error connecting to the database: Access denied for user ‘root’@’localhost’ (using password: NO)
Setup 3 Sites To Connect To 1 Database and Share Data
To elaborate on my suggestion, here is some working code: // hook in before theme is loaded add_action(‘plugins_loaded’,’custom_maybe_switch_themes’); function custom_maybe_switch_themes() { if (!is_user_logged_in()) {return;} if (!current_user_can(‘manage_options’)) {return;} // check for query request eg. ?usertheme=theme-slug if (isset($_REQUEST[‘usertheme’])) { // sanitize request $usertheme = strtolower(sanitize_title($_REQUEST[‘usertheme’])); global $current_user; $current_user = wp_get_current_user(); // maybe reset user meta stylesheet if … Read more