Errors on inventory after updating glpi agent

[xillibit]

Bug reporting acknowledgment

Yes, I read it

Professional support

None

Describe the bug

I have GLPI in version 1.0.19 and the GLPI agent updated to 1.15, i was looking into to check if the machines was updated but it wasn't the case. So, i have looked on the log of one the machine where i have updated the GLPI agent :

[Mon Jul 21 10:57:51 2025][info] GLPI Agent service starting
[Mon Jul 21 10:57:51 2025][info] [http server] HTTPD service started on port 62354
[Mon Jul 21 10:57:53 2025][info] GLPI Agent memory usage: WSS=4497408 PFU=120766464
[Mon Jul 21 10:57:53 2025][info] target server0: next run: Mon Jul 21 10:57:51 2025 - http://192.168.1.230/glpi/
[Mon Jul 21 10:57:53 2025][info] target server0: server http://192.168.1.230/glpi/
[Mon Jul 21 10:57:53 2025][info] sending prolog request to server0
[Mon Jul 21 10:57:53 2025][info] server0 answer shows it supports GLPI Agent protocol
[Mon Jul 21 10:57:53 2025][info] sending contact request to server0
[Mon Jul 21 10:57:56 2025][info] running task Inventory
[Mon Jul 21 10:57:56 2025][info] New inventory from accueil-2025-07-21-10-57-51 for server0
[Mon Jul 21 10:58:23 2025][error] [http client] communication error: 500 Internal Server Error, Call to a member function bind_param() on bool
[Mon Jul 21 10:58:23 2025][error] [http client] server error: Call to a member function bind_param() on bool
[Mon Jul 21 10:58:25 2025][info] target server0: next run: Mon Jul 21 12:53:31 2025 - http://192.168.1.230/glpi/
[Mon Jul 21 11:58:26 2025][info] running task RemoteInventory: remoteinventory maintenance event
[Mon Jul 21 11:58:28 2025][info] GLPI Agent memory usage: WSS=3403776 PFU=136388608
[Mon Jul 21 12:53:31 2025][info] target server0: server http://192.168.1.230/glpi/
[Mon Jul 21 12:53:31 2025][info] sending contact request to server0
[Mon Jul 21 12:53:33 2025][info] running task Inventory
[Mon Jul 21 12:53:33 2025][info] New inventory from accueil-2025-07-21-10-57-51 for server0
[Mon Jul 21 12:54:00 2025][error] [http client] communication error: 500 Internal Server Error, Field 'id' doesn't have a default value
[Mon Jul 21 12:54:00 2025][error] [http client] server error: Field 'id' doesn't have a default value
[Mon Jul 21 12:54:01 2025][info] target server0: next run: Mon Jul 21 14:40:30 2025 - http://192.168.1.230/glpi/
[Mon Jul 21 12:54:01 2025][info] GLPI Agent memory usage: WSS=3391488 PFU=142671872

What is causing this errors ?

To reproduce

1. I have migrated GLPI from a Synology to a QNAP
2. I have updated GLPI agent from 1.10 to 1.15 on some machines and set the new IP of the QNAP
3. I have checked under GLPI and didn't seen the machines updated

Expected behavior

No errors in the log and the machines in GLPI should be updated

Operating system

Windows

GLPI Agent version

v1.15

GLPI version

10.0.19

GLPIInventory plugin or other plugin version

No response

Additional context

No response

[g-bougard]

Hi @xillibit

I moved your issue as Q&A discussion and as I don't see any glpi-agent error.

The reported error seems purely a server error: 500 Internal Server Error, Call to a member function bind_param() on bool just tells you have a server configuration issue.

I don't know in which context this error can occur, but have you checked your QNAP provides the minimal requirement for a GLPI server ? Maybe you don't have the required PHP version.

[xillibit]

The configuration is fine on the QNAP, i have made a clean install of GLPI on the QNAP then imported the GLPI tables via Phpmyadmin. I will re-try in another way

