Problem with the GLPI Inventory report

[alexmicontini]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

Version

1.0.2

Bug description

Hi,

when I access the GLPI inventory report it gives the following problem.

With the other reports there are no problems

Relevant log output

There is no error in the log files

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

Plugins list

fields Name: Additional fields Version: 1.16.0 State: Enabled Install Method: Manual tag Name: Administración de etiquetas Version: 2.9.2 State: Enabled Install Method: Manual news Name: Alertas Version: 1.10.4 State: Enabled Install Method: Manual webapplications Name: Aplicativos web Version: 4.0.1 State: Enabled Install Method: Manual cmdb Name: CMDB Version: 3.0.3 State: Enabled Install Method: Manual behaviors Name: Comportamientos Version: 2.7.1 State: Enabled Install Method: Manual datainjection Name: Data injection Version: 2.11.2 State: Enabled Install Method: Manual archimap Name: Diagrams Version: 3.2.7 State: Enabled Install Method: Manual escalade Name: Escalado Version: 2.8.0 State: Enabled Install Method: Manual formcreator Name: Form Creator Version: 2.13.0-rc.1 State: Enabled Install Method: Manual gantt Name: gantt Version: 1.0.0 State: Enabled Install Method: Manual genericobject Name: Gestión de objetos Version: 2.12.1 State: Enabled Install Method: Manual glpiinventory Name: GLPI Inventory Version: 1.0.3 State: Enabled Install Method: Manual tasklists Name: Lista de tareas Version: 2.0.1 State: Enabled Install Method: Manual mreporting Name: Más Informes Version: 1.8.0 State: Enabled Install Method: Manual metademands Name: Meta-Demands Version: 3.2.0 State: Enabled Install Method: Manual webresources Name: Web Resources Version: 2.0.2 State: Enabled Install Method: Manual

Anything else?

No response

[stonebuzz]

Hi @alexmicontini

can you provide "GLPI Setup Information"

Best regards

[alexmicontini]

Hi,

comparing with another installation I have observed that these data are missing to link them to the cards.

OTHER INSTALLATION

MY INSTALLATION PRO (lost data)

GLPI Setup Information

Información sobre la instalación y configuración del sistema

GLPI 10.0.2 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language:es_ES

Server

 
Operating system: Linux CDGPLIpre 4.19.0-20-amd64 glpi-project/glpi#1 SMP Debian 4.19.235-1 (2022-03-17) x86_64
PHP 8.1.7 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apcu, bz2, calendar,
	ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli,
	mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm,
	tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files"
	upload_max_filesize="2M" 
Software: Apache/2.4.38 (Debian) (Apache/2.4.38 (Debian) Server at glpipre.xxx.xxx.com Port 80
)
	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36
Server Software: Debian 10
	Server Version: 10.3.34-MariaDB-0+deb10u1
	Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
	Parameters: user@xxx.xx.xx.xxx/user
	Host info: xxx.xx.xx.xxx via TCP/IP
PHP version (8.1.7) is supported.

Sessions configuration is OK.

Allocated memory is sufficient.

mysqli extension is installed.

Following extensions are installed: dom, fileinfo, json, simplexml.

curl extension is installed.

gd extension is installed.

intl extension is installed.

libxml extension is installed.

zlib extension is installed.

The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.

Database engine version (10.3.34) is supported.

The log file has been created successfully.

Write access to /var/www/html/glpi/files/_cache has been validated.

Write access to /var/www/html/glpi/config has been validated.

Write access to /var/www/html/glpi/files/_cron has been validated.

Write access to /var/www/html/glpi/files has been validated.

Write access to /var/www/html/glpi/files/_dumps has been validated.

Write access to /var/www/html/glpi/files/_graphs has been validated.

Write access to /var/www/html/glpi/files/_lock has been validated.

Write access to /var/www/html/glpi/files/_pictures has been validated.

Write access to /var/www/html/glpi/files/_plugins has been validated.

Write access to /var/www/html/glpi/files/_rss has been validated.

Write access to /var/www/html/glpi/files/_sessions has been validated.

Write access to /var/www/html/glpi/files/_tmp has been validated.

