I know this is an old thread, but is there a place to put in a feature request to be able to disable the live search from the Theme Panel. We have several sites which have over 100k posts and the live search thrashes the database. Since it does auto search as you type, it can fire off multiple queries. For instance the query that gets ran is
SELECT SQL_CALC_FOUND_ROWS 2h7sq1pIz_posts.ID FROM 2h7sq1pIz_posts WHERE 1=1 AND (((2h7sq1pIz_posts.post_title LIKE '%Paint%') OR (2h7sq1pIz_posts.post_excerpt LIKE '%Paint%') OR (2h7sq1pIz_posts.post_content LIKE '%Paint%')) AND ((2h7sq1pIz_posts.post_title LIKE '%number%') OR (2h7sq1pIz_posts.post_excerpt LIKE '%number%') OR (2h7sq1pIz_posts.post_content LIKE '%number%')) AND ((2h7sq1pIz_posts.post_title LIKE '%game%') OR (2h7sq1pIz_posts.post_excerpt LIKE '%game%') OR (2h7sq1pIz_posts.post_content LIKE '%game%'))) AND 2h7sq1pIz_posts.post_type IN ('page', 'post') AND (2h7sq1pIz_posts.post_status = 'publish' OR 2h7sq1pIz_posts.post_status = 'hidden' OR 2h7sq1pIz_posts.post_status = 'expired' OR 2h7sq1pIz_posts.post_status = 'tribe-ea-success' OR 2h7sq1pIz_posts.post_status = 'tribe-ea-failed' OR 2h7sq1pIz_posts.post_status = 'tribe-ea-schedule' OR 2h7sq1pIz_posts.post_status = 'tribe-ea-pending' OR 2h7sq1pIz_posts.post_status = 'tribe-ea-draft' OR 2h7sq1pIz_posts.post_author = 15962 AND 2h7sq1pIz_posts.post_status = 'private') ORDER BY (CASE WHEN 2h7sq1pIz_posts.post_title LIKE '%Paint by number game%' THEN 1 WHEN 2h7sq1pIz_posts.post_title LIKE '%Paint%' AND 2h7sq1pIz_posts.post_title LIKE '%number%' AND 2h7sq1pIz_posts.post_title LIKE '%game%' THEN 2 WHEN 2h7sq1pIz_posts.post_title LIKE '%Paint%' OR 2h7sq1pIz_posts.post_title LIKE '%number%' OR 2h7sq1pIz_posts.post_title LIKE '%game%' THEN 3 WHEN 2h7sq1pIz_posts.post_excerpt LIKE '%Paint by number game%' THEN 4 WHEN 2h7sq1pIz_posts.post_content LIKE '%Paint by number game%' THEN 5 ELSE 6 END), 2h7sq1pIz_posts.post_date DESC LIMIT 0, 10
so imagine that query 10+ times but searching for pa pain paint b paint by nu paint by number paint by numbers in the matter of 5 seconds. Then when you account for multiple people searching on the site at the same time, you can see how the queries could add up quick.
I love the feature for smaller sites that we do, but with larger sites, it would be nice to not have to modify the parent theme, which gets overwritten each upgrade, and to simply have a toggle on the Theme Panel.
I would be interested in this too.
Can this be applied to a child theme? Or upon every update of the theme do we need to replace the images once again?
We were able to change the base coding of the popular posts functionality and limit it to only popular posts that were published in the past 30 days. Of course we could have set that to any time limit, but you’re right … it did require custom coding.
You can see it in action at https://pbn.com
Hi saucemonsters. If you have a block set to sort by most popular, it will pick out the most viewed posts from the past 7 days of traffic … regardless if the actual date of the post is within the last 7 days or is 7 years old. That’s why you can sometimes see posts in those widgets that could be months or even years old. I hope that makes sense. 🙂
I have the Trending Now (News Ticker) block in the header of my home page (https://pbn.com) and a block in the footer of my site that shows popular posts as well. Both are set to sort using Popular (Jetpack + Stats) because we use caching and a CDN.
We also see old stories popping up from time-to-time in both of these blocks. We’re trying to figure out how to limit the Popular sorting option to only display popular posts that have been published in the last 90 days. Haven’t figured that out yet, however.
Catalin, if you have any ideas how we could limit these two block to only show popular posts that have been published in the last 90 day, that would be awesome!
Thanks for the ideas, Chris. The Newspaper theme is already setup with CSS to have the posts be printer-friendly. But the CSS appears to work only on Chrome and appears to be off a bit for Safari / Firefox. Was hoping someone had already encountered and solved this problem. 🙂 But I definitely appreciate you taking the time to respond with some other ideas!
Actually I was able to correct this. It is an error in
includes/wp_booster/td_login.php
Line 100: which is
$key_hash = $wp_hasher->HashPassword( $key );
Needs to be updated to
$key_hash = time() . ':' . $wp_hasher->HashPassword( $key );
After this fix, the password reset links now work properly.
I have this exact same issue. I have no plugins installed except for VC and Newspaper theme. Every time I try resetting password I get
Your password reset link has expired. Please request a new link below.