Operating system: Linux NAS7F534D 4.2.8 #​1 SMP Mon Jun 23 21:32:20 CST 2025 aarch64
PHP 8.2.27 fpm-fcgi (Core, PDO, Phar, QService Module, Reflection, SPL, SimpleXML, Zend OPcache, bcmath, calendar, cgi-fcgi,
	ctype, curl, date, dba, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, imap, intl, json, ldap, libxml,
	mbstring, mysqli, mysqlnd, openssl, pcntl, pcre, pdo_mysql, pdo_sqlite, posix, qnap_ext, random, session, shmop, soap, sockets,
	sqlite3, standard, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="86400" memory_limit="128M" post_max_size="2047M" safe_mode="" session.save_handler="files"
	upload_max_filesize="2047M" disable_functions="" 
Software: Apache ()
	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0
Server Software: MariaDB Server
	Server Version: 10.5.8-MariaDB-log
	Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
	Parameters: root@127.0.0.1:3307/glpi
	Host info: 127.0.0.1 via TCP/IP

PHP version (8.2.27) is supported.PHP version (8.2.27) is supported.
Sessions configuration is OK.Sessions configuration is OK.
Allocated memory is sufficient.Allocated memory is sufficient.
mysqli extension is installed.mysqli extension is installed.
Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter.
curl extension is installed.curl extension is installed.
gd extension is installed.gd extension is installed.
intl extension is installed.intl extension is installed.
zlib extension is installed.zlib extension is installed.
The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.
Database engine version (10.5.8) is supported.Database engine version (10.5.8) is supported.
No files from previous GLPI version detected.No files from previous GLPI version detected.
The log file has been created successfully.The log file has been created successfully.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_cache has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_cron has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_dumps has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_graphs has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_lock has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_pictures has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_plugins has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_rss has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_sessions has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_tmp has been validated.
Write access to /share/CACHEDEV1_DATA/Web/glpi/files/_uploads has been validated.

Web server root directory configuration is not safe as it permits access to non-public files. See installation documentation for more details.
The following directories should be placed outside "/share/CACHEDEV1_DATA/Web/glpi":
‣ "/share/CACHEDEV1_DATA/Web/glpi/files" ("GLPI_VAR_DIR")
You can ignore this suggestion if your web server root directory is "/share/CACHEDEV1_DATA/Web/glpi/public".
PHP directive "session.cookie_secure" should be set to "on" when GLPI can be accessed on HTTPS protocol.
PHP directive "session.cookie_httponly" should be set to "on" to prevent client-side script to access cookie values.
OS and PHP are relying on 64 bits integers.
exif extension is installed.exif extension is installed.
ldap extension is installed.ldap extension is installed.
openssl extension is installed.
Following extensions are installed: Phar, zip.
Following extensions are not present: bz2.
Zend OPcache extension is installed.
Following extensions are installed: ctype, iconv, mbstring.
Following extensions are not present: sodium.
Write access to /share/CACHEDEV1_DATA/Web/glpi/marketplace has been validated.
Timezones seems not loaded, see https://glpi-install.readthedocs.io/en/latest/timezones.html.

[g-bougard]

You should check the GLPI php-errors.log file to better understand the error. It may also be related to a wrong plugin.

[xillibit]

I don't have any plugins. I have looked into gli/files/_log and opened php-errors.log, there was tables missing :

glpiphplog.WARNING: *** PHP User Warning (512): Table glpi_networkequipments does not exists in /share/CACHEDEV1_DATA/Web/glpi/src/DBmysql.php at line 1236
glpiphplog.WARNING: *** PHP User Warning (512): Table glpi_monitors does not exists in /share/CACHEDEV1_DATA/Web/glpi/src/DBmysql.php at line 1236
glpiphplog.WARNING: *** PHP User Warning (512): Table glpi_manufacturers does not exists in /share/CACHEDEV1_DATA/Web/glpi/src/DBmysql.php at line 1236
glpiphplog.WARNING: *** PHP User Warning (512): Table glpi_monitormodels does not exists in /share/CACHEDEV1_DATA/Web/glpi/src/DBmysql.php at line 1236

I have juste imported the tables missing by following the errors messages. I will check at the next inventory of computers if the issue still happens.

[xillibit]

In the log of the computer i don't have have the errors this time, but i have a weird date on the GLPI :

[Tue Jul 22 10:41:01 2025][info] target server0: server http://192.168.1.230/glpi/
[Tue Jul 22 10:41:01 2025][info] sending contact request to server0
[Tue Jul 22 10:41:03 2025][info] running task Inventory
[Tue Jul 22 10:41:03 2025][info] New inventory from eef-accueil-2025-07-21-10-57-51 for server0
[Tue Jul 22 10:41:31 2025][info] target server0: next run: Tue Jul 22 12:51:17 2025 - http://192.168.1.230/glpi/
[Tue Jul 22 10:41:31 2025][info] GLPI Agent memory usage: WSS=3346432 PFU=187174912

Why it has set last modified to 2025-07-22 16:41 instead of 2025-07-22 10:41 ?

The timezone in php settings was on Asia/Tapei, i have changed it to Europe/Paris i think it will solve the issue with wrong date in log and in GLPI itself need to wait the next inventory of computer

[xillibit]

I have still computers that aren't able to update their inventory, on the computer which i have just updated the agent with the new IP :

[Tue Jul 22 14:28:22 2025][info] target server0: server http://192.168.1.229/glpi/
[Tue Jul 22 14:28:23 2025][info] running task Inventory
[Tue Jul 22 14:28:23 2025][info] New inventory from op-sig-new-2024-10-02-10-11-49 for server0
[Tue Jul 22 14:28:55 2025][info] running task RemoteInventory
[Tue Jul 22 14:28:57 2025][info] target server0: next run: Tue Jul 22 16:22:22 2025 - http://192.168.1.229/glpi/
[Tue Jul 22 14:28:57 2025][info] GLPI Agent memory usage: WSS=3260416 PFU=213331968
[Tue Jul 22 14:34:10 2025][info] GLPI Agent exiting (4212)
[Tue Jul 22 14:34:35 2025][info] GLPI Agent service starting
[Tue Jul 22 14:34:35 2025][info] [http server] HTTPD service started on port 62354
[Tue Jul 22 14:34:36 2025][info] GLPI Agent memory usage: WSS=4411392 PFU=120508416
[Tue Jul 22 14:34:36 2025][info] target server0: next run: Tue Jul 22 14:34:35 2025 - http://192.168.1.230/glpi/
[Tue Jul 22 14:34:36 2025][info] target server0: server http://192.168.1.230/glpi/
[Tue Jul 22 14:34:36 2025][info] sending prolog request to server0
[Tue Jul 22 14:34:36 2025][info] server0 answer shows it supports GLPI Agent protocol
[Tue Jul 22 14:34:36 2025][info] sending contact request to server0
[Tue Jul 22 14:34:37 2025][info] running task Inventory
[Tue Jul 22 14:34:37 2025][info] New inventory from op-sig-new-2024-10-02-10-11-49 for server0
[Tue Jul 22 14:35:05 2025][error] [http client] communication error: 500 Internal Server Error, Call to a member function bind_param() on bool
[Tue Jul 22 14:35:05 2025][error] [http client] server error: Call to a member function bind_param() on bool
[Tue Jul 22 14:35:09 2025][info] target server0: next run: Tue Jul 22 16:19:17 2025 - http://192.168.1.230/glpi/
[Tue Jul 22 14:37:46 2025][info] GLPI Agent service starting
[Tue Jul 22 14:37:46 2025][info] [http server] HTTPD service started on port 62354
[Tue Jul 22 14:37:48 2025][info] GLPI Agent memory usage: WSS=4497408 PFU=121036800
[Tue Jul 22 14:37:48 2025][info] target server0: next run: Tue Jul 22 16:19:17 2025 - http://192.168.1.230/glpi/

On the gli/files/_log and opened php-errors.log, i have that :

[2025-07-22 14:43:34] glpiphplog.WARNING: *** PHP Warning (2): Undefined array key "id" in /share/CACHEDEV1_DATA/Web/
glpi/src/RuleImportAsset.php at line 927
Backtrace :
src/Rule.php:1537 RuleImportAsset->executeActions()
src/RuleCollection.php:1658 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()

[2025-07-22 14:43:34] glpiphplog.WARNING: *** PHP Warning (2): Undefined array key "id" in /share/CACHEDEV1_DATA/Web/
glpi/src/Inventory/Asset/MainAsset.php at line 836
Backtrace :
src/RuleImportAsset.php:985 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1537 RuleImportAsset->executeActions()
src/RuleCollection.php:1658 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()

[2025-07-22 14:43:34] glpiphplog.WARNING: *** PHP Warning (2): Undefined array key "id" in /share/CACHEDEV1_DATA/Web/
glpi/src/Inventory/Asset/MainAsset.php at line 848
Backtrace :
src/RuleImportAsset.php:985 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1537 RuleImportAsset->executeActions()
src/RuleCollection.php:1658 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()

[xillibit]

I have deleted all the tables on the QNAP and made a new import of the tables from the Synology, then launched the update of GLPI. So now i can confirm that it works like should because i have two computers which have showed as updated on GLPI.

[jcmarin258]

Hello,

I am experiencing a similar issue. I installed GLPI 10.0.19 on Ubuntu Server 24.04, with the GLPIInventory plugin version 1.15, and I am using the GLPI agent version 1.15 on a Windows machine.

I am unable to find the option to allow anonymous or new agents to connect automatically, and the agent connection attempts are being blocked (HTTP 403 error). Could you please advise if this is related to the plugin version or configuration on Ubuntu?

Thank you for your help!