
problem in table glpi_computers in glpi_inventory
[2025-03-21 14:34:20] glpisqllog.ERROR: DBmysql::doQuery() in /var/www/html/glpi/src/DBmysql.php line 395
*** MySQL query error:
SQL: INSERT INTO `glpi_computers` (`autoupdatesystems_id`, `last_inventory_update`, `is_deleted`, `last_boot`, `name`, `uuid`, `domains_id`, `users_id`, `computertypes_id`, `contact`, `otherserial`, `manufacturers_id`, `computermodels_id`, `serial`, `is_dynamic`, `entities_id`, `states_id`, `date_creation`, `date_mod`) VALUES ('5', '2025-03-21 14:34:20', '0', '2025-02-26 14:24:42', 'tremw', '2A1l2520', 'foja.dom', '1006', '1', 'trelgi@FlENE', 'CZCl49NDN', '239', '1', 'CZl49NDN', '1', '0', '0', '2025-03-21 14:34:20', '2025-03-21 14:34:20')
Error: Incorrect integer value: 'fega.dom' for column 'domains_id' at row 1
Backtrace :
src/DBmysql.php:1377 DBmysql->doQuery()
src/CommonDBTM.php:730 DBmysql->insert()
src/CommonDBTM.php:1356 CommonDBTM->addToDB()
src/Inventory/Asset/MainAsset.php:711 CommonDBTM->add()
src/RuleImportAsset.php:997 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1537 RuleImportAsset->executeActions()
src/RuleCollection.php:1660 Rule->process()
src/Inventory/Asset/MainAsset.php:581 RuleCollection->processAllRules()
src/Inventory/Inventory.php:727 Glpi\Inventory\Asset\MainAsset->handle()
src/Inventory/Inventory.php:358 Glpi\Inventory\Inventory->handleItem()
src/Inventory/Request.php:381 Glpi\Inventory\Inventory->doInventory()
src/Inventory/Request.php:90 Glpi\Inventory\Request->inventory()
src/Agent/Communication/AbstractRequest.php:359 Glpi\Inventory\Request->handleAction()
src/Agent/Communication/AbstractRequest.php:271 Glpi\Agent\Communication\AbstractRequest->handleJSONRequest()
front/inventory.php:100 Glpi\Agent\Communication\AbstractRequest->handleRequest()
index.php:93 include_once()
Customer support service by UserEcho