Error Column 'term_id' in field list is ambiguous

#14054
  • Resolved Rogerio Dec
    Rank Math free

    Hi,
    I’m getting this error on my error_log file:

    WordPress Database Error Column ‘term_id’ in field list is ambiguous for the query select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘velas misticas’ OR termmeta.meta_value like ‘velas misticas,%’ ) and termmeta.term_id != 109 made by do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    How to solve this?

    • This topic was modified 4 years, 6 months ago by Rogerio Dec.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Hello,

    Thank you for contacting Rank Math and sorry for any inconvenience that might have been caused due to that.

    This error is quite unexpected and suggests that there was a failed database query. Are there several log entries of this error or just a single one?
    If there are several, we may need to take a look at this further. Please share some temporary admin access and we will be happy to check this further.

    Looking forward to helping you. Thank you.

    ​​​​​​​

    I sent you my WordPress MySql dump in sensitive data for you analyze.

    This problem has to do with the fact that I created SEO information in the Woocommerce Product Categories.
    Today it seems I have one error per termmeta inserted on the product category.

    Here a screenshot from some product category edit I made today:
    null

    If you search for the term vela below, you’ll see that’s the exact 1st term in the category shown the image above.

    Sep 04, 13:22:03

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘cosmeticos’ OR termmeta.meta_value like ‘cosmeticos,%’ ) and termmeta.term_id != 110 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:22:30

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘cosmeticos’ OR termmeta.meta_value like ‘cosmeticos,%’ ) and termmeta.term_id != 110 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:25:58

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘cozinha’ OR termmeta.meta_value like ‘cozinha,%’ ) and termmeta.term_id != 111 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:26:39

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘cozinha’ OR termmeta.meta_value like ‘cozinha,%’ ) and termmeta.term_id != 111 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:27:53

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘kit natural’ OR termmeta.meta_value like ‘kit natural,%’ ) and termmeta.term_id != 112 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:28:10

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘kit’ OR termmeta.meta_value like ‘kit,%’ ) and termmeta.term_id != 112 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:29:57

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘kit’ OR termmeta.meta_value like ‘kit,%’ ) and termmeta.term_id != 112 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:30:25

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘cosmeticos’ OR termmeta.meta_value like ‘cosmeticos,%’ ) and termmeta.term_id != 110 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:30:28

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘cozinha’ OR termmeta.meta_value like ‘cozinha,%’ ) and termmeta.term_id != 111 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:31:46

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘cozinha’ OR termmeta.meta_value like ‘cozinha,%’ ) and termmeta.term_id != 111 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:32:42

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘cosmeticos’ OR termmeta.meta_value like ‘cosmeticos,%’ ) and termmeta.term_id != 110 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:33:36

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘velas’ OR termmeta.meta_value like ‘velas,%’ ) and termmeta.term_id != 113 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:34:57

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘velas’ OR termmeta.meta_value like ‘velas,%’ ) and termmeta.term_id != 113 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:35:51

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘oleos’ OR termmeta.meta_value like ‘oleos,%’ ) and termmeta.term_id != 107 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:37:00

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘oleos’ OR termmeta.meta_value like ‘oleos,%’ ) and termmeta.term_id != 107 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:40:07

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘chas’ OR termmeta.meta_value like ‘chas,%’ ) and termmeta.term_id != 97 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:40:43

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘chas’ OR termmeta.meta_value like ‘chas,%’ ) and termmeta.term_id != 97 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:43:41

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘tinturas’ OR termmeta.meta_value like ‘tinturas,%’ ) and termmeta.term_id != 99 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:44:32

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘magia’ OR termmeta.meta_value like ‘magia,%’ ) and termmeta.term_id != 99 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    Sep 04, 13:44:48

    Erro de banco de dados do WordPress Column ‘term_id’ in field list is ambiguous para a consulta select term_id from terms inner join termmeta on terms.term_id = termmeta.term_id where termmeta.meta_key = ‘rank_math_focus_keyword’ and ( termmeta.meta_value = ‘tinturas’ OR termmeta.meta_value like ‘tinturas,%’ ) and termmeta.term_id != 99 feita por do_action(‘wp_ajax_rank_math_is_keyword_new’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Admin->is_keyword_new

    • This reply was modified 4 years, 6 months ago by Rogerio Dec.
    • This reply was modified 4 years, 6 months ago by Rogerio Dec.
    • This reply was modified 4 years, 6 months ago by Rogerio Dec.

    Hello,

    I have updated the sensitive data as requested. Can you please check further?

    Thank you.

    Hi Rogerio,

    Thanks for the additional info.

    Kindly allow me to consult our dev team on this issue and I will get back to you in a short while.

    We appreciate your patience. Thank you.

    Hello,

    Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

    If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)

The ticket ‘Error Column 'term_id' in field list is ambiguous’ is closed to new replies.