error when replay rules component catalog | mysql error

[Jm0u]

*** MySQL query error:

---

SQL: SELECT glpi_computers.name AS ITEM_0, glpi_computers.id AS ITEM_0_2, glpi_states.completename AS ITEM_1, glpi_operatingsystems.name AS ITEM_2, glpi_computers.id AS id FROM glpi_computersLEFT JOIN glpi_states ON (glpi_computers.states_id = glpi_states.id )LEFT JOIN glpi_operatingsystems ON (glpi_computers.operatingsystems_id = glpi_operatingsystems.id ) WHERE glpi_computers.is_deleted = '0' AND glpi_computers.is_template = '0' AND ( glpi_computers.entities_id IN ('0', '13', '6', '20', '23', '18', '19', '1') ) AND ( glpi_computers.name LIKE '%srv%' AND (glpi_states.id <> '9' OR glpi_states.id IS NULL) AND (glpi_states.id <> '1' OR glpi_states.id IS NULL) AND glpi_operatingsystems.name LIKE '%vmware ESX%' AND . LIKE '%vswif2%' ) AND glpi_computers.id='345' ORDER BY ITEM_0 ASC Error: Unknown column '' in 'where clause' Backtrace : /usr/local/itsupport/plugins/monitoring/inc/search.class.php :1166 DBmysql->query() /usr/local/itsupport/plugins/monitoring/inc/componentscatalog_rule.class.php :497 PluginMonitoringSearch->constructSQL() /usr/local/itsupport/plugins/monitoring/hook.php :525 PluginMonitoringComponentscatalog_rule::isThisItemCheckRule()  : plugin_monitoring_ReplayRulesForItem()

[ddurieux]

La recherche sur le mot 'vswif2' correspond à quel critère?

[Jm0u]

A cela Mais comme il n'y a pas de résultat il y a le bug

[ddurieux]

T'as toujours le soucis? Si oui, il faudrait le comtenu de la table glpi_plugin_monitoring_componentscatalogs_rules correspondant a l'id 74