xaja

yes, confirm this bugs

YES!

now works, and performance is very good!

thanks!

you will do an update like 3.5.1?

Unfortunately, this code dont solve problem (
posts from POSTS still not in search

here new query with this edits:
SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta AS a ON (a.post_id = wp_posts.ID) INNER JOIN wp_postmeta AS b ON ((b.meta_id = a.meta_id + @@auto_increment_increment) AND (b.post_id = wp_posts.ID)) INNER JOIN wp_posts AS c ON ((c.post_name = b.meta_value) AND (c.post_type = 'acf-field') AND ((c.post_content LIKE '%:"text"%') OR (c.post_content LIKE '%:"textarea"%') OR (c.post_content LIKE '%:"wysiwyg"%'))) WHERE 1=1 AND (((b.meta_key LIKE CONCAT('\_', a.meta_key)) AND (a.meta_value LIKE '%search%')) OR ((wp_posts.post_title LIKE '%search%') OR (wp_posts.post_content LIKE '%search%') OR (wp_posts.post_excerpt LIKE '%search%'))) AND wp_posts.post_type IN ('post', 'page', 'attachment', 'products') AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') ORDER BY wp_posts.post_date DESC LIMIT 0, 10

domain.ltd/?s=search

3.4.2 (all working)
SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta AS a ON (a.post_id = wp_posts.ID) INNER JOIN wp_postmeta AS b ON ((b.meta_id = a.meta_id + @@auto_increment_increment) AND (b.post_id = wp_posts.ID)) INNER JOIN wp_posts AS c ON ((c.post_type = ‘acf-field’) AND ((c.post_content LIKE ‘%:”text”%’) OR (c.post_content LIKE ‘%:”textarea”%’) OR (c.post_content LIKE ‘%:”wysiwyg”%’))) WHERE 1=1 AND (((c.post_name = b.meta_value) AND (a.meta_value LIKE ‘%search%’)) OR ((wp_posts.post_title LIKE ‘%search%’) OR (wp_posts.post_content LIKE ‘%search%’) OR (wp_posts.post_excerpt LIKE ‘%search%’))) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘products’) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_author = 1 AND wp_posts.post_status = ‘private’) ORDER BY wp_posts.post_date DESC LIMIT 0, 10

3.5 (no results from POST post_type)
SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta AS a ON (a.post_id = wp_posts.ID) INNER JOIN wp_postmeta AS b ON ((b.meta_id = a.meta_id + @@auto_increment_increment) AND (b.meta_key LIKE CONCAT(‘\_’, a.meta_key))) INNER JOIN wp_posts AS c ON ((c.post_name = b.meta_value) AND (c.post_type = ‘acf-field’) AND ((c.post_content LIKE ‘%:”text”%’) OR (c.post_content LIKE ‘%:”textarea”%’) OR (c.post_content LIKE ‘%:”wysiwyg”%’))) WHERE 1=1 AND ((a.meta_value LIKE ‘%search%’) OR ((wp_posts.post_title LIKE ‘%search%’) OR (wp_posts.post_content LIKE ‘%search%’) OR (wp_posts.post_excerpt LIKE ‘%search%’))) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘products’) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_author = 1 AND wp_posts.post_status = ‘private’) ORDER BY wp_posts.post_date DESC LIMIT 0, 10

if you want, i can give you access to ftp and database in private.
or i just wait another person with this bug )

p.s. 3.5 is REALLY faster, thank you!

same bug!