Database error – Unknown column version in field list

  • Resolved Christoph Jaenisch

    (@campaz)


    4 years, 6 months ago

    Hi,
    I am getting errors on each page, here is one of these errors:

    WordPress-Datenbank-Fehler: [Unknown column ‘version’ in ‘field list’]
    UPDATE wp_yoast_indexable SET object_id = ‘1’, object_type = ‘user’, permalink = ‘domain.de/author/whispertante/’, title = NULL, description = NULL, is_cornerstone = ‘0’, is_robots_noindex = ‘0’, is_robots_nofollow = NULL, is_robots_noarchive = NULL, is_robots_noimageindex = NULL, is_robots_nosnippet = NULL, is_public = NULL, has_public_posts = NULL, blog_id = ‘1’, open_graph_image = ‘https://secure.gravatar.com/avatar/227c6d64fcf1c1f2155a7f5cadb95fb3?s=500&d=mm&r=g’, open_graph_image_id = NULL, open_graph_image_source = ‘gravatar-image’, open_graph_image_meta = NULL, twitter_image = ‘https://secure.gravatar.com/avatar/227c6d64fcf1c1f2155a7f5cadb95fb3?s=500&d=mm&r=g’, twitter_image_id = NULL, twitter_image_source = ‘gravatar-image’, version = ‘1’, permalink_hash = ’72:e2d15385a9b73fc56498006f614a667a’, updated_at = ‘2021-10-28 07:57:14’ WHERE id = ‘1’`

    After I added a column “version” in the database it works.
    I am using the most current version (17.4), downgrading to 17.3 did not solve the issue.

    Best regards,
    Christoph

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter Christoph Jaenisch

    (@campaz)

    4 years, 6 months ago

    Some more info:
    I tried the same fix I did on our test system (which worked) in the prod system. But I am getting this error:
    ALTER TABLE wp_yoast_indexable ADD version VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NULL AFTER estimated_reading_time_minutes;
    MySQL meldet: Dokumentation
    #1118 – Zeilenlänge zu groß. Die maximale Zeilenlänge für den verwendeten Tabellentyp (ohne BLOB-Felder) beträgt 8126. Einige Felder müssen in BLOB oder TEXT umgewandelt werden

    In English:
    #1118 – Length of line is too big. The maximum length of lines for this table type (without BLOB fields) is 8126. Some fields has to be converted to BLOB or TEXT.

    The difference between the table in our test system (which I set up as 1:1 copy yesterday) and our prod system is the format of the table. It is “dynamic” for the table in our test system, but “compact” for the table in the prod system.

    Plugin Support Maybellyne

    (@maybellyne)

    4 years, 6 months ago

    Hello Christoph,

    We are sorry about the database error you are experiencing. Can you please try resetting the 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. Locate the Yoast SEO section and click on the ‘Reset indexables tables & migrations’, ‘Reset Prominent words calculation’, and ‘Reset Internal link counter’ buttons. After each click, the page will reload to confirm that each reset was successful. Note: this won’t actually erase your SEO data, which is also stored in WordPress’ default tables. It’ll just reset our index (custom tables) for that data.
    4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your content.

    Could you then check if you aren’t experiencing these errors anymore?

    Thread Starter Christoph Jaenisch

    (@campaz)

    4 years, 6 months ago

    Thanks for your quick reply.
    It works now, although the optimization returned an error. But the other error(s) are now gone.
    Best regards,
    Christoph

    Plugin Support Maybellyne

    (@maybellyne)

    4 years, 6 months ago

    Thanks for the feedback, Christoph.

    Can you share the error received during the SEO data optimization?

    Looking forward to hearing from you.

    rsanchez1123

    (@rsanchez1123)

    4 years, 6 months ago

    Hello, I have this problem too. After trying the Yoast Test Helper Plugin, now I have a problem where it won’t regenerate the wp_yoast_indexable table and leads to errors on my website. Is there a way to fix this?

    Plugin Support Michael Tiña

    (@mikes41720)

    4 years, 6 months ago

    Hi @rsanchez1123

    We are sorry you’re having a similar issue. Please open a new request. That way it’s easier to track issues and provide assistance. Thanks!

    devnihil

    (@devnihil)

    4 years, 5 months ago

    We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.

    Laxman Bhattarai

    (@laxmann)

    4 years, 5 months ago

    Hello, I also had the same problem here and solved it as per Maybellyne
    (@maybellyne). Thanks very much Yoast SEO Team.

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

The topic ‘Database error – Unknown column version in field list’ is closed to new replies.