Forum GLPI-Project

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

[GLPI 0.70 et SVN] REcherche et fin de garantie

J'ai ce message lorsque je fait une recherche :

Unknown column 'glpi_infocoms.end_warranty' in 'where clause'

SELECT glpi_computers.name AS ITEM_0, glpi_computers.ID AS ITEM_0_2, glpi_dropdown_state.name AS ITEM_1, glpi_type_computers.name AS ITEM_2, glpi_dropdown_os.name AS ITEM_3, glpi_users_FK_users.name AS ITEM_4, glpi_users_FK_users.realname AS ITEM_4_2, glpi_users_FK_users.ID AS ITEM_4_3, glpi_users_FK_users.firstname AS ITEM_4_4,glpi_groups.name AS ITEM_5, glpi_infocoms.buy_date AS ITEM_6, glpi_dropdown_manufacturer.name AS ITEM_7, glpi_dropdown_model.name AS ITEM_8, glpi_computers.otherserial AS ITEM_9, glpi_ocs_link.last_ocs_update AS ITEM_10, glpi_ocs_link.last_update AS ITEM_11, glpi_computers.serial AS ITEM_12, glpi_infocoms.warranty_info AS ITEM_13, glpi_infocoms.buy_date AS ITEM_14, glpi_infocoms.warranty_duration AS ITEM_14_2, glpi_computers.ID AS ID
FROM glpi_computers
LEFT JOIN glpi_dropdown_state ON (glpi_computers.state = glpi_dropdown_state.ID)
LEFT JOIN glpi_type_computers ON (glpi_computers.type = glpi_type_computers.ID)
LEFT JOIN glpi_dropdown_os ON (glpi_computers.os = glpi_dropdown_os.ID)
LEFT JOIN glpi_users AS glpi_users_FK_users ON (glpi_computers.FK_users = glpi_users_FK_users.ID)
LEFT JOIN glpi_groups ON (glpi_computers.FK_groups = glpi_groups.ID)
LEFT JOIN glpi_infocoms ON (glpi_computers.ID = glpi_infocoms.FK_device AND glpi_infocoms.device_type='1')
LEFT JOIN glpi_dropdown_manufacturer ON (glpi_computers.FK_glpi_enterprise = glpi_dropdown_manufacturer.ID)
LEFT JOIN glpi_dropdown_model ON (glpi_computers.model = glpi_dropdown_model.ID)
LEFT JOIN glpi_ocs_link ON (glpi_computers.ID = glpi_ocs_link.glpi_id)
WHERE glpi_computers.deleted='0' AND glpi_computers.is_template='0' AND ( glpi_computers.FK_entities IN (1) ) AND ( ( (glpi_computers.name LIKE '%serveur%' ) OR (glpi_dropdown_state.name LIKE '%serveur%' ) OR (glpi_type_computers.name LIKE '%serveur%' ) OR (glpi_dropdown_os.name LIKE '%serveur%' ) OR ( glpi_users_FK_users.name LIKE '%serveur%' OR glpi_users_FK_users.realname LIKE '%serveur%' OR glpi_users_FK_users.firstname LIKE '%serveur%' OR CONCAT(glpi_users_FK_users.realname,' ',glpi_users_FK_users.firstname) LIKE '%serveur%' ) OR (glpi_groups.name LIKE '%serveur%' ) OR ( glpi_infocoms.buy_date LIKE '%serveur%' ) OR (glpi_dropdown_manufacturer.name LIKE '%serveur%' ) OR (glpi_dropdown_model.name LIKE '%serveur%' ) OR (glpi_computers.otherserial LIKE '%serveur%' ) OR ( glpi_ocs_link.last_ocs_update LIKE '%serveur%' ) OR ( glpi_ocs_link.last_update LIKE '%serveur%' ) OR (glpi_computers.serial LIKE '%serveur%' ) OR (glpi_infocoms.warranty_info LIKE '%serveur%' ) OR ( ADDDATE(glpi_infocoms.buy_date, INTERVAL glpi_infocoms.warranty_duration MONTH) LIKE '%serveur%' ) ) AND ( (glpi_computers.name NOT LIKE '%serveur vmware%' OR glpi_computers.name IS NULL ) AND (glpi_dropdown_state.name NOT LIKE '%serveur vmware%' OR glpi_dropdown_state.name IS NULL ) AND (glpi_type_computers.name NOT LIKE '%serveur vmware%' OR glpi_type_computers.name IS NULL ) AND (glpi_dropdown_os.name NOT LIKE '%serveur vmware%' OR glpi_dropdown_os.name IS NULL ) AND ( glpi_users_FK_users.name NOT LIKE '%serveur vmware%' OR glpi_users_FK_users.realname NOT LIKE '%serveur vmware%' OR glpi_users_FK_users.firstname NOT LIKE '%serveur vmware%' OR CONCAT(glpi_users_FK_users.realname,' ',glpi_users_FK_users.firstname) NOT LIKE '%serveur vmware%' OR glpi_users_FK_users.name IS NULL) AND (glpi_groups.name NOT LIKE '%serveur vmware%' OR glpi_groups.name IS NULL ) AND ( glpi_infocoms.buy_date NOT LIKE '%serveur vmware%' OR glpi_infocoms.buy_date IS NULL ) AND (glpi_dropdown_manufacturer.name NOT LIKE '%serveur vmware%' OR glpi_dropdown_manufacturer.name IS NULL ) AND (glpi_dropdown_model.name NOT LIKE '%serveur vmware%' OR glpi_dropdown_model.name IS NULL ) AND (glpi_computers.otherserial NOT LIKE '%serveur vmware%' OR glpi_computers.otherserial IS NULL ) AND ( glpi_ocs_link.last_ocs_update NOT LIKE '%serveur vmware%' OR glpi_ocs_link.last_ocs_update IS NULL ) AND ( glpi_ocs_link.last_update NOT LIKE '%serveur vmware%' OR glpi_ocs_link.last_update IS NULL ) AND (glpi_computers.serial NOT LIKE '%serveur vmware%' OR glpi_computers.serial IS NULL ) AND (glpi_infocoms.warranty_info NOT LIKE '%serveur vmware%' OR glpi_infocoms.warranty_info IS NULL ) AND ( ADDDATE(glpi_infocoms.buy_date, INTERVAL glpi_infocoms.warranty_duration MONTH) NOT LIKE '%serveur vmware%' OR glpi_infocoms.end_warranty IS NULL ) ) )
ORDER BY glpi_computers.name ASC

---

Xavier Caillaud
Blog GLPI Infotel

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: [GLPI 0.70 et SVN] REcherche et fin de garantie

plus de précision ou ca exactement quel recherche exactement...

entre 0.70 et SVN ca m'étonerai que ca donne la meme chose vu que les critères ne sont pas les memes.

---

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

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

Re: [GLPI 0.70 et SVN] REcherche et fin de garantie

Sur les computers

Avant de lancer la recherche, j'ai la colonne expiration garantie qui est affichée

je fais une recherche

+ AND 'Serveur'
+ AND NOT 'Serveur Vmware'

et là j'ai l'erreur sur SVN et 0.70

---

Xavier Caillaud
Blog GLPI Infotel

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: [GLPI 0.70 et SVN] REcherche et fin de garantie

corrigé :
https://dev.indepnet.net:8080/glpi/changeset/6317

---

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