Write access to /var/www/html/glpi/files/_uploads has been validated.

Web access to the files directory should not be allowed but this cannot be checked automatically on this instance.

Make sure access to error log file (/files/_log/php-errors.log) is forbidden; otherwise review .htaccess file and web server configuration.

exif extension is installed.

ldap extension is installed.

openssl extension is installed.

zip extension is installed.

bz2 extension is installed.

Zend OPcache extension is installed.

Following extensions are installed: ctype, iconv, mbstring, sodium.

Write access to /var/www/html/glpi/marketplace has been validated.

Timezones seems loaded in database.

GLPI constants

 
GLPI_ROOT: /var/www/html/glpi
GLPI_CONFIG_DIR: /var/www/html/glpi/config
GLPI_VAR_DIR: /var/www/html/glpi/files
GLPI_MARKETPLACE_DIR: /var/www/html/glpi/marketplace
GLPI_USE_CSRF_CHECK: 1
GLPI_CSRF_EXPIRES: 7200
GLPI_CSRF_MAX_TOKENS: 100
GLPI_USE_IDOR_CHECK: 1
GLPI_IDOR_EXPIRES: 7200
GLPI_ALLOW_IFRAME_IN_RICH_TEXT: 
GLPI_TELEMETRY_URI: https://telemetry.glpi-project.org
GLPI_INSTALL_MODE: TARBALL
GLPI_NETWORK_MAIL: glpi@teclib.com
GLPI_NETWORK_SERVICES: https://services.glpi-network.com
GLPI_MARKETPLACE_ALLOW_OVERRIDE: 1
GLPI_MARKETPLACE_MANUAL_DOWNLOADS: 1
GLPI_USER_AGENT_EXTRA_COMMENTS: 
GLPI_DISABLE_ONLY_FULL_GROUP_BY_SQL_MODE: 1
GLPI_AJAX_DASHBOARD: 1
GLPI_CALDAV_IMPORT_STATE: 0
GLPI_DEMO_MODE: 0
GLPI_CENTRAL_WARNINGS: 1
GLPI_DOC_DIR: /var/www/html/glpi/files
GLPI_CACHE_DIR: /var/www/html/glpi/files/_cache
GLPI_CRON_DIR: /var/www/html/glpi/files/_cron
GLPI_DUMP_DIR: /var/www/html/glpi/files/_dumps
GLPI_GRAPH_DIR: /var/www/html/glpi/files/_graphs
GLPI_LOCAL_I18N_DIR: /var/www/html/glpi/files/_locales
GLPI_LOCK_DIR: /var/www/html/glpi/files/_lock
GLPI_LOG_DIR: /var/www/html/glpi/files/_log
GLPI_PICTURE_DIR: /var/www/html/glpi/files/_pictures
GLPI_PLUGIN_DOC_DIR: /var/www/html/glpi/files/_plugins
GLPI_RSS_DIR: /var/www/html/glpi/files/_rss
GLPI_SESSION_DIR: /var/www/html/glpi/files/_sessions
GLPI_TMP_DIR: /var/www/html/glpi/files/_tmp
GLPI_UPLOAD_DIR: /var/www/html/glpi/files/_uploads
GLPI_INVENTORY_DIR: /var/www/html/glpi/files/_inventories
GLPI_NETWORK_REGISTRATION_API_URL: https://services.glpi-network.com/api/registration/
GLPI_MARKETPLACE_PLUGINS_API_URI: https://services.glpi-network.com/api/glpi-plugins/
GLPI_I18N_DIR: /var/www/html/glpi/locales
GLPI_VERSION: 10.0.2
GLPI_SCHEMA_VERSION: 10.0.2
GLPI_MARKETPLACE_PRERELEASES: 
GLPI_MIN_PHP: 7.4.0
GLPI_MAX_PHP: 8.2.0
GLPI_YEAR: 2022

