Resolved Cannot activate firewall MySQL error

[finbarr69]

When I try to change a firewall rule, and I get to the button to apply the configuraiton, I get this error:

DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-0-0' for key 'configuration_id', query was: insert into module_firewall_rules (configuration_id, direction, priority, object) values (:configuration, :direction, :priority, :object)

I need to urgently change my firewall rules. Can you advise please?

Thanks,

Brian

 

[mr-wolf]

Does a plesk repair db -y -v fix your issue?

 

[finbarr69]

Thank you! Yes, that fixed it (along with 6 other issues it found).