I need to update the view owner in Centreon.
This is my command:
UPDATE custom_view_user_relation SET user_id='505' WHERE custom_view_user_relation.custom_view_id='505';
ERROR 1062 (23000): Duplicate entry '505-505' for key 'view_user_unique_index'
I hava an error mysql. How can I make to update the view owner?
This is the correct query to change the owner:
You may want to double check id before running the query, in your example both contact and view share the same id, it’s strange.