Rafael Fischmann

Hi @epsiloncool, so I’ve updated to 1.71.238 today and now am seeing lots of these in my PHP error log:

[28-Jul-2024 09:30:57 UTC] WordPress database error Table 'wordpress.wpftsi_doctree' doesn't exist for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "128390")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "128390"))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[28-Jul-2024 09:30:57 UTC] WordPress database error Table 'wordpress.wpftsi_doctree' doesn't exist for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID, wpftsi_t.relev 
					 FROM wp_posts 
				inner join ( 
					select 
						fi.tid, 
						t_end.relev 
					from wpftsi_index fi 
					straight_join ( 				
				SELECT 
					tbase.index_id,
					sum(
						(
							if(tbase.n < 1,0,trel.pow + (trel.res / LOG(tbase.n + 1)) / 1) 
						+ if(isnull(t3.id) or (t3.n < 1),0, (
									t3.pow + (t3.res / LOG(t3.n + 1)) / 1
								) *  (case tbase.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) / (17))
						) *  (case tbase.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) / (17)
					) relev
			FROM 
				wpftsi_tp trel
			STRAIGHT_JOIN 
				wpftsi_docs tbase
				ON (trel.did = tbase.id)
			STRAIGHT_JOIN 
				wpftsi_index tindex
				ON tindex.id = tbase.index_id
			LEFT JOIN (
				SELECT 
					dt.p_tid,
					dt.p_tsrc,
					dt.p_token,
					t2.id,
					t2.token AS token2,
					t2.n AS n2,
					t2.index_id AS index_id2,
					t2.pow,
					t2.res,
					t2.n
				FROM 
					wpftsi_doctree AS dt
				STRAIGHT_JOIN (
					SELECT 
						tbase.id,
						tbase.n,
						trel.did,
						trel.res,
						trel.pow,
						tindex.tid,
						tindex.tsrc,
						tindex.id AS index_id,
						tbase.token
					FROM 
						wpftsi_tp trel
					STRAIGHT_JOIN 
						wpftsi_docs AS tbase
						ON (trel.did = tbase.id)
					STRAIGHT_JOIN 
						wpftsi_index AS tindex
						ON tindex.id = tbase.index_id
						where 1  and (trel.q_id = "128390")
				) AS t2 
				ON t2.tid = dt.c_tid AND t2.tsrc = dt.c_tsrc AND t2.token = dt.c_token
			) AS t3 
			ON tindex.tid = t3.p_tid AND tindex.tsrc = t3.p_tsrc AND tbase.token = t3.p_token
			where 1  and (trel.q_id = "128390")
				group by tbase.index_id
				ORDER BY NULL
			) t_end 
			on t_end.index_id = fi.id 
		order by null
	) wpftsi_t 
		on wpftsi_t.tid = wp_posts.ID 
				 
					 WHERE 1=1  and (((1))) and (wpftsi_t.relev > 0) AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
					 
					 ORDER BY  (wpftsi_t.relev) DESC, 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, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, WPFTS_Search->index_posts_pre_query, WPFTS_DB->get_results
[28-Jul-2024 09:30:57 UTC] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/macmagazine/public_html/wp-content/themes/caards-child/functions/itunes_live_tile.php:294) in /home/macmagazine/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831
[28-Jul-2024 09:30:59 UTC] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/macmagazine/public_html/wp-content/themes/caards-child/functions/itunes_live_tile.php:393) in /home/macmagazine/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831
[28-Jul-2024 09:31:01 UTC] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/macmagazine/public_html/wp-content/themes/caards-child/functions/itunes_live_tile.php:294) in /home/macmagazine/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831
[28-Jul-2024 09:31:06 UTC] WordPress database error Table 'wordpress.wpftsi_doctree' doesn't exist for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "128391")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "128391"))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[28-Jul-2024 09:31:06 UTC] WordPress database error Table 'wordpress.wpftsi_doctree' doesn't exist for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID, wpftsi_t.relev 
					 FROM wp_posts 
				inner join ( 
					select 
						fi.tid, 
						t_end.relev 
					from wpftsi_index fi 
					straight_join ( 				
				SELECT 
					tbase.index_id,
					sum(
						(
							if(tbase.n < 1,0,trel.pow + (trel.res / LOG(tbase.n + 1)) / 1305.5032653379349) 
						+ if(isnull(t3.id) or (t3.n < 1),0, (
									t3.pow + (t3.res / LOG(t3.n + 1)) / 1305.5032653379349
								) *  (case tbase.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) / (5))
						) *  (case tbase.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) / (5)
					) relev
			FROM 
				wpftsi_tp trel
			STRAIGHT_JOIN 
				wpftsi_docs tbase
				ON (trel.did = tbase.id)
			STRAIGHT_JOIN 
				wpftsi_index tindex
				ON tindex.id = tbase.index_id
			LEFT JOIN (
				SELECT 
					dt.p_tid,
					dt.p_tsrc,
					dt.p_token,
					t2.id,
					t2.token AS token2,
					t2.n AS n2,
					t2.index_id AS index_id2,
					t2.pow,
					t2.res,
					t2.n
				FROM 
					wpftsi_doctree AS dt
				STRAIGHT_JOIN (
					SELECT 
						tbase.id,
						tbase.n,
						trel.did,
						trel.res,
						trel.pow,
						tindex.tid,
						tindex.tsrc,
						tindex.id AS index_id,
						tbase.token
					FROM 
						wpftsi_tp trel
					STRAIGHT_JOIN 
						wpftsi_docs AS tbase
						ON (trel.did = tbase.id)
					STRAIGHT_JOIN 
						wpftsi_index AS tindex
						ON tindex.id = tbase.index_id
						where 1  and (trel.q_id = "128391")
				) AS t2 
				ON t2.tid = dt.c_tid AND t2.tsrc = dt.c_tsrc AND t2.token = dt.c_token
			) AS t3 
			ON tindex.tid = t3.p_tid AND tindex.tsrc = t3.p_tsrc AND tbase.token = t3.p_token
			where 1  and (trel.q_id = "128391")
				group by tbase.index_id
				ORDER BY NULL
			) t_end 
			on t_end.index_id = fi.id 
		order by null
	) wpftsi_t 
		on wpftsi_t.tid = wp_posts.ID 
				 
					 WHERE 1=1  and (((1))) and (wpftsi_t.relev > 0) AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
					 
					 ORDER BY  (wpftsi_t.relev) DESC, 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, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, WPFTS_Search->index_posts_pre_query, WPFTS_DB->get_results

