John

Thanks but this sounds quite complicated and don’t well understand why all those checks would be needed on a healthy installation.

Anyhow, I don’t think such checks are really relevant as this cron is for every 5 minutes and I only get 5-6 such errors/day – so, obviously, all others have worked. If there were such issues as those you suggest none of those cron would work.

I also get several of those every single day on a couple of live sites:

Cron reschedule event error for hook: rsssl_every_five_minutes_hook, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {"schedule":"rsssl_five_minutes","args":[],"interval":300}

Is there a way to solve this please?

Thanks, but yes I did search the DB. Problem is those errors still continue daily!
I’m just asking your thoughts about this, not a solution, so that I can move to the right direction for solving the issue.

Sorry, no. I’m not a dev and I’m not using their plugin nor do I use yours at the time.
I really cannot see any reason why you cannot discuss this together with them…
I think I’ve done my part already. Thanks.

Yeah, I know this as their plugin was working fine until a couple of months ago and then they update it with a minimum requirement of PHP 8.0 and this is not the case with those 2 sites. So I don’t think this is a real solution, sorry.

If your plugin doesn’t work with Bunny CDN you should simply notify your users about that. And, some of them, will simply switch to another caching plugin, as I did, instead of installing yet another plugin that, moreover, is limiting its usage to PHP 8.0.
(Please don’t tell me that PHP 8 is better and more secure than 7.4 as this is not really the point here.)

Just checked and there is not a single one in there…
That’s why I find those errors very strange and that they maybe hide another problem.

Many thanks for your feedback.
This is also what I thought but there is nothing with those values at the site and I really scanned thoroughly, including the DB.
Just last question if you don’t mind: could this indicate an intrusion attempt of some sort?

Yep, you are right, my answer was not clear.

I have an account at Bunny CDN with several sites and most of them are using WP Fastest Cache where I simply add “mysite.b-cdn.net” and then it works – meaning that when I check the URL of any random image of the site I get this same https:/mysite.b-cdn.net/…/image.jpg

For 2 different sites I wanted to switch from WPFC to Super Cache for different reasons not relating to the CDN and then tried to connect to my CDN accounts by testing differing leading strings and no ending slash. None of them worked – meaning that I never succeeded in getting Bunny’s URL for loading images and was still getting the usual https://mysite.com/… This is what I call “not working”.

I then switched to W3 Total Cache for those sites and they connect to Bunny CDN by using my account’s key and found this much more straight forward than messing with leading or ending characters whatsoever. But again, the problem here was that I really didn’t find any sort of way to connect and load images from my CDN account at Bunny.

Thanks for your interest.

Thanks’, will do, no problem.

Thanks, will do that but was also wondering whether those portions like this one that contain spammy texts and chinese characters (that are nowhere to be found at the site) indicate another problem or if this is only due to collations?

FROM wp_rank_math_redirections WHERE status = ‘active’ AND ( sources like ‘%a:2:{s:7:”pattern”;s:75:”?s=??k8seo.com??谷歌官方seo外推-谷歌外推工具下载官网281″;s:10:”comparison”;s:5:”exact”;}%’ or sources like ‘%?s=??k8seo%’ or sources like ‘%com??谷歌官方seo外推%’ or sources like ‘%谷歌外推工具下载官网281%’ ) ORDER BY updated DESC made by require(‘wp-blog-header.php’),

Many thanks Marko for your help.
I see what you mean and I’ll do that for sure.

Nevertheless, I see that several portions of those errors reference spammy links and Chinese characters that are nowhere to be found at my site (thoughly scanned), like those:

WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%??k8seo.com??谷歌官方seo外推-谷歌外推工具下载官网281%’) OR (wp_posts.post_excerpt LIKE ‘%??k8seo.com??谷歌官方seo外推-谷歌外推工具下载官网281%’) OR (wp_posts.post_content LIKE ‘%??k8seo.com??谷歌官方seo外推-谷歌外推工具下载官网281%’))) AND

and those:

