Update Custom Post Type Taxonomies with SQL


I’m trying to update post category but i keep error messages. I have built an update form. each category is a different product type (and a custom post).
all the other fields are working except the category

I use this wonderful guide .

I set the first query to join the table:

FROM wp_term_relationships AS tr
LEFT JOIN wp_posts AS p ON tr.object_id = p.ID
LEFT JOIN wp_term_taxonomy AS tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
LEFT JOIN wp_terms AS t ON t.term_id = tt.term_id
WHERE p.post_type = 'ye_product' AND tt.taxonomy = 'category';

and sure enough i get the table.

step two was to update the table

and my code is

UPDATE wp_term_taxonomy SET term_taxonomy_id = $cat_id WHERE object_id= $post_id;

All i get is the error

1054 – Unknown column ‘object_id’ in ‘where clause’

but I can see it. the object id is right there.

Why am I getting this error? What I did or what I didn’t know I shouldn’t do and did it any way?

Doron Davidowitz 2 years 2019-10-29T10:39:51-05:00 0 Answers 51 views 0

Leave an answer