Lots of db errors after upgrading to v9.11 – “Specified key was too long”

  • Resolved Kim Hornung

    (@keepmovingdk)


    4 months, 1 week ago

    After upgrading a site to v9.11 I see lots of these errors in the log file (with WP_DEBUG and WP_DEBUG_LOG enabled):

    WordPress database error Specified key was too long; max key length is 1000 bytes for query ALTER TABLE fk_WP_SEO_Redirection CHANGE redirect_from redirect_from VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;

    You can also see the error if you install the Query Monitor plugin.

    This happens because you’ve changed the SQL that creates the database table to use VARCHAR(191) for redirect_from, but you haven’t changed the SQL that updates the table. It still uses VARCHAR(255).

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Adam Salah

    (@adam1318)

    Hello @keepmovingdk,

    Thank you for your patience.

    We’re pleased to inform you that we’ve resolved the issue you reported in the plugin and have released a new update, version 9.12.

    To access the improvements, please upgrade to the latest version. We would greatly appreciate any feedback you can provide after updating.

    Thank you for your patience and have a wonderful day!

    Best regards,

    Thread Starter Kim Hornung

    (@keepmovingdk)

    Thanks! I can confirm that I no longer see the problem after upgrading to the newest version.

    /Kim

    Plugin Contributor Adam Salah

    (@adam1318)

    Hi Kim, @keepmovingdk

    Thank you for confirming! We’re glad to hear that.

    Thank you and have a great day!

    Best regards,


    Adam

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.