witters

Many thanks for the comprehensive reply. That all makes sense. Really appreciate your work! ??

Thanks for the speedy and considered reply. Appreciate it.

The cptui_pre_register_post_type filter looks perfect! Thanks

An alternative workaround to prevent the metabox showing in Gutenburg is setting Show in REST API to False.

Sure. I’ve no doubt this would patch the issue, but it’s not a long-term fix. (It’s bad practice to modify plugin code).

We need Yoast to correct their plugin. This thread (and the other similar ones) show it’s a broader issue with the 4.8.2 WP core that Yoast need to address.

I’m also seeing this error, which started after the update to WP 4.8.2:

[20-Sep-2017 08:45:07 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%2$s
			 WHERE target_post_id IN( %3$s )
		  GROUP BY target_post_id' at line 2 for query 
			SELECT COUNT( id ) AS incoming, target_post_id AS post_id
			  FROM %2$s
			 WHERE target_post_id IN( %3$s )
		  GROUP BY target_post_id made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, WPSEO_Link_Watcher->save_post, WPSEO_Link_Content_Processor->process, WPSEO_Link_Content_Processor->update_incoming_links, WPSEO_Meta_Storage->update_incoming_link_count

If @wordpressbeta’s comment is correct (I’ve not tried it) this would fit with the change to $wpdb->prepare() noted in the 4.8.2 release notes.

Just arrived here from Google after facing the same issue. Clearly a UX fail.

I agree it’s strange. The products that are being missed aren’t any different – they’re published, simple products, and have full catalogue visibility.

Thanks for responding so quickly. Although it’s not resolved, we’re done with the reordering task now so this isn’t a priority. I’ll leave this here in case any other people encounter a similar issue.

Hi @mujeebur,

Thanks for the quick reply.

There’s nothing in the error_log or in the exported CSV. We’re on WP Engine with 512MB as the PHP Memory limit.

I saw this a few weeks ago when we had fewer products in: ~1160 in the database then but only ~1150 in the export.

I’m considering using this plugin on a site with WooCommerce Subscriptions.

Did you find out if they were conflicting?

Me too. On a plain twentyseventeen theme running WooCommerce 3.0.4

I’d have expected an option in the Woo widget – something like ‘swatch’ or ‘colour’ alongside the defaults of ‘list’ and ‘dropdown’.

Surely we’re just missing something? Advice please; this plugin looks perfect for what I need… Thanks!

• This reply was modified 7 years, 11 months ago by witters.