PHP error related to database table wp_yoast_indexable

  • Resolved e10klukas

    (@e10klukas)


    4 years, 7 months ago

    Our php error log is being hammered with the following error:

    WordPress database error Unknown column 'version' in 'field list' for query UPDATE 'wp_yoast_indexable' SET 'object_id' = '89', 'object_type' = 'user', 'permalink' =...

    The error goes on for a bit but I think this is the important part, I can post the entire error if needed.

    The ‘version’ column is indeed missing from the ‘wp_yoast_indexable’ table. I was looking at the Yoast Test Helper plugin but was hesitant to use the ‘Reset indexables tables and migrations’ option. Can you confirm this will not remove/replace data on the website and whether or not it will actually fix the issue?

    One additional detail, I did try to manually create the ‘version’ column but I got a “Row size too large (> 8126)” error. I have a feeling this is why the column might not have been created to begin with and may again prevent the column from being created when using the fix above. Any other thoughts on how I can fix this.

    Thanks.
    Lukas

Viewing 2 replies - 1 through 2 (of 2 total)
  • Suwash Kunwar

    (@suascat_wp)

    4 years, 7 months ago

    @e10klukas

    In version 17.3, we added a feature of ‘versioning’ our indexables in the Yoast database tables. Looking at the errors you are getting, it looks like the columns this needs in the tables were not generated in your database. The workaround this is by resetting our indexables in the database tables by following the steps below?
    1. Install & activate the Yoast Test Helper plugin
    2. Go to Tools > Yoast Test
    3. Hit the “Reset indexables & migrations” button.
    4. Go to SEO > Tools, and under SEO data, click the “SEO Data Optimization” button to allow Yoast to rescan your pages.

    It will not remove or replace SEO data on your website.

    Thread Starter e10klukas

    (@e10klukas)

    4 years, 7 months ago

    Hello Suwash –

    Thank you for the reply, that worked, thank you for your time.

    Lukas

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

The topic ‘PHP error related to database table wp_yoast_indexable’ is closed to new replies.