WordPress database error Unknown column ‘inclusive_language_score’

Resolved

(@johnccg)

Hi there,

I’ve got in my log a lot of error :

AH01071: Got error 'PHP message: WordPress database error Unknown column 'inclusive_language_score' in 'field list' for query INSERT INTO wp_2_yoast_indexable (object_type, object_id, object_sub_type, permalink, primary_focus_keyword_score, readability_score, inclusive_language_score, is_cornerstone, is_robots_noindex, is_robots_nofollow, is_robots_noimageindex, is_robots_noarchive, is_robots_nosnippet, open_graph_image, open_graph_image_id, open_graph_image_source, open_graph_image_meta, twitter_image, twitter_image_id, twitter_image_source, primary_focus_keyword, canonical, title, description, breadcrumb_title, open_graph_title, open_graph_description, twitter_title, twitter_description, estimated_reading_time_minutes, author_id, post_parent, number_of_pages, post_status, is_protected, is_public, has_public_posts, blog_id, schema_page_type, schema_article_type, object_last_modified, object_published_at, version, permalink_hash...'

Do you know why i have this ?
I already reset Indexable tables & migrations from yoast test helper.

Thanks

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Support Maybellyne
(@maybellyne)

3 years ago

Hello @johnccg

I am sorry about the WordPress database error; I’d expect that resetting the Indexable tables & migrations with the Yoast Test Helper plugin would resolve this. Are you running Yoast SEO v20.8 and WordPress 6.2.2?

Also, I see the table referenced is wp_2_yoast_indexable, but the associated table created by the plugin is called wp_yoast_indexable. Just out of curiosity, did you rename your WP table prefix?

Thread Starter Jonathan
(@johnccg)

3 years ago

Hi !

Thanks for your answer.
I’m runnig Yoast Version 20.8 and WordPress 6.2.2
I didn’t rename the table, i use it in multisite network 🙂

Plugin Support Maybellyne
(@maybellyne)

3 years ago

Thanks for the quick feedback. Can you confirm if you have the Inclusive language analysis turned ON in WordPress > Yoast SEO > Settings > General > Site Features? Does the error occur again if you toggle it ON/OFF while resetting the indexables table and migrations?

Plugin Support Maybellyne
(@maybellyne)

2 years, 12 months ago

This thread was marked resolved due to a lack of activity, but you’re always welcome to re-open the topic. Please read this post before opening a new request.

Thread Starter Jonathan
(@johnccg)

2 years, 12 months ago

Hi,

I’m so sorry for the delay.

No this option isn’t ON.
It says only for English website. Even if i change the language i can’t put it ON.

Plugin Support Maybellyne
(@maybellyne)

2 years, 12 months ago

Thanks for the feedback, @johnccg. We are currently investigating this and will follow up with you soon.

monbauza
(@monbauza)

2 years, 12 months ago

Thanks for the additional information, @johnccg! We tried to reproduce the problem on our test multisite network with a Site Language different than English but unfortunately, we couldn’t. The inclusive_language_score column was created correctly in the _indexable_table after updating Yoast SEO from 20.7 to 20.8.

If for any reason, the inclusive_language_score column wasn’t created, resetting the indexable table via the Yoast Test Helper plugin should recreate it. We know you already tried resetting the indexables but, can you please try again and check if any errors appear in your server error logs immediately after resetting them?

We suspect it may be an issue with database permissions that don’t allow the plugin to create the relevant column in the database table. You may also want to verify with your site hosting provider that your database user has the necessary permissions: ALTER, CREATE, DELETE, INDEX, INSERT, SELECT, UPDATE and DROP. This help article provides additional information.

Let us know if the problem persists.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘WordPress database error Unknown column ‘inclusive_language_score’’ is closed to new replies.