Libraries

 
htmlawed/htmlawed version 1.2.6 in (/var/www/html/glpi/vendor/htmlawed/htmlawed)
phpmailer/phpmailer version 6.6.0 in (/var/www/html/glpi/vendor/phpmailer/phpmailer/src)
simplepie/simplepie version 1.5.8 in (/var/www/html/glpi/vendor/simplepie/simplepie/library)
tecnickcom/tcpdf version 6.4.4 in (/var/www/html/glpi/vendor/tecnickcom/tcpdf)
michelf/php-markdown in (/var/www/html/glpi/vendor/michelf/php-markdown/Michelf)
true/punycode in (/var/www/html/glpi/vendor/true/punycode/src)
iamcal/lib_autolink in (/var/www/html/glpi/vendor/iamcal/lib_autolink)
sabre/dav in (/var/www/html/glpi/vendor/sabre/dav/lib/DAV)
sabre/http in (/var/www/html/glpi/vendor/sabre/http/lib)
sabre/uri in (/var/www/html/glpi/vendor/sabre/uri/lib)
sabre/vobject in (/var/www/html/glpi/vendor/sabre/vobject/lib)
laminas/laminas-i18n in (/var/www/html/glpi/vendor/laminas/laminas-i18n/src)
laminas/laminas-servicemanager in (/var/www/html/glpi/vendor/laminas/laminas-servicemanager/src)
monolog/monolog in (/var/www/html/glpi/vendor/monolog/monolog/src/Monolog)
sebastian/diff in (/var/www/html/glpi/vendor/sebastian/diff/src)
donatj/phpuseragentparser in (/var/www/html/glpi/vendor/donatj/phpuseragentparser/src/UserAgent)
elvanto/litemoji in (/var/www/html/glpi/vendor/elvanto/litemoji/src)
symfony/console in (/var/www/html/glpi/vendor/symfony/console)
scssphp/scssphp in (/var/www/html/glpi/vendor/scssphp/scssphp/src)
laminas/laminas-mail in (/var/www/html/glpi/vendor/laminas/laminas-mail/src/Protocol)
laminas/laminas-mime in (/var/www/html/glpi/vendor/laminas/laminas-mime/src)
rlanvin/php-rrule in (/var/www/html/glpi/vendor/rlanvin/php-rrule/src)
blueimp/jquery-file-upload in (/var/www/html/glpi/vendor/blueimp/jquery-file-upload/server/php)
ramsey/uuid in (/var/www/html/glpi/vendor/ramsey/uuid/src)
psr/log in (/var/www/html/glpi/vendor/psr/log/Psr/Log)
psr/simple-cache in (/var/www/html/glpi/vendor/psr/simple-cache/src)
psr/cache in (/var/www/html/glpi/vendor/psr/cache/src)
league/csv in (/var/www/html/glpi/vendor/league/csv/src)
mexitek/phpcolors in (/var/www/html/glpi/vendor/mexitek/phpcolors/src/Mexitek/PHPColors)
guzzlehttp/guzzle in (/var/www/html/glpi/vendor/guzzlehttp/guzzle/src)
guzzlehttp/psr7 in (/var/www/html/glpi/vendor/guzzlehttp/psr7/src)
glpi-project/inventory_format in (/var/www/html/glpi/vendor/glpi-project/inventory_format/lib/php)
wapmorgan/unified-archive in (/var/www/html/glpi/vendor/wapmorgan/unified-archive/src)
paragonie/sodium_compat in (/var/www/html/glpi/vendor/paragonie/sodium_compat/src)
symfony/cache in (/var/www/html/glpi/vendor/symfony/cache)
html2text/html2text in (/var/www/html/glpi/vendor/html2text/html2text/src)
symfony/css-selector in (/var/www/html/glpi/vendor/symfony/css-selector)
symfony/dom-crawler in (/var/www/html/glpi/vendor/symfony/dom-crawler)
twig/twig in (/var/www/html/glpi/vendor/twig/twig/src)
twig/string-extra in (/var/www/html/glpi/vendor/twig/string-extra)
symfony/polyfill-ctype not found
symfony/polyfill-iconv not found
symfony/polyfill-mbstring not found
symfony/polyfill-php80 not found
symfony/polyfill-php81 not found
phpCas version 1.3.6 in (/usr/share/php/CAS/source)

