Lilumi Odi

I completelly dissagree with marking it as “Resolve”.

@devnihil I can make an activity here if you wish: what the status of the bug? Was it fixed? When it will be released to public?

I updated a plugin to a version 16.7 but the issue still exists.
I checked your github and saw that I’m not alone with this problem and there are few opened issues related to this bug.

How often do you want me to ping here to keep this thread active?

@mikes41720 I did SEO data optimization using WP-CLI (took 88 minutes) but error message still exists: KILLED QUERY (1524937 characters long generated in /wp-content/plugins/wordpress-seo/lib/orm.php:286): SELECT * FROM 'wp_yoast_indexable' WHERE 'id' IN ('1', '2', '3', '4', '7', '9'

• This reply was modified 3 years, 4 months ago by Lilumi Odi.

@mazedulislamkhan I waited for the SEO data optimization for 13 hours, but it still didn’t finish and in dev tools XHR response always shows the same values: https://www.dropbox.com/s/624zlz71chxnymz/Screenshot%202021-07-09%20002309.png?dl=0

Meanwhile I received 978 messages about killed query in the last 15 minutes!!!! :
KILLED QUERY (1524917 characters long generated in /wp-content/plugins/wordpress-seo/lib/orm.php:286): SELECT * FROM wp_yoast_indexable WHERE id IN (‘1’, ‘2’, ‘3’, ‘4’, ‘7’, ‘9’, ’12’…

Please make a fix for this!

Yes, I confirm that my server has all the right requirements:
Wordpress 5.7.2
PHP version 7.3
PHP memory 1024M
MySQL 5.7.34-37
Curl 7.58.0
OpenSSL/1.1.1

@maybellyne please look carefully to my request!
Error is with the limit of mysql query!

KILLED QUERY (36545 characters long …

Yoast seo plugin generates a very long SELECT quesry in MySQL and for cases when there are a lot of posts on the site (in my case I have 10000+ posts) it causes a crash.

This query should be split into chunks!

• This reply was modified 3 years, 4 months ago by Lilumi Odi.

It’s very useful plugin. thank you.

One thing – please change 179 line in versions.php to

$html = str_get_html($buffer, true, true, 'UTF-8', false);

It will preserve line breaks.

Thank you earnjam!

Thank you for the good news.
Please share these changes on gist.github.com or elsewhere.

I have this issue too.
In my research I found that plugin updates option “ep_exclude_pages” with revision id not the true post id.

I have the same problem – image does not inserts.

wp 3.2.1