Yoast SEO plugin seems to have issues with custom post type registration:

NOTICE: PHP message: WordPress-Datenbank-Fehler Unknown column 'target_indexable_id' in 'where clause' für Abfrage SELECT COUNT(ID)
FROM wp_posts
WHERE
        (
                ID NOT IN (
   SELECT object_id
   FROM wp_yoast_indexable
   WHERE
           link_count IS NOT NULL
           AND object_type = 'post'
                )
                OR
                ID IN (
   SELECT DISTINCT post_id
   FROM wp_yoast_seo_links
   WHERE
           target_indexable_id IS NULL
           AND <code>type</code> = 'internal'
           AND target_post_id IS NOT NULL
           AND target_post_id != 0
                )
        )
        AND post_status = 'publish'
        AND post_type IN ('page', 'attachment', 'history_event', 'menu_page')

 von do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Admin\Indexing_Notification_Integration->maybe_create_notification, Yoast\WP\SEO\Integrations\Admin\Indexing_Notification_Integration->should_show_notification, Yoast\WP\SEO\Helpers\Indexing_Helper->get_filtered_unindexed_count, Yoast\WP\SEO\Helpers\Indexing_Helper->get_unindexed_count, Yoast\WP\SEO\Actions\Indexing\Abstract_Link_Indexing_Action->get_total_unindexed

Minimal PHP code to reproduce this issue:

<?php
add_action('init', function() {
	$args = array(
		'public' => true,
	);
	register_post_type('history_event', $args);

	$args = array(
		'public' => true,
	);
	register_post_type('menu_page', $args);
});

Two of these custom post types must be registered in order to cause the bug.
The stripped down example code above would cause the same issue with labels and everything else added. It also doesn’t matter what custom post type slug is used.

Thanks and
with best regards

• This topic was modified 1 month, 3 weeks ago by strarsis.
• This topic was modified 1 month, 3 weeks ago by strarsis.
• This topic was modified 1 month, 3 weeks ago by strarsis.