Forum GLPI-Project

supertramp4

Member

Registered: 2022-06-13

Posts: 28

Change Agent Type generates sql-errors

Hi,
GLPI 10.0.2, GLPI-Inventory 1.0.3, GLPI Agent 1.2 installed on local machine ( All installed on Windows Server 2019)

if in Agents you change the Type from "Core" to "GLPI Inventory Plugin" ( or the other way round) , it generates an error in sql-errors.log

[2022-07-18 12:20:23] glpisqllog.ERROR: DBmysql::query() in D:\apache\htdocs\glpi\src\DBmysql.php line 370
  *** MySQL query error:
  SQL: UPDATE `glpi_agents` SET `items_id` = '' WHERE `id` = '6'
  Error: Incorrect integer value: '' for column `glpi`.`glpi_agents`.`items_id` at row 1
  Backtrace :
  src\DBmysql.php:1431                               
  src\CommonDBTM.php:661                             DBmysql->update()
  src\CommonDBTM.php:1657                            CommonDBTM->updateInDB()
  front\agent.form.php:96                            CommonDBTM->update()
  {"user":"12@NT2"}

If i am using GLPI-Inventory, then should the Agent to set to "GLPI Inventory Plugin" for correct operation ?