It’s in the post meta table (usually wp_postmeta), with the page id in post_id, meta_key with _wp_page_template and meta_value with the template file name.
The below code will help you to remove all the post meta’s except the thumbnail of a post. function kv_delete_all_meta_except_featuredimg(){ $args = array( ‘posts_per_page’ => -1, ‘post_status’ => ‘any’, ‘post_type’ => array(‘attachment’, ‘page’,’post’)); $articles= get_posts( $args ); foreach($articles as $article){ if($article->post_type == ‘attachment’){ $myvals = get_post_meta($article->ID); foreach($myvals as $key=>$val) { if($key == ‘_wp_attached_file’ || $key … Read more
As mentioned, after_switch_theme should be a pretty good choice. Your table create/update function will only run when you switch themes, which should be roughly like activating a plugin. If you use dbDelta to create and/or update the table there should be no issue with table creation. From the Codex: global $wpdb; $installed_ver = get_option( “jal_db_version” … Read more
Can’t save ajax value to database
You do not want a simple SQL solution. post_name is used to generate permalinks. If you simply copy the title to the name (slug) you will have spaces and punctuation in the URL, and that is going to be a problem. It will result in broken links. Additionally, you could end up with two posts … Read more
Per comments, you basically have it – just GROUP BY $wpdb->term_relationships.object_id instead; also to be pernickety, you’d use standard (INNER) JOINs rather than LEFT ones: SELECT $wpdb->term_relationships.object_id FROM $wpdb->term_relationships JOIN $wpdb->term_taxonomy ON $wpdb->term_taxonomy.term_taxonomy_id = $wpdb->term_relationships.term_taxonomy_id JOIN $wpdb->terms ON $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id WHERE name IN (394, 396, 988, 666) GROUP BY $wpdb->term_relationships.object_id ORDER BY $wpdb->term_relationships.term_taxonomy_id DESC
Strange Deadlock database error for the query “Delete From wp_options”
I solved the issue with the .user.ini file.
Based on your question, I am not exactly sure where your local build sits right now. This answer is assuming you are starting from scratch, but have a copy of a working wordpress website on a live web server, and working on a mac. You need to install a web server onto your local computer. … Read more
You should write a plugin, or compact the code needed for this in a child theme functions.php. About pulling data from external databases: the simplest way is to use php built-in functions. I would proceed this way: Register a shortcode to place your table wherever you want in WordPress, you probably want to pass some … Read more