FROM wp_rank_math_redirections WHERE status = ‘active’ AND ( sources like ‘%a:2:{s:7:”pattern”;s:75:”?s=??k8seo.com??谷歌官方seo外推-谷歌外推工具下载官网281″;s:10:”comparison”;s:5:”exact”;}%’ or sources like ‘%?s=??k8seo%’ or sources like ‘%com??谷歌官方seo外推%’ or sources like ‘%谷歌外推工具下载官网281%’ ) ORDER BY updated DESC made by require(‘wp-blog-header.php’),

Are those something to be further investigated or do they sound like to only relate to “collations” that you mention?

Thanks again.

Helllo,

I got the same but, problem is, together with those errors I got some of those that I don’t well understand but I see they mention /portfolio/ and wondering whether they relate:

[12-May-2024 19:40:35 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like' for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts 
					 WHERE 1=1  AND (((wp_posts.post_title LIKE '%[tpsuc.com]cpu%') OR (wp_posts.post_excerpt LIKE '%[tpsuc.com]cpu%') OR (wp_posts.post_content LIKE '%[tpsuc.com]cpu%')) AND ((wp_posts.post_title LIKE '%slot??offline%') OR (wp_posts.post_excerpt LIKE '%slot??offline%') OR (wp_posts.post_content LIKE '%slot??offline%')) AND ((wp_posts.post_title LIKE '%slot%') OR (wp_posts.post_excerpt LIKE '%slot%') OR (wp_posts.post_content LIKE '%slot%')) AND ((wp_posts.post_title LIKE '%games??945%') OR (wp_posts.post_excerpt LIKE '%games??945%') OR (wp_posts.post_content LIKE '%games??945%')))  AND (wp_posts.post_password = '')  AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'portfolio' AND (wp_posts.post_status = 'publish')))
					 
					 ORDER BY (CASE WHEN wp_posts.post_title LIKE '%[tpsuc.com]cpu slot??offline slot games??945%' THEN 1 WHEN wp_posts.post_title LIKE '%[tpsuc.com]cpu%' AND wp_posts.post_title LIKE '%slot??offline%' AND wp_posts.post_title LIKE '%slot%' AND wp_posts.post_title LIKE '%games??945%' THEN 2 WHEN wp_posts.post_title LIKE '%[tpsuc.com]cpu%' OR wp_posts.post_title LIKE '%slot??offline%' OR wp_posts.post_title LIKE '%slot%' OR wp_posts.post_title LIKE '%games??945%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%[tpsuc.com]cpu slot??offline slot games??945%' THEN 4 WHEN wp_posts.post_content LIKE '%[tpsuc.com]cpu slot??offline slot games??945%' THEN 5 ELSE 6 END), wp_posts.post_date DESC
					 LIMIT 0, 20 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
[12-May-2024 19:40:35 UTC] WordPress database error Illegal mix of collations (utf8mb4_bin,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like' for query SELECT * FROM wp_rank_math_redirections WHERE status = 'active' AND ( sources like '%a:2:{s:7:\"pattern\";s:51:\"?s=[tpsuc.com]cpu slot??offline slot games??945\";s:10:\"comparison\";s:5:\"exact\";}%' or sources like '%?s=[tpsuc%' or sources like '%com]cpu slot??offline slot games??945%' ) ORDER BY updated DESC made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Redirections\Redirections->do_redirection, RankMath\Redirections\Redirector->__construct, RankMath\Redirections\Redirector->flow, RankMath\Redirections\Redirector->everything, RankMath\Redirections\DB::match_redirections, RankMath\Admin\Database\Query_Builder->get, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query

Thanks for this but I already tried several variations, including this one, but none of them worked – while all other caching plugins that I tested are working simply by adding “mysite.b-cdn.net”. So I already switched for another one but would really curious to know how to get this up and running for next time.

Many thanks for your feedback.
There is no other optimization plugin active.
I didn’t know you have a support link via the plugin, that’s great!

Thanks, but we are not using woocommerce.
We are only interested in the checkout for a donations page for an NGO.