Best to work with your host on this type of specific issue. In general, when you have slow queries, a few things may help: Optimize the database – check and see if any tables are bloated compared to others. You may be able to turn off revisions and autosaves, or reduce the number of allowed … Read more
You should add the following code to the functions.php of your theme (and it is better to make all modifications in child theme): add_filter( ‘posts_search’ , ‘posts_search’ ); function posts_search( $search ) { $search = str_replace( ‘LIKE’, ‘COLLATE utf8_bin LIKE’, $search ); return $search; } It works. You can check it on my test site: … Read more
You have 2 two problems here: – You can’t use $wpdb-> with custom tables because [postmeta, posts, …] are variables in the class $wpdb. – WHERE ‘id’= 2 is not correct WHERE id = 2 So it should work: global $wpdb; $table_name = “_customtable”; $retrieve_data = $wpdb->get_results( “SELECT * FROM $table_name WHERE id = 2” … Read more
Regarding the var_dump, “courses” isn’t showing up because the var_dump is running outside of any action. So it gets triggered before the “init” action runs, which is where the post type is registered. Regarding the main loop, I pasted your code into the default Twenty Seventeen theme’s functions.php file, and added a course via the … Read more
I think you’re making this more difficult that it should be, If I understand correctly you want to display the latest 4 ‘videos’ which have been flagged as ‘our work’ in your first column and those flagged as ‘featured film’ in the next column, so you should actually add that custom field parameter to your … Read more
I’m too low level to comment but maybe this WP guide can help you. I didn’t want to copy and paste their answer in case it was against WPSE.
Look into MySQL Wildcards. The correct MySQL Query for your search should be WHERE tb_posts.post_content LIKE “%example.com%” You should also be sure that you only target published posts (in contrast to nav_menu_items, revisions etc). Expand your WHERE with this: AND tb_posts.post_type IN (‘post’,’page’,*All Posttypes you use additionally*) AND tb_posts.post_status=”publish” So your complete Query should look … Read more
that was easy to do directly in sql: UPDATE wp_posts SET post_content = replace(post_content,'</div>\r\n\r\n<div id=”postbottom”>’,'</div><div id=”postbottom”>’);
I think you should be able to do this with a tax_query in your $args. I could not test this, and I also dont know how the query behaves with a meta and tax query in one. But I would start with testing something like this: ‘tax_query’ => array( array( ‘taxonomy’ => ‘event_category’, // the … Read more
Looking at this, I see that “Paid”, a string, isn’t in quotes. That would cause an error. You can add $wpdb->show_errors() and $wpdb->print_error() methods to reveal that, and any other mysql issues. Also when querying the database, you should use the $wpdb->prepare() method to escape and prepare your variables for query (yes $user->ID probably can’t … Read more