I know this is an old question, but for anyone still looking how to achieve this, the following query should do the job: UPDATE wp_users INNER JOIN wp_usermeta AS fn_meta ON wp_users.ID = fn_meta.user_id AND fn_meta.meta_key = ‘first_name’ INNER JOIN wp_usermeta AS ln_meta ON wp_users.ID = ln_meta.user_id AND ln_meta.meta_key = ‘last_name’ SET wp_users.display_name = CONCAT(fn_meta.meta_value, … Read more
Outside of subqueries, MySQL will only process 1 query at a time. When running sql statements through phpmyadmin, it just executes 1 query after the other. To do the same thing in WordPress, it appears you just use 1 query per $wpdb object (those can have subqueries if desired, but not what’s needed here).
I don’t know of any plugin specifically for this, there’s nothing in WP that will do this but it’s not too difficult to implement with a little php, even 20k posts shouldn’t be too extreme. Depending on your server settings you may need to do some workarounds to make sure the connection stays alive but … Read more
Upon testing this on my demo site it seems to work perfectly well simply storing DateTime columns as a %s (String). After inserting like this the database reports the DateTime column exactly as expected.
There are two ways to edit the wp_posts table that I know of. The first is with the wp_update_post() and wp_insert_post() functions. These are typical WP functions that are used like any others. You just have to pass the correct parameters. For example: $my_post = array( ‘ID’ => $updatePostID, // User defined variable; the post … Read more
There are, still, references to old domain in your database, which have to be fixed. Step 1: go to Settings -> Permalinks and click on Save Changes button. This will fix your permalinks. Step 2: install and activate Better Search Replace plugin. Go to Tools -> Better Search Replace. Replace the old domain ( example.com … Read more
WP options (which is one of the most basic and used storage APIs) can be stored with or without “autoload” setting. Usually this is reasonable, since many options will be checked on each and every page load, so loading them in bulk during core load is much more efficient than individually. Problems usually start when … Read more
I had the same problem. There is no equivalent function. $wpdb->insert_id works only after $wpdb->insert Alternative way If it’s an update, you can either get the id with a query based on the data you have got, or most of the time, you should have already got the id before update it. global $wpdb; $data … Read more
I don’t see anything wrong with the widget class. The problem you have is that you are displaying the widget area, that contains the widgets, twice in your sidebar.php: <aside id=”secondary” class=”widget-area col-sm-12 col-md-12 col-lg-12″ role=”complementary”> <div class=”col-lg-6 col-md-12″> <?php dynamic_sidebar( ‘main-widget’ ); // this will display all the widgets in your main-widget sidebar ?> … Read more
You should be able to get away with just adding AND $wpdb->posts.post_status=”publish” at the end. $prepare_string = ” SELECT DISTINCT ID FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON ( $wpdb->posts.ID = $wpdb->postmeta.post_id ) LEFT JOIN $wpdb->postmeta AS mt1 ON ( $wpdb->posts.ID = mt1.post_id ) WHERE ( ( $wpdb->postmeta.meta_key = ‘event_date’ AND $wpdb->postmeta.meta_value >= %d ) OR … Read more