Delete hosts issue

[soltecsis-aortega]

When trying to delete a host, the following error appears.

{ "query": "SELECT keepalived_rule.id AS keepalived_rule_id, keepalived_rule.rule_type AS keepalived_rule_rule_type, keepalived_rule.rule_order AS keepalived_rule_rule_order, keepalived_rule.active AS keepalived_rule_active, keepalived_rule.group AS keepalived_rule_group, keepalived_rule.style AS keepalived_rule_style, keepalived_rule.interface AS keepalived_rule_interface, keepalived_rule.master_node AS keepalived_rule_master_node, keepalived_rule.firewall AS keepalived_rule_firewall, keepalived_rule.cfg_text AS keepalived_rule_cfg_text, keepalived_rule.comment AS keepalived_rule_comment FROM keepalived_r keepalived_rule INNER JOIN interface interface ON interface.id=keepalived_rule.interface INNER JOIN interface__ipobj hosts ON hosts.interface=interface.id INNER JOIN ipobj ipObj ON ipObj.id=hosts.ipobj AND (ipObj.id = ?) INNER JOIN firewall firewall ON firewall.id=keepalived_rule.firewall LEFT JOIN cluster cluster ON cluster.id=firewall.cluster WHERE firewall.fwcloud = :fwcloud AND interface.id IS NOT NULL", "parameters": [ 100627 ], "driverError": { "code": "ER_PARSE_ERROR", "errno": 1064, "sqlState": "42000", "sqlMessage": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':fwcloud AND interface.id IS NOT NULL' at line 1", "sql": "SELECT keepalived_rule.id AS keepalived_rule_id, keepalived_rule.rule_type AS keepalived_rule_rule_type, keepalived_rule.rule_order AS keepalived_rule_rule_order, keepalived_rule.active AS keepalived_rule_active, keepalived_rule.group AS keepalived_rule_group, keepalived_rule.style AS keepalived_rule_style, keepalived_rule.interface AS keepalived_rule_interface, keepalived_rule.master_node AS keepalived_rule_master_node, keepalived_rule.firewall AS keepalived_rule_firewall, keepalived_rule.cfg_text AS keepalived_rule_cfg_text, keepalived_rule.comment AS keepalived_rule_comment FROM keepalived_r keepalived_rule INNER JOIN interface interface ON interface.id=keepalived_rule.interface INNER JOIN interface__ipobj hosts ON hosts.interface=interface.id INNER JOIN ipobj ipObj ON ipObj.id=hosts.ipobj AND (ipObj.id = 100627) INNER JOIN firewall firewall ON firewall.id=keepalived_rule.firewall LEFT JOIN cluster cluster ON cluster.id=firewall.cluster WHERE firewall.fwcloud = :fwcloud AND interface.id IS NOT NULL" }, "code": "ER_PARSE_ERROR", "errno": 1064, "sqlState": "42000", "sqlMessage": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':fwcloud AND interface.id IS NOT NULL' at line 1", "sql": "SELECT keepalived_rule.id AS keepalived_rule_id, keepalived_rule.rule_type AS keepalived_rule_rule_type, keepalived_rule.rule_order AS keepalived_rule_rule_order, keepalived_rule.active AS keepalived_rule_active, keepalived_rule.group AS keepalived_rule_group, keepalived_rule.style AS keepalived_rule_style, keepalived_rule.interface AS keepalived_rule_interface, keepalived_rule.master_node AS keepalived_rule_master_node, keepalived_rule.firewall AS keepalived_rule_firewall, keepalived_rule.cfg_text AS keepalived_rule_cfg_text, keepalived_rule.comment AS keepalived_rule_comment FROM keepalived_r keepalived_rule INNER JOIN interface interface ON interface.id=keepalived_rule.interface INNER JOIN interface__ipobj hosts ON hosts.interface=interface.id INNER JOIN ipobj ipObj ON ipObj.id=hosts.ipobj AND (ipObj.id = 100627) INNER JOIN firewall firewall ON firewall.id=keepalived_rule.firewall LEFT JOIN cluster cluster ON cluster.id=firewall.cluster WHERE firewall.fwcloud = :fwcloud AND interface.id IS NOT NULL" }