DB Error: Column ‘object_published_at’ cannot be null

  • Resolved baumannmusic

    (@baumannmusic)


    2 years, 9 months ago

    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 2 years, 9 months ago by baumannmusic.
    • This topic was modified 2 years, 9 months ago by baumannmusic.
    • This topic was modified 2 years, 9 months ago by baumannmusic.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    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 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.

    Do let us know how it goes.

    Plugin Support devnihil

    (@devnihil)

    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.