Wordpress wp_set_object_terms SQL errors

Question

I'm creating relationships on post types using this funciton:

private function setObjectTerms($last_insert_id){

      //INSERT course_type/RELATIONSHIP
      wp_set_object_terms($last_insert_id,$this->course_type,'course-type'); 

  }

Above, the course type can be 'free', or 'paid', and the $last_insert_id is just a number..

Anyway I keep getting this error, and have no idea why:

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 'AS tr INNER JOIN AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.ob' at line 1]

SELECT tr.term_taxonomy_id FROM AS tr INNER JOIN AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.object_id IN (15534) AND tt.taxonomy IN ('course-type')

The strange thing is I been using this same function, and it has worked. I just don't get why the SQL produced is incorrect. Can anyone point me in the right direction?

Community · Accepted Answer · 2017-05-23 11:57:35Z

1

The wp_term_taxonomy and wp_term_relationships table names are missing from this failed query, so, unsurprisingly, MySQL gags on it.

Internally in WordPress, the global $wpdb object furnishes those table names to the function that's building the query. If it has empty strings for the table names, it hasn't (yet) been initialized.

You may not have set up WordPress correctly before calling this function.

See this: How can I initialize wpdb class in a php file?

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Feb 12, 2014 at 1:34

O. Jones

109k17 gold badges134 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gray Over a year ago

thanks for the answer..I get where you're coming from, I've checked how my wpdb class is initialized, and it is just like the solution of that question. Really stumped, because the exact same function works when implemented from a different class...I can't see any differences with the working class and this one...i guess I'll sleep on it

Community · Accepted Answer · 2017-05-23 12:13:03Z

0

I found a solution!

$wpdb->set_prefix('wp_');

See here fellow battlers

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Feb 12, 2014 at 2:05

gray

1,1071 gold badge22 silver badges33 bronze badges

Collectives™ on Stack Overflow

Wordpress wp_set_object_terms SQL errors

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related