Title: DB Error: Column ‘object_published_at’ cannot be null
Last modified: June 1, 2022

---

# DB Error: Column ‘object_published_at’ cannot be null

 *  Resolved [baumannmusic](https://wordpress.org/support/users/baumannmusic/)
 * (@baumannmusic)
 * [4 years ago](https://wordpress.org/support/topic/db-error-column-object_published_at-cannot-be-null/)
 * Hi folks,
 * since update to 18.9 we keep seeing this error right under the plugins list:
 *     ```
       Fehler: [Column 'object_published_at' cannot be null]
       INSERT INTO 'wp_yoast_indexable' 
       ('object_type', 'object_id', 'object_sub_type', 'permalink', 'blog_id', 'primary_focus_keyword_score', 'is_robots_noindex', 'is_public', 
       'open_graph_image', 'open_graph_image_id', 'open_graph_image_source', 'open_graph_image_meta', 'twitter_image', 'twitter_image_id', 'twitter_image_source', 'canonical', 'primary_focus_keyword', 
       'title', 'description', 'readability_score', 'breadcrumb_title', 'open_graph_title', 'open_graph_description', 'twitter_title', 'twitter_description', 
       'is_cornerstone', 'is_robots_nofollow', 'is_robots_noarchive', 'is_robots_noimageindex', 'is_robots_nosnippet', 'object_published_at', 'object_last_modified', 'version', 'has_ancestors', 'permalink_hash', 'created_at', 'updated_at') VALUES 
       ('term', '412', 'post_tag', 'https://www.client.com/de-de/tag/3d-scannen/', '1', NULL, NULL, NULL, 
       NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 
       NULL, NULL, NULL, '3D-Scannen', NULL, NULL, NULL, NULL, 
       '0', NULL, NULL, NULL, NULL, NULL, NULL, '2', '0', '46:xxxxxxxx5d287f89xxxxx27a29ba92c5', '2022-06-01 09:49:01', '2022-06-01 09:49:01')
       ```
   
 * The term 412 is a post tag used in many posts.
 * What we already tried:
    – edit and save the tag. – update all wp/plugins/themes
 * I just saw the table wp_termsmeta is empty – might this be a reason for the missing
   timestamp?
 * Thanks, Jan
 * Operating System: Linux
    Software: Apache MySQL version: Percona Server (GPL),
   Release ’28’, Revision ‘c335905’ v5.7.25-28 PHP Version: 7.4.29 PHP Memory Limit:
   2056M PHP Max Input Vars: 5000 PHP Max Post Size: 32M
    -  This topic was modified 4 years ago by [baumannmusic](https://wordpress.org/support/users/baumannmusic/).
    -  This topic was modified 4 years ago by [baumannmusic](https://wordpress.org/support/users/baumannmusic/).
    -  This topic was modified 4 years ago by [baumannmusic](https://wordpress.org/support/users/baumannmusic/).

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

 *  Plugin Support [Maybellyne](https://wordpress.org/support/users/maybellyne/)
 * (@maybellyne)
 * [4 years ago](https://wordpress.org/support/topic/db-error-column-object_published_at-cannot-be-null/#post-15702246)
 * Hello Jan,
 * I am sorry to learn about the WordPress database error. Since you mentioned that
   everything is updated and the issue persists, please reset the Yoast indexables
   in the database tables by following the steps below:
    1. Install & activate the
   [Yoast Test Helper](https://wordpress.org/plugins/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: Resetting the optimization doesn’t
   undo any of the hard work you’ve put into the plugin as the SEO data is also 
   stored in WordPress’ default tables. It’ll just reset the custom Yoast tables
   that contain the combined data pulled from those default tables. 4. Go to SEO
   > Tools, and under SEO data, click the “Start SEO data optimization” button to
   allow Yoast to rescan your content.
 * For your site’s health and safety, we recommend creating regular backups of your
   site and database. This is especially important before installing, updating, 
   or removing plugins. Learn more about the [benefits of regular backups](https://codex.wordpress.org/WordPress_Backups).
 * Do let us know how it goes.
 *  [devnihil](https://wordpress.org/support/users/devnihil/)
 * (@devnihil)
 * [4 years ago](https://wordpress.org/support/topic/db-error-column-object_published_at-cannot-be-null/#post-15724130)
 * We are going ahead and marking this issue as resolved due to inactivity. If you
   require any further assistance please create a new issue.

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

The topic ‘DB Error: Column ‘object_published_at’ cannot be null’ is closed to new
replies.

 * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908)
 * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/)

 * 2 replies
 * 3 participants
 * Last reply from: [devnihil](https://wordpress.org/support/users/devnihil/)
 * Last activity: [4 years ago](https://wordpress.org/support/topic/db-error-column-object_published_at-cannot-be-null/#post-15724130)
 * Status: resolved