Validate problem

Help
1

Hello,

i have a problem with validate. https://pastebin.com/FE7pfrNc

Database: missing index (alert_device_map/alert_device_map_rule_id_device_id_uindex)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
[FIX] Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE alert_device_map ADD UNIQUE alert_device_map_rule_id_device_id_uindex (rule_id,device_id);

After executing the sql command i get :
ERROR 1062 (23000): Duplicate entry ‘17-69’ for key ‘alert_device_map_rule_id_device_id_uindex’

also i have a problem with the updates when running daily.sh:

   warning: unable to access '/root/.config/git/attributes': Permission denied
  warning: unable to access '/root/.config/git/ignore': Permission denied
  error: Your local changes to the following files would be overwritten by merge:
          includes/functions.php
  Please, commit your changes or stash them before you can merge.
  Aborting
  Updating Composer packages                         OK
  Updating SQL-Schema                                OK
  Updating submodules                                OK
  Cleaning up DB                                     OK
  Fetching notifications                             OK
  Caching PeeringDB data                             OK
2

Run SELECT * FROM alert_device_map WHERE rule_id=17 AND device_id=69;

You will get 2 results, delete one then re-run the query you tried.

3

Thank you laf . i deleted the duplicate and now it’s good .