Update 14.0: Column not found: 1054 Unknown column ‘blog_id’ in ‘field list’

  • Resolved Philip Faster

    (@philipfaster)


    4 years, 7 months ago

    The new update v14.0 makes my site can’t show any page content (Front end), and can’t edit any post (Admin).

    WordPress version 5.4
    Current theme: WPEX GoPress (version 2.0.0)
    Current plugin: Yoast SEO (version 14.0)
    PHP version 7.2.29

    Error Details
    =============
    An error of type E_ERROR was caused in line 464 of the file /home/[my website folder]/wp-content/plugins/wordpress-seo/vendor_prefixed/j4mie/idiorm/idiorm.php. Error message: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘blog_id’ in ‘field list’ in /home/[my website folder]/wp-content/plugins/wordpress-seo/vendor_prefixed/j4mie/idiorm/idiorm.php:464
    Stack trace:
    #0 /home/[my website folder]/wp-content/plugins/wordpress-seo/vendor_prefixed/j4mie/idiorm/idiorm.php(464): PDOStatement->execute()
    #1 /home/[my website folder]/wp-content/plugins/wordpress-seo/vendor_prefixed/j4mie/idiorm/idiorm.php(1983): YoastSEO_Vendor\ORM::_execute(‘INSERT INTO `wp…’, Array, ‘default’)
    #2 /home/[my website folder]/wp-content/plugins/wordpress-seo/src/orm/yoast-model.php(662): YoastSEO_Vendor\ORM->save()
    #3 /home/[my website folder]/wp-content/plugins/wordpress-seo/src/models/indexable.php(160): Yoast\WP\SEO\ORM\Yoast_Model->save()
    #4 /home/[my website folder]/wp-content/plugins/wordpress-seo/src/builders/indexable-builder.php(273): Yoast\WP\SEO\Models\Indexable->save()
    #5 /home/[my website folder]/

    this is my active plugins = array (
    0 => ‘polylang/polylang.php’,
    2 => ‘advanced-rich-text-tools/index.php’,
    3 => ‘akismet/akismet.php’,
    4 => ‘booter-bots-crawlers-manager/booter-crawlers-manager.php’,
    5 => ‘code-snippets/code-snippets.php’,
    6 => ‘code-syntax-block/index.php’,
    7 => ‘fast-indexing-api/instant-indexing.php’,
    8 => ‘form-maker/form-maker.php’,
    9 => ‘health-check/health-check.php’,
    10 => ‘litespeed-cache/litespeed-cache.php’,
    11 => ‘loginizer/loginizer.php’,
    12 => ‘luckywp-table-of-contents/luckywp-table-of-contents.php’,
    13 => ‘mystickysidebar/mystickysidebar.php’,
    14 => ‘really-simple-ssl/rlrsssl-really-simple-ssl.php’,
    15 => ‘tablepress/tablepress.php’,
    16 => ‘theme-translation-for-polylang/polylang-theme-translation.php’,
    17 => ‘wordpress-seo/wp-seo.php’,
    18 => ‘wp-quicklatex/wp-quicklatex.php’,
    19 => ‘wps-hide-login/wps-hide-login.php’,
    )

    so right now, I’m restoring the last version of the website.

Viewing 16 replies (of 16 total)
  • albertvanharten

    (@albertvanharten)

    PS I was able to test the thesis by @jeskiv but was not able to reproduce it.
    I had a complete replica of the website running on my test server, from before I altered the database.
    When I activated Yoast on the replica, the website became unresponsive. I deactivated Yoast, and added INDEX privileges to the database user. Then I reactivated Yoast. Again the website became unresponsive. I deactivated Yoast again, and changed the version number in wp-seo.php as @jamesmiddz suggested. Then I updated Yoast SEO, and expected either a note stating the database should be updated or an automatically database update, but neither happened. Thus on reactivation of Yoast SEO, the site became utterly unresponsive.

    I assume, this is an unreported error in Yoast, caused by missing privileges on the database.

    In my world, a running WordPress should only require DELETE, SELECT, INSERT and UPDATE privileges. In cases of maintenance, the user also might need CREATE, but as an ethical hacker, I would recommend only use the first four privileges.
    That means that, IF Yoast SEO require other privileges (which I am not entirely sure about) then Yoast SEO should tell the user when trying to update the plugin.

    Albert van Harten
    Programmer and ethical hacker
    Denmark
    https://computernoerden.dk

Viewing 16 replies (of 16 total)
  • The topic ‘Update 14.0: Column not found: 1054 Unknown column ‘blog_id’ in ‘field list’’ is closed to new replies.