What should I do, please?

Yeah, I’m seeing tons of these when enabling debug in WordPress:

[13-Jul-2024 10:26:32 UTC] PHP Deprecated:  Creation of dynamic property SCHEMA_JSON_LD_Breadcrumbs::$post is deprecated in /home/macmagazine/public_html/wp-content/plugins/schema/includes/extensions/breadcrumbs.php on line 67
[13-Jul-2024 10:26:32 UTC] PHP Deprecated:  Creation of dynamic property SCHEMA_JSON_LD_Breadcrumbs::$show_on_front is deprecated in /home/macmagazine/public_html/wp-content/plugins/schema/includes/extensions/breadcrumbs.php on line 68
[13-Jul-2024 10:26:32 UTC] PHP Deprecated:  Creation of dynamic property SCHEMA_JSON_LD_Breadcrumbs::$page_for_posts is deprecated in /home/macmagazine/public_html/wp-content/plugins/schema/includes/extensions/breadcrumbs.php on line 69

But it does seem this plugin has been abandoned? ??

Thank you, got it.

So, coincidentally, I’ve just received a new alert from cPanel and that same list is still there for your plugin. Here you go: https://app.sparkmailapp.com/web-share/IO1sjj7OrYQXujud_rsXpZVuwbr5IsSGV6QaV0-E

I have no idea why are they listing all those vulnerabilities for your plugin, nor where does that come from. Maybe you should try to get in touch with their Imunify360 Security Team and sort this out…

@tillkruess I’ve since deleted that cPanel email and haven’t received any new alerts from it, which means it might have been a mistake on their part. Sorry for the unnecessary annoyance.

Thanks a lot, @firelightwp! I really appreciate it. ??

Ok!

Thanks a lot for getting back to me so quickly about this, @firelightwp!

I do like the approach to “bring the plugin into the modern block era”, as you said, but that ought to be optional, yes.

You could either let us disable it from the plugin’s settings or via WordPress’ own customize screen for all the blocks that appear inside the editor.

And yes, remembering the open/close status would be good as well!

Lastly, I myself didn’t like the orange accent next to its block. No other blocks from my editor have any color.

@wp_media Is that helper plugin still necessary today?

Thanks, @wp_media. I’ve already deleted the images I wanted after temporarily disabling Imagify, so I’ll wait for an official/stable update with the fix.

That worked, @epsiloncool! We’re almost there. ??

However, the excerpts are very short as you can see in this example: https://macmagazine.com.br/?s=adobe+photoshop

I’ve already changed from 300 to 2000, here, but it didn’t make any difference: https://d.pr/i/hwUslQ

Any idea why? Thank you!

It seems the same to me. The previous screenshot was from this query: https://macmagazine.com.br/?s=apple+computer

As per your instructions, I duplicated Caards’ /template-parts/archive/content.php file to my child’s folder and edited this part: https://d.pr/i/3GFkPa

Nope, there’s isn’t any tag for bold in the excerpts: https://d.pr/i/oJ3K4k

That does seem to work, thanks a lot @epsiloncool! https://d.pr/i/sreaOA

It just doesn’t make the search terms bold. Is that also something from our theme itself?

Hum, just ran a quick test with it and there is some HTML code showing up, don’t know why: https://d.pr/i/5EjLah