Unknown column ‘object_published_at’ in ‘field list’

  • Resolved eleanna83

    (@eleanna83)


    3 years, 2 months ago

    Hello, since the last update (or since that I noticed), a site I administer produces errors, seems to consume memory and finally breaks.

    The error I get is noticed on two pages when for some reason yoast tries to do an update in database and PHP returns error. From the error log I get

    UPDATEwp_yoast_indexableSETobject_id= '1',object_type= 'user',permalink= 'https://6dim-gerak.att.sch.gr/author/eleanna/',title= NULL,description= NULL,is_cornerstone= '0',is_robots_noindex= '0',is_robots_nofollow= NULL,is_robots_noarchive= NULL,is_robots_noimageindex= NULL,is_robots_nosnippet= NULL,is_public= NULL,has_public_posts= NULL,blog_id= '1',open_graph_image= 'https://secure.gravatar.com/avatar/...?s=500&d=mm&r=g',open_graph_image_id= NULL,open_graph_image_source= 'gravatar-image',open_graph_image_meta= NULL,twitter_image= 'https://secure.gravatar.com/avatar/...?s=500&d=mm&r=g',twitter_image_id= NULL,twitter_image_source= 'gravatar-image',object_published_at= '2013-04-07 09:44:00',object_last_modified` =…PHP message: \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 Unknown column ‘object_last_modified’ in ‘field list’ \xce\xb2\xce\xac\xcf\x83\xce\xb7\xcf\x82 \xce\xb4\xce\xb5\xce\xb4\xce\xbf\xce\xbc\xce\xad\xce\xbd\xcf\x89\xce\xbd WordPress \xce\xb3\xce\xb9\xce\xb1 \xce\xb1\xce\xaf\xcf\x84\xce\xb7\xcf\x83\xce\xb7
    UPDATE wp_yoast_indexable SET object_id = ‘406’, object_type = ‘post’, object_sub_type = ‘post’, permalink = ‘https://6dim-gerak.att.sch.gr/rompotiki/’, primary_focus_keyword_score = ’31’, readability_score = ’60’, is_cornerstone = ‘0’, is_robots_noindex = NULL, is_robots_nofollow = ‘0’, is_robots_noimageindex = NULL, is_robots_noarchive = NULL, is_robots_nosnippet = NULL, open_graph_image = ‘https://6dim-gerak.att.sch.gr/wp-content/uploads/2021/06/milo1.jpg’, open_graph_image_id = NULL, open_graph_image_source = ‘first-content-image’, open_graph_image_meta = NULL, twitter_image = ‘https://6dim-gerak.att.sch.gr/wp-content/uploads/2021/06/milo1.jpg’, twitter_image_id = NULL, twitter_image_source = ‘first-content-image’, primary_focus_keyword = ‘\xcf\x83\xce\xb5\xcf\x84 \xcf\x81\xce\xbf\xce\xbc\xcf\x80\xce\xbf\xcf\x84\xce\xb9\xce\xba\xce\xae\xcf\x82 \xce\xbc\xce\xac\xce\xb8\xce\xb7\xce\xbc\xce\xb1 \xcf\x80\xce\xbb\xce\xb7\xcf\x81\xce\xbf\xcf\x86\xce\xbf\xcf\x81\xce\xb9\xce\xba\xce\xae\xcf\x82’, canonic...PHP message: \xce\xa3\xcf\x86\xce\xac\xce\xbb\xce\xbc\xce\xb1 Unknown column 'object_published_at' in 'field list' \xce\xb2\xce\xac\xcf\x83\xce\xb7\xcf\x82 \xce\xb4\xce\xb5\xce\xb4\xce\xbf\xce\xbc\xce\xad\xce\xbd\xcf\x89\xce\xbd WordPress \xce\xb3\xce\xb9\xce\xb1 \xce\xb1\xce\xaf\xcf\x84\xce\xb7\xcf\x83\xce\xb7

    If you notice this is 2 updates, for object_id=1 (me, author) and object_id=406 (post) and it keeps repeating and repeating. If I disable yoast-seo plugin, no errors, the site works smoothly. If I try to open post_id=406 (on frontpage, https://6dim-gerak.att.sch.gr/rompotiki/ ) I get white screen. If I disable the plugin it opens.

    Any suggestions please?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter eleanna83

    (@eleanna83)

    In case it helps anyone, I installed yoast-helper, run the “Reset indexable tables” … et voilà!

    @eleanna83 Thank you so very much for your feedback on your own question: this helped me fixing a problem for one of my customers! Your solution did the trick.

    Albert

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Unknown column ‘object_published_at’ in ‘field list’’ is closed to new replies.