kaplunkiigirl

Yep, I’ve got a dev version of my site that I can test things on, so let me know when you’ve got something for me to try.

One things I notice is that the list of posts is different, and the total count is also different.

I’ve run the query against my database, but I’m not sure what results you want me to share.

With nothing in “Exclude Categories” and exclude_categories=”96″ in my shortcode,
[tptn_list limit="6" heading="0" exclude_categories="96"]

this caller:
get_tptn_pop_posts()+

runs this query:

SELECT ID, postnumber, post_title, post_type, post_content, post_date, post_author, SUM(cntaccess) as sumCount
FROM wp_top_ten_daily
INNER JOIN wp_posts
ON postnumber=ID
WHERE 1=1
AND blog_id = 1
AND wp_posts.post_status = 'publish'
AND dp_date >= '2015-08-24 0'
AND wp_posts.post_type IN ('post', 'page', 'attachment')
GROUP BY postnumber
ORDER BY sumCount DESC
LIMIT 20

If I add ‘adventures’ to “Exclude Categories” and take it out of the shortcode, this is what runs:

SELECT ID, postnumber, post_title, post_type, post_content, post_date, post_author, SUM(cntaccess) as sumCount
FROM wp_top_ten_daily
INNER JOIN wp_posts
ON postnumber=ID
INNER JOIN wp_term_relationships AS excat_tr
ON (wp_posts.ID = excat_tr.object_id)
INNER JOIN wp_term_taxonomy AS excat_tt
ON (excat_tr.term_taxonomy_id = excat_tt.term_taxonomy_id)
WHERE 1=1
AND blog_id = 1
AND wp_posts.post_status = 'publish'
AND dp_date >= '2015-08-24 0'
AND wp_posts.post_type IN ('post', 'page', 'attachment')
AND wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (106) )
GROUP BY postnumber
ORDER BY sumCount DESC
LIMIT 20

Is that what you wanted to see? If not let me know which query and which caller you want me to share.

If I remove ‘adventures’ from the “Exclude Categories” field then it correctly shows 6 posts (of all types) via both the shortcode and the widget.

If I add exclude_categories=”96″ (for ‘adventures’) to the shortcode, it correctly displays 6 recipe-only posts, so that makes it work as it should.

However, the widget in the right-hand sidebar is now displaying non-recipe posts. I’ve reduced the number to “4” so it doesn’t list the home page as “one of my top posts”.

So we’re definitely getting closer, thank you.

What do you want me to try next?

OK, so the shortcode on the home page is:
[tptn_list limit="6" heading="0"]

and the entire contents of the “Exclude Categories” field in the settings is:
adventures

You can see the results of these settings on the home page of my site here
https://www.eatingvibrantly.com/

Yes, I just updated to 2.2.3 and I’m still seeing the problem.

I tried using both of the “merge” options in the reset section to no effect. I’d rather not have to reset the plugin fully if it means I lose my counts.

Is there anything else I can try?

Thank you.

Hi WebberZone,

I resaved my settings, and the non-recipe posts disappeared from the lists, so that issue seems to be fixed, thank you.

However, the number of posts being shown by the shortcode dropped to 2 (having dropped one non-recipe post), despite being set to limit=”5″.

I increased it to 6, to get it to display 3 posts on the front page.

Is this connected, or is it a separate problem? And any ideas on how to fix it?

Thanks,

Nikki

Hi Nadia,

Sorry I haven’t had a chance to provide you with access to a broken install, but I just updated to 2.0.4.3 and my library is no longer blank.

Thanks,

-Nikki

Hi Nadia,

I have the same problem also. I’m using WP 4.1.1, my theme is Dynamik Website Builder + Genesis, and the plugins that I have the same as Marko are:

Block Bad Queries 20150314 (same problem before I upgraded from the previous version too)
List category posts 0.56

I deactivated both of those plugins individually, and the library was still blank. I also turned off my caching plugin, with no effect on the library.

The strange thing is that I have a duplicate of my site at a dev location, which is identical to my production site (other than the URL), and it’s not showing a blank library screen. However, I did just discover that my production site is running MySQL 5.5.29, while the dev one is running MySQL 5.1.61, so that might be relevant.

Let me know if there’s anything else I can do to help. I will downgrade to 2.0.3 and see if that helps for now.

Thanks,

Nikki

Hi Emre,

I couldn’t find a solution to this one. I thought it might have been my anti-comment-spam plugins, but even with all of them deactivated, the problem still occurred, just after a longer delay.

I did some more digging, and I have a suspicion that it may have something to do with the way that my server handles the cached file request. I read somewhere that FastCGI, which my host uses, can be a bit fussy about file paths. But I can’t be sure that’s the problem, because I don’t understand enough about how my server and your plugin are interacting.

Unfortunately I’ve had no option but to stop using WP Fastest Cache, as much as I love it, because I can’t afford to keep blocking my blog visitors from posting comments. I’ve switched to Quick Cache, and that seems to be working fine for me.

Sorry we couldn’t sort this one out. Let me know if you ever figure out how to fix it.

Thanks for your help,

Nikki

Thank you ??

Thank you ??

OK, so I can’t fix it without turning off the caching altogether – none of the other settings prevented it from happening.

I also cleared out my .htaccess file entirely, leaving just the base WordPress permalink rules (plus the WP Fastest Cache rules), and the problem still occurred, so I don’t think it’s a clash with my other .htaccess rules.

It appears that I have to wait 20 minutes before the problem presents itself – any time before that I am able to submit comments successfully – and I personally don’t see the problem at all if I have the “Don’t show the cached version for logged-in users” option checked, as if it’s counting me as logged in (when I am not – I always use a different browser for testing, that I’m not logged into) because I’ve recently submitted a comment? Not sure about this one.

I also took an exact clone of my site across to a development domain, and I can’t get the problem to recur there (yet), so I’m thinking it might be something to do with the www redirect, but I could be barking up the wrong tree. But it’s only happening on my live site unfortunately. What a frustratingly odd bug this is!

I’m not sure what else to test, but I’m bummed that I’ve had to turn of the caching on my live site, which has taken my response time from 400-500ms up to 1200+ms ??

Any thoughts as to where to from here?

Thanks,

Nikki

Hi Emre,

I’m having the same issue on one of my sites, and I do think that your plugin is connected to the problem, because I can temporarily fix the issue just by deleting the plugin cache.

This is the site that’s having the problem:
https://www.eatingvibrantly.com/

Unfortunately it’s transient, I can’t figure out how to reproduce it, but it keeps recurring after a period of time. At the moment, I just keep submitting test comments at regular intervals, and I’m slowly unchecking features one at a time to see if I can figure out what’s causing it because I do NOT want to turn off your plugin.

When I went searching on Google, most things I found said it was either a problem in the .htaccess file or a permissions issue on the wp-comments-post.php file.

I completely deleted your plugin and the cache directory and reinstalled it, and the problem recurred.

I’d love your thoughts on this one.

Thanks,

Nikki