Forum GLPI-Project

BenLar

Member

From: Lanvallay

Registered: 2009-01-06

Posts: 378

Plugin Applicatif

Bonjours,

Dans la liste des applicatifs, quand je veux afficher la colonne "visible dans le help desk", j'ai le message :

"Unknown column 'glpi_plugin_applicatifs.helpdesk_visible' in 'field list'"

Ensuite, impossible de revenir en arrière.

Est-ce que vous reproduisez ?

Ben

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Plugin Applicatif

Version de GLPI ?
Version du plugin Applicatifs ?
Message dans les logs de GLPI ?
Message en mode debug ?

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

BenLar

Member

From: Lanvallay

Registered: 2009-01-06

Posts: 378

Re: Plugin Applicatif

GLPI 0.72.1
Applicatifs 1.5.1

Pour les logs, il faut que je regarde

BenLar

Member

From: Lanvallay

Registered: 2009-01-06

Posts: 378

Re: Plugin Applicatif

Voilà ce que j'obtiens dans sql-error.log lors d'import par data_injection puis quand j'affiche la colonne "Visible dans le help desk".

24-08-2009 10:55
*** MySQL query error :
***
SQL: SELECT * FROM glpi_infocoms WHERE 1  AND device_type=1200 AND FK_device=
Error: 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 '' at line 1
Backtrace :
/var/www/html/glpi/plugins/data_injection/inc/plugin_data_injection.engine.function.php:162             DBmysql->query()
/var/www/html/glpi/plugins/data_injection/inc/plugin_data_injection.engine.class.php:249                dataAlreadyInDB()
/var/www/html/glpi/plugins/data_injection/inc/plugin_data_injection.wizard.function.php:1338            DataInjectionEngine->injectLine()
/var/www/html/glpi/plugins/data_injection/inc/plugin_data_injection.wizard.function.php:1223            traitement()
/var/www/html/glpi/plugins/data_injection/front/plugin_data_injection.wizard.form.php:506               importStep()
/var/www/html/glpi/plugins/data_injection/front/plugin_data_injection.wizard.form.php

24-08-2009 10:56
*** MySQL query error :
***
SQL: SELECT glpi_plugin_applicatifs.FK_entities, glpi_plugin_applicatifs.recursive, glpi_plugin_applicatifs.name AS ITEM_0, glpi_plugin_applicatifs.ID AS ITEM_0_2, glpi_dropdown_plugin_applicatifs_type.name AS ITEM_1, glpi_dropdown_locations.completename AS ITEM_2, glpi_plugin_applicatifs.comments AS ITEM_3,  GROUP_CONCAT( DISTINCT glpi_plugin_applicatifs_device.FK_device SEPARATOR \'$$$$\') AS ITEM_4, glpi_plugin_applicatifs.helpdesk_visible AS ITEM_5, glpi_plugin_applicatifs.ID AS ID  FROM glpi_plugin_applicatifs LEFT JOIN glpi_dropdown_plugin_applicatifs_type ON (glpi_dropdown_plugin_applicatifs_type.ID = glpi_plugin_applicatifs.type)  LEFT JOIN glpi_dropdown_locations  ON (glpi_plugin_applicatifs.location = glpi_dropdown_locations.ID)  LEFT JOIN glpi_plugin_applicatifs_device ON (glpi_plugin_applicatifs.ID = glpi_plugin_applicatifs_device.FK_applicatif)  WHERE  glpi_plugin_applicatifs.deleted=\'0\'  AND (   (glpi_dropdown_plugin_applicatifs_type.name  IS  NULL   )  ) GROUP BY glpi_plugin_applicatifs.ID ORDER BY ITEM_0 ASC
Error: Unknown column 'glpi_plugin_applicatifs.helpdesk_visible' in 'field list'
Backtrace :
/var/www/html/glpi/inc/search.function.php:1077         DBmysql->query()
/var/www/html/glpi/plugins/applicatifs/index.php:51             showList()
/var/www/html/glpi/plugins/applicatifs/index.php

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

Re: Plugin Applicatif

L'update en 1.5.1 s'est mal passé : rejoue inc/plugin_applicatifs-1.5.1-update.sql

---

Xavier Caillaud
Blog GLPI Infotel

BenLar

Member

From: Lanvallay

Registered: 2009-01-06

Posts: 378

Re: Plugin Applicatif

Comment ?

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

Re: Plugin Applicatif

ben tu lance la requête du fichier directement dans phpmyadmin

---

Xavier Caillaud
Blog GLPI Infotel