Missing data in wp_terms, wp_term_taxonomy & wp_term_relationships

Hmm. Well I can say pretty confidently that CPT-onomies wouldn’t delete any relationships unless they were unchecked when you hit “Save Post”.

CPT-onomies doesn’t actually save to the term table. The relationships are stored as post meta with the meta key “_custom_post_type_onomies_relationship”.

Does that clear it up for you?

Hi thanks for super fast reply.

mmh more questions than answers really – so what are those tables used for?

When I look at the “wp_term_taxonomy” table, one of my taxonomy types was missing – when I manually added it in, in reference to the “term” and then what appears as the final piece if the jigsaw in “wp_term_relations” then the actual posts began to appear in the front-end.

The query that i’ve been using in one of my templates “content-single_saving_type” for last 2 yrs with CPT-onomies is:

$args = array(
			'post_type' => 'saving_product',
			'saving_type' => $current_slug,
			'post_status' => 'publish',
			'orderby' => 'date',
			'order' => 'DESC'
		);
$my_query = new WP_Query($args);

$current_slug is correctly being parsed – but the query returns no results.

But when I manually added records to those 3 tables – Results came back!

Is my query wrong?

thanks

I’m assuming ‘saving_type’ is a CPT-onomy. Or is it a regular taxonomy?

“Yes” under Registered CPT-onomy and its attached to “Saving Product”

So the problem now is that they’re saving in the admin, but not showing up on the front end?

Yes pretty much. When I edit or create a New post, Save and then re-edit the correct Taxonomies appear to be connected.

But one thing i’ve noticed in the admin area is, under CPT “Saving Products” I see the list of all the products and the “Saving Types” that each one is attached too – which appears correct. The “Saving Types” are hyperlinked in the Admin area (almost like a filter)

https://my-domain/wp-admin/edit.php?post_type=saving_product&saving_type=affinity-accounts

When I clicked on these links: No results appeared, BUT after I tinkered with those DB tables they started to work again (just like front-end).

If it helps I can give you a login?

If you don’t mind granting me access, I’ll look around and see if I can figure it out. I’m working on an update right now so if something is amiss on my end, I’d love to find out before I push this update out.

You can send me info at https://wpdreamer.com/contact.

No problem – can you give me an email address I can send you a login?

Sorry. I edited my last note to include the link to my contact form but I guess the edits didnt go through in time.

You can send me info at https://wpdreamer.com/contact.

Hiya – just sent you the details will some example links that hopefully will make more sense of my issue.

Thanks

Latest plugin update appears to have fixed this now.

Comparing SQL statements before and after v1.3.2 update looks like the bit:

“AND ( 0 = 1 )”

was the culprit.

Many thanks Rachel

Great! You’re very welcome.