WordPress MU

Hi,

we are cleaning up the error logs. We have already identified several types of error messeages. Thsi one ist the next ()see at teh bottom:

1) It is not usual to update primary key (see first 2 sql). Is it an error ? IT could be indicate an error in certain script.

2) The 3. SQL error message has an error itself:
a) term_id_taxonomy is not a key, but an index (the PRIMARY key is: term_taxonomy_id)
b)the column term_id (which the sql tried to update) has no unique constraint

Please let me know, if it is an error annd how to solve it.

Thanks in advance,

Michel

WordPress database error Duplicate entry '3' for key 'PRIMARY' for query UPDATE wp_45_terms SET term_id = 3 WHERE term_id = 2943 made by edit_post, wp_update_post, wp_insert_post, do_action, call_user_func_array, SimpleTagsAdmin->saveAdvancedTagsInput, wp_set_object_terms, wp_insert_term, apply_filters, call_user_func_array, global_terms

WordPress database error Duplicate entry '3' for key 'PRIMARY' for query UPDATE wp_45_terms SET term_id = 3 WHERE term_id = 2943 made by edit_post, wp_update_post, wp_insert_post, do_action, call_user_func_array, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action, call_user_func_array, SimpleTagsAdmin->saveAdvancedTagsInput, wp_set_object_terms, wp_insert_term, apply_filters, call_user_func_array, global_terms

WordPress database error Duplicate entry '3-post_tag' for key 'term_id_taxonomy' for query UPDATE wp_45_term_taxonomy SET term_id = 3 WHERE term_id = 2943 made by edit_post, wp_update_post, wp_insert_post, do_action, call_user_func_array, SimpleTagsAdmin->saveAdvancedTagsInput, wp_set_object_terms, wp_insert_term, apply_filters, call_user_func_array, global_terms

Supplement:

MySQL uses the word "key" also for index. term_id_taxonomy is an unique index composed of term_id and taxonomy.

Regards,

Michel

It's the Simple Tags plugin causing the error.

"SimpleTagsAdmin->saveAdvancedTags"