Plugins list

 
	fields               Name: Additional fields              Version: 1.16.0     State: Enabled                                 
		Install Method: Manual
	tag                  Name: Administración de etiquetas    Version: 2.9.2      State: Enabled                                 
		Install Method: Manual
	news                 Name: Alertas                        Version: 1.10.4     State: Enabled                                 
		Install Method: Manual
	webapplications      Name: Aplicativos web                Version: 4.0.1      State: Enabled                                 
		Install Method: Manual
	cmdb                 Name: CMDB                           Version: 3.0.3      State: Enabled                                 
		Install Method: Manual
	behaviors            Name: Comportamientos                Version: 2.7.1      State: Enabled                                 
		Install Method: Manual
	datainjection        Name: Data injection                 Version: 2.11.2     State: Enabled                                 
		Install Method: Manual
	archimap             Name: Diagrams                       Version: 3.2.7      State: Enabled                                 
		Install Method: Manual
	escalade             Name: Escalado                       Version: 2.8.0      State: Enabled                                 
		Install Method: Manual
	formcreator          Name: Form Creator                   Version: 2.13.0-rc.1 State: Enabled                                 
		Install Method: Manual
	gantt                Name: gantt                          Version: 1.0.0      State: Enabled                                 
		Install Method: Manual
	genericobject        Name: Gestión de objetos             Version: 2.12.1     State: Enabled                                 
		Install Method: Manual
	glpiinventory        Name: GLPI Inventory                 Version: 1.0.3      State: Enabled                                 
		Install Method: Manual
	tasklists            Name: Lista de tareas                Version: 2.0.1      State: Enabled                                 
		Install Method: Manual
	mreporting           Name: Más Informes                   Version: 1.8.0      State: Enabled                                 
		Install Method: Manual
	metademands          Name: Meta-Demands                   Version: 3.2.0      State: Enabled                                 
		Install Method: Manual
	webresources         Name: Web Resources                  Version: 2.0.2      State: Enabled                                 
		Install Method: Manual

[stonebuzz]

When updating the plugin did you get PHP or SQL errors in GLPI (/var/www/glpi/files/_log)

Best regards

[stonebuzz]

Can you provide the result of these SQL queries

SELECT * FROM glpi_dashboards_dashboards WHERE glpi_dashboards_dashboards.key = 'plugin_glpiinventory_dashboard';

SELECT * FROM glpi_dashboards_items WHERE dashboards_dashboards_id = (SELECT id FROM glpi_dashboards_dashboards WHERE glpi_dashboards_dashboards.key = 'plugin_glpiinventory_dashboard');

Best regards

[alexmicontini]

Hi,

I provide the result of the SQL queries:

In another environment that does work, the result of executing the SQL queries is as follows:

[stonebuzz]

Hi,
data seem to differ
can you run this SQL queries

DELETE  FROM glpi_dashboards_items WHERE dashboards_dashboards_id = (SELECT id FROM glpi_dashboards_dashboard

DELETE FROM glpi_dashboards_dashboards WHERE glpi_dashboards_dashboards.key = 'plugin_glpiinventory_dashboard

Then, from GLPI root folder

php bin/console glpi:plugin:install -f glpiinventory

php bin/console glpi:plugin:activate glpiinventory

And check if dashboard is load / display correctly ?

[alexmicontini]

Hi,

Hello,

I've done what you said but the dashboard still won't load/display correctly.

I had previously uninstalled the plugin, cleared the cache and reinstalled but that didn't work either.

Inventory data is still missing

What could be happening?

[cedric-anne]

Did you installed GLPI from a nightly build ?

You should probably ensure you have the official release installed, and force the GLPI migration using php bin/console glpi:database:update --force.

[alexmicontini]

Hi @cedric-anne ,

yes, I always install the official version. The problem is not that.

I just found the problem, it seems that there is a conflict with the Metademands plugin, because when I deactivate said plugin the dashboard does load/display correctly.

Apologies because I had to disable all plugins before reporting.

Cheers

[stonebuzz]

Great,

feel free to report the problem on their repository

Best regards