Forum GLPI-Project

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Bug : recherche sur les périphériques

En 0.71.3 et SVN :

Ajouter un critère de recherche global.

AND "Périphériques"  toto dans Nom

Résultat : Unknown column 'conn_periph_.end2' in 'on clause'

Requête complète :

SELECT glpi_computers.name AS ITEM_0, glpi_computers.ID AS ITEM_0_2, glpi_dropdown_manufacturer.name AS ITEM_1, glpi_dropdown_state.name AS ITEM_2, glpi_computers.serial AS ITEM_3, glpi_dropdown_model.name AS ITEM_4, glpi_dropdown_os.name AS ITEM_5, glpi_entities.completename AS ITEM_6, glpi_entities.ID AS ITEM_6_2, glpi_dropdown_locations.completename AS ITEM_7, GROUP_CONCAT( DISTINCT glpi_dropdown_netpoint.name SEPARATOR '$$$$') AS ITEM_8, GROUP_CONCAT( DISTINCT glpi_networking_ports.ifaddr SEPARATOR '$$$$') AS ITEM_9, glpi_dropdown_domain.name AS ITEM_10, glpi_computers.ID AS ITEM_11, glpi_ocs_link.last_ocs_update AS ITEM_12, glpi_computers.otherserial AS ITEM_13, GROUP_CONCAT( DISTINCT glpi_peripherals.name SEPARATOR '$$$$') AS META_0, glpi_computers.ID AS ID
FROM glpi_computers
LEFT JOIN glpi_dropdown_manufacturer ON (glpi_computers.FK_glpi_enterprise = glpi_dropdown_manufacturer.ID)
LEFT JOIN glpi_dropdown_state ON (glpi_computers.state = glpi_dropdown_state.ID)
LEFT JOIN glpi_dropdown_model ON (glpi_computers.model = glpi_dropdown_model.ID)
LEFT JOIN glpi_dropdown_os ON (glpi_computers.os = glpi_dropdown_os.ID)
LEFT JOIN glpi_entities ON (glpi_computers.FK_entities = glpi_entities.ID)
LEFT JOIN glpi_dropdown_locations ON (glpi_computers.location = glpi_dropdown_locations.ID)
LEFT JOIN glpi_computer_device AS DEVICE_5 ON (glpi_computers.ID = DEVICE_5.FK_computers AND DEVICE_5.device_type='5')
LEFT JOIN glpi_networking_ports ON (glpi_computers.ID = glpi_networking_ports.on_device AND glpi_networking_ports.device_type='1')
LEFT JOIN glpi_dropdown_netpoint ON (glpi_networking_ports.netpoint = glpi_dropdown_netpoint.ID)
LEFT JOIN glpi_dropdown_domain ON (glpi_computers.domain = glpi_dropdown_domain.ID)
LEFT JOIN glpi_ocs_link ON (glpi_computers.ID = glpi_ocs_link.glpi_id)
INNER JOIN glpi_connect_wire AS conn_periph_5 ON (conn_periph_.end2=glpi_computers.ID AND conn_periph_5.type='5')
INNER JOIN glpi_peripherals ON (conn_periph_5.end1=glpi_peripherals.ID)
WHERE glpi_computers.deleted='0' AND glpi_computers.is_template='0' AND ( glpi_computers.FK_entities IN (1) ) AND ( (glpi_peripherals.name LIKE '%toto%' ) ) GROUP BY glpi_computers.ID
ORDER BY glpi_computers.name ASC

A voir...

---

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Re: Bug : recherche sur les périphériques

Voir : 
- https://dev.indepnet.net/glpi/changeset/7756   (SVN)
- https://dev.indepnet.net/glpi/ticket/1205
- https://dev.indepnet.net/glpi/changeset/7757  (0.71-bugfixes)

++

---

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Bug : recherche sur les périphériques

je ferme.

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat