[NSFW] imported items are not displaying

Hi @seattlelion

Thanks for reaching out!

The fact that it has successfully retrieved the latest items but is not displaying on the frontend sounds like a caching issue. Could you please confirm if you’re using a caching plugin? If so, I would suggest clearing your cache and checking if the problem persists.

If clearing the cache doesn’t solve the issue, please kindly send us your system info and debug logs as explained here. If possible, please also send us your RSS feed URL so we can test on our end.

Looking forward to hearing back from you soon.

It isn’t a caching issue. Problem persists over days and Iflushed all caches. The URL I input into the plugin is https://strictjuliespanks.blogspot.cfom I’m getting the latest feeds when I go into the plugin’s list of sources. All settings are vottrvy. Bear in mind that this item displayed perfectly until yesterday. I made no changes anywhere on the site.

Hi @seattlelion

Thank you for getting back to us and providing further details.

I understand that the issue persists despite clearing the cache and verifying the feed settings. Given that the feed URL retrieves the latest items within the plugin but doesn’t display them on the frontend, and considering that no recent changes were made to your site, we’ll need to investigate further.

While it appears not to be a caching issue, troubleshooting steps such as checking your debug logs or your site environment could help pinpoint the cause. If possible, please provide us with your system information and debug logs as mentioned earlier. This will assist us in diagnosing the issue more accurately.

If there are any other specific details or observations you can share about when the display issue began, that would also be helpful for our investigation.

Looking forward to resolving this for you.

i recreated the feed. I went to the site’s latest post (https://strictjuliespanks.blogspot.com. I went to page source and searched for page source. I found the rss feed url (https://strictjuliespanks.blogspot.com/feeds/posts/default?alt=rss ) and deleted the old feed and added a new one with the url. The record was created and I saw a list of posts. However, here is what was in the error log for the feed:

2024-07-29 09:32:02 Info Life, Love, And Spanking Import completed in 0.09 seconds! 2024-07-29 09:38:02 Info Strict Julie Spanked Starting import for “Strict Julie Spanked” 2024-07-29 09:38:03 Error Strict Julie Spanked Failed to save a feed item: Could not insert post into the database. 2024-07-29 09:38:03 Info Strict Julie Spanked Import completed in 0.26 seconds!

Hi @seattlelion

Thanks for getting back to us! Could you please tell us where the feed is supposed to be embedded on the site?

I can see some items under the “Blogs We Like” section in the right sidebar, but it looks like it’s working properly.

That’s what I have been saying from the beginning. The missing blog should appear under “Blogs we Like” on the sidebar. As you can see your pluging displays other blogs. However the one blog won’t display. As I sent you before, the error log shows retrieving the missing item and then says “Error wrtiting database”. I send you this yesterday. Obviously the plugin writes the database for other blogs. Also, I deleted the problem feed source and recreated it. The problem continues to persist.

I’m not sure what happened, but I rebooted my server for a different reason and the missing feed appeared on my sidebar. I have no clue what changed. This was NOT the first reboot since the problem started. The server rebooted on Sunday at midnight. That did NOT fix the problem. Can you investigate further?

Hi @seattlelion

Thanks for getting back to us! Upon careful examination, we found that the issue seems to be caused by the feed providing long excerpts, which WordPress fails to save in the database. An easy solution would be to limit the length of the excerpts. Based on our testing, limiting the excerpt to 10,000 words with the following snippet resolves the issue:

add_filter('wprss_populate_post_data', function (array $data) {
    $maxWords = 10000;
    $data['post_excerpt'] = wp_trim_words($data['post_excerpt'], $maxWords);
    return $data;
});

You can add the code snippet above to your theme’s functions.php file or use this Code Snippet plugin.

Please let us know how it goes.

I added the snippet. The error continues. Only a full reboot of the server seems to temporarily restore it. Same error in the log about not being able to write the item to the database. This feed isnt unusual. I’ve been listing it for over 10 years.

Hi @seattlelion

Thank you for getting back to us! Please allow me some time to check this with our developers.

In the meantime, we appreciate your patience.

Hi @seattlelion

Could you please try lowering the word limit?

You can adjust the code to:

add_filter('wprss_populate_post_data', function (array $data) {
    $maxWords = 5000;
    $data['post_excerpt'] = wp_trim_words($data['post_excerpt'], $maxWords);
    return $data;
});

Please let us know how it goes.

I added the filter and it appears to work. I’ll keep an eye on the list to see if the fix sticks.

Thanks

Hi @seattlelion

Thanks for getting back to us. I’m happy to hear that the filter is working! Please let us know how it goes.

The filter works, but it can be a problem for the site. It is limiting all posts to <5000 words. When we tried 10,000 the fix failed. As far as I know, WordPress has no limit on post size. Is that correct? If so, your “fix” is breaking WordPress if we need to post a long article. Can your developers come up with a fix that doesn’t force all posts to be <5000 words?

Hi @seattlelion

Thank you for your feedback! The issue you’re encountering is due to the feed providing long excerpts, which WordPress struggles to save in the database. The default excerpt length is 55 words, so even though we’ve set the limit to 5000 words in the filter, this shouldn’t normally cause any issues.

To clarify, the filter only affects the excerpt, not the actual post content, so you should still be able to post long articles without any problems.

I hope this clears things up. Please feel free to reach out if you have any further questions.