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

  • Resolved Philip Faster

    (@philipfaster)


    3 years, 11 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 15 replies - 1 through 15 (of 16 total)
1 2
  • djennez

    (@djennez)

    3 years, 11 months ago

    @philipfaster can you try recreating the the tables with our Test Helper plugin (https://wordpress.org/plugins/yoast-test-helper/)? After installation / activation, go to Tools -> Test Helper and click the Reset indexables & migrations button. Keep an eye on your error logs because if this is unable to create the right table, an error should be thrown there.

    uqamsav

    (@uqamsav)

    3 years, 11 months ago

    Getting the same error!

    Thread Starter Philip Faster

    (@philipfaster)

    3 years, 11 months ago

    Hi Djennez,

    Thank you for your assistance, it’s fixed.

    When you replied, I’m trying to reupdate the Yoast (after restoring).
    Reinstalling the Yoast and install the Test Helper plugin [not activated yet].

    Then I’m trying to re-check the website, but it already fixed [no error like previous update action].
    Its like it fixed just by reinstall the update.

    • This reply was modified 3 years, 11 months ago by Philip Faster.
    uqamsav

    (@uqamsav)

    3 years, 11 months ago

    So after downloading and executing the aformentioned Reset: Fatality remains

    Fatal error: Uncaught Error: Class 'Yoast\WP\Free\Yoast_Model' not found in /home/public_html/wp-content/plugins/wordpress-seo/migrations/20180515101200_WpYoastIndexableMeta.php:72 Stack trace: #0 /home/public_html/wp-content/plugins/wordpress-seo/migrations/20180515101200_WpYoastIndexableMeta.php(20): WpYoastIndexableMeta->get_table_name() #1 /home/public_html/wp-content/plugins/wordpress-seo/vendor_prefixed/ruckusing/lib/Task/Db/Migrate.php(223): WpYoastIndexableMeta->up() #2 /home/public_html/wp-content/plugins/wordpress-seo/vendor_prefixed/ruckusing/lib/Task/Db/Migrate.php(196): YoastSEO_Vendor\Task_Db_Migrate->run_migrations(Array, 'up', NULL) #3 /home/public_html/wp-content/plugins/wordpress-seo/vendor_prefixed/ruckusing/lib/Task/Db/Migrate.php(114): YoastSEO_Vendor\Task_Db_Migrate->prepare_to_migrate(NULL, 'up') #4 /home/public_html/wp-content/plugins/wordpress-seo/vendor_prefixed/ruckusing/lib/Ruckusing/Task/Manager.php(172): YoastSEO_Vendor\Task_Db_Migrate->ex in /home/public_html/wp-content/plugins/wordpress-seo/migrations/20180515101200_WpYoastIndexableMeta.php on line 72

    Plugin Contributor Joost de Valk

    (@joostdevalk)

    3 years, 11 months ago

    @uqamsav yours is another issue than the original issue, I’m sorry to say. Looks like either you have object caching that needs to be cleared, or your update didn’t go well… Object caching issues should normally resolve quite quickly “automatically”.

    Thread Starter Philip Faster

    (@philipfaster)

    3 years, 11 months ago

    Hi Joost de Valk,

    In my cache plugin, I’m disabling the object cache.

    uqamsav

    (@uqamsav)

    3 years, 11 months ago

    uninstall, reinstall worked, thanks

    jamesmiddz

    (@jamesmiddz)

    3 years, 11 months ago

    I think I have found a way around this without losing data. Correct me if this is too stupid an idea:

    1. Go to FTP and open up the /wp-contect/plugins/wordpress-seo/wp-seo.php file.
    2. Change the version number from 14 to 13.
    3. Go to wp-admin
    4. Update your now out of date Yoast plugin.

    Worked for me. Let me know if this is a dangerous thing to do. I am not a server guy.

    jamesmiddz

    (@jamesmiddz)

    3 years, 11 months ago

    You can also make this change by going to (in wp-admin) Plugins->Plugin Editor and select the drop-down (far right) to Yoast and change the version number on the screen there. Save before continuing. Again, I am no security expert, but I would advise caution when playing around with plugins. Doing this, should cause a new update to be flagged. Update your Yoast plugin and that should fix the issue. I hope it works for you. I have had to do this for all 14 of my websites.

    pkirk

    (@pkirk)

    3 years, 11 months ago

    Same error here:

    2020/04/28 16:46:16 [error] 27912#27912: *9694809 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'blog_id' in 'field list' in /var/www/example.com/public_html/wp-content/plugins/wordpress-seo/vendor_prefixed/j4mie/idiorm/idiorm.php:464
Stack trace:
#0 /var/www/example.com/public_html/wp-content/plugins/wordpress-seo/vendor_prefixed/j4mie/idiorm/idiorm.php(464): PDOStatement->execute()
#1 /var/www/example.com/public_html/wp-content/plugins/wordpress-seo/vendor_prefixed/j4mie/idiorm/idiorm.php(1983): YoastSEO_Vendor\ORM::_execute()
#2 /var/www/example.com/public_html/wp-content/plugins/wordpress-seo/src/orm/yoast-model.php(662): YoastSEO_Vendor\ORM->save()
#3 /var/www/example.com/public_html/wp-content/plugins/wordpress-seo/src/models/indexable.php(160): Yoast\WP\SEO\ORM\Yoast_Model->save()
#4 /var/www/example.com/public_html/wp-content/plugins/wordpress-seo/src/builders/indexable-builder.php(273): Yoast\WP\SEO\Models\Indexable->save()
#5 /var/www/example.com/public_...

    I already tried:

    • Reset indexables & migrations
    • Deactivate/reactivate
    • Delete/Download and install again
    • Change the Version in wp-seo.php from 14 to 13 and update from the admin

    But nothing helped.

    It would be a LOT better to see the whole query in case of exception, to better understand the problem.

    Can you please help?

    Thanks for your time,
    —
    P.

    Marius Marolla

    (@mariusmarolla)

    3 years, 11 months ago

    Same problem here!
    Tried to update plugin, remove and install, test helper etc… but nothing solved the issue…
    Side effect: unable to create a new pages… 🙁

    pkirk

    (@pkirk)

    3 years, 11 months ago

    @mariusmarolla
    I think they just released a new version, 14.0.1, please try that.

    Marius Marolla

    (@mariusmarolla)

    3 years, 11 months ago

    Just downloaded and tried 14.0.1…. Nope, it doesn’t solve the problem…. 🙁

    jeskiv

    (@jeskiv)

    3 years, 9 months ago

    I had this problem with a newer version. It was because my WP installation did not have Index_priv privileges for the database. Maybe this will help someone else as well.

    albertvanharten

    (@albertvanharten)

    3 years, 5 months ago

    I saw @jeskiv ‘s reaction after I found a solution to the issue in my WordPress/Yoast setup. Probably it would have saved me a bit sooner if I had read it before, LOL. Thanks, @jeskiv

    I was getting Unknown column ‘blog_id’ in ‘field list’ too.
    I simply added a column called blog_id to the table.
    This resulted in other errors, stating the columns created_at and updated_at did not exist. However, the error file did not grow as quick as it did under the first error.
    After I added columns created_atand updated_at, the next error arose:
    schema_page_type did not exist.
    I decided to compare the SQL query with the existing table, and found out that there were two columns, that did not exist: one, that I already knew (schema_page_type) and schema_article_type.
    I added those columns to the table, and voilà, the problem was solved.

    Notes:
    I assume blog_idis an INT, since the value that is added is an integer
    I assume created_at and updated_at are VARCHAR with a length of 19, since the values that are added are timestamps in YYYY-mm-dd hh:II:ss format
    I assume schema_page_typeand schema_article_type are INT, although I cannot proof it. The values that are added are NULL. So the columns should also accept null values.

    My SQL statements are the following

    ALTER TABLE xxxx_yoast_indexable ADD blog_id INT NOT NULL AFTER has_public_posts;
    ALTER TABLE xxxx_yoast_indexable ADD created_at VARCHAR(19) NOT NULL AFTER permalink_hash, ADD updated_at VARCHAR(19) NOT NULL AFTER created_at;
    ALTER TABLE xxxx_yoast_indexable ADD schema_page_type INT NULL AFTER blog_id, ADD schema_article_type INT NULL AFTER schema_page_type;

    But be sure to replace xxxx with the database prefix chosen at WordPress installation (if you don’t remember: check your database or your wp-config.php).

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

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