Closed SilvaFernando closed 1 week ago
cconard96
commented
6 months ago How many consumables do you have in your DB?
SELECT COUNT(*) FROM glpi_consumables;What is your current list limit (Number of search results displayed on a single page)?
SilvaFernando
commented
6 months ago Hi @cconard96.
Follow count:
SilvaFernando
commented
6 months ago Hi @cconard96. Do you have some feedback? Thanks
cconard96
commented
6 months ago How many consumables are you trying to display in GLPI at once (how many search results are you showing per page)? You indicate that the issue appears when there are a lot of consumables. In order to test this, I would need to know the total number of consumables (which you provided) and how many are trying to be shown at once so that I can try to recreate the circumstances and see if the performance can be improved any substantial amount.
SilvaFernando
commented
6 months ago Hi @cconard96. I've trying show just 10 lines, which I think is not very much, If I show just one I have the same issue.
SilvaFernando
commented
5 months ago Hi @cconard96, do you have some feedback?
SilvaFernando
commented
5 months ago Hi @cconard96, can you help-me?
stonebuzz
commented
5 months ago @SilvaFernando can you try this -> https://github.com/glpi-project/glpi/pull/16997
I don't know if you're in the same situation (in principle, yes, given the columns displayed in the consumables list), but can you test this Pull REquest?
IsaacMariaMedina
commented
5 months ago Has anyone else encountered this error when trying to search in Consumables?
Twig Error (Twig\Error\RuntimeError): "An exception has been thrown during the rendering of a template ("CommonDBTM::isMassiveActionAllowed(): Argument #1 ($items_id) must be of type int, null given")." in template "/var/www/html/glpi/templates/components/search/table.html.twig" at line 121
Additionally, when I load the Consumable Request plugin, it returns this error:
PHP User Warning (512): Duplicate keys found in search options for item type ConsumableItem: 1, 2 in /var/www/html/glpi/src/Search.php at line 8335
IsaacMariaMedina
commented
4 months ago Has anyone else encountered this error when trying to search in Consumables?
Twig Error (Twig\Error\RuntimeError): "An exception has been thrown during the rendering of a template ("CommonDBTM::isMassiveActionAllowed(): Argument #1 ($items_id) must be of type int, null given")." in template "/var/www/html/glpi/templates/components/search/table.html.twig" at line 121
Additionally, when I load the Consumable Request plugin, it returns this error:
PHP User Warning (512): Duplicate keys found in search options for item type ConsumableItem: 1, 2 in /var/www/html/glpi/src/Search.php at line 8335
The solution is to copy the old Search.php to the new path. This will help those who are facing this issue
github-actions[bot]
commented
2 months ago There has been no activity on this issue for some time and therefore it is considered stale and will be closed automatically in 10 days.
If this issue is related to a bug, please try to reproduce on latest release. If the problem persist, feel free to add a comment to revive this issue. If it is related to a new feature, please open a topic to discuss with community about this enhancement on suggestion website.
You may also consider taking a subscription to get professionnal support or contact GLPI editor team directly.
github-actions[bot]
commented
3 weeks ago There has been no activity on this issue for some time and therefore it is considered stale and will be closed automatically in 10 days.
If this issue is related to a bug, please try to reproduce on latest release. If the problem persist, feel free to add a comment to revive this issue. If it is related to a new feature, please open a topic to discuss with community about this enhancement on suggestion website.
You may also consider taking a subscription to get professionnal support or contact GLPI editor team directly.
Code of Conduct
Is there an existing issue for this?
Version
10.0.14
Bug description
Timeout on glpi_consumable items when I use these fields on personal view(NUMBER OF USED CONSUMABLES and NUMBER OF USED CONSUMABLES:
Relevant log output
Page URL
https://glpi-14.sdbrasil.ninja/front/consumableitem.php
Steps To reproduce
Use NUMBER OF USED CONSUMABLES and NUMBER OF USED CONSUMABLES, this error just occurs if you have many consumables.
Your GLPI setup information
Information about system installation & configuration
Server
Operating system: Linux 952d72f724be 4.18.0-477.21.1.el8_8.x86_64 #1 SMP Tue Aug 8 21:30:09 UTC 2023 x86_64 PHP 8.2.13 fpm-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlite, random, selinux, session, snmp, soap, sockets, sodium, sqlite3, standard, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="120" memory_limit="128M" post_max_size="20M" safe_mode="" session.save_handler="files" upload_max_filesize="20M" disable_functions="" Software: Apache () Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0 Server Software: Percona Server (GPL), Release 27, Revision 2f8eeab2 Server Version: 8.0.35-27 Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION Parameters: glpi@glpi_db_new/glpi Host info: glpi_db_new via TCP/IP PHP version (8.2.13) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter. curl extension is installed. gd extension is installed. intl extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (8.0.35) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /var/lib/glpi/files/_cache has been validated. Write access to /var/lib/glpi/files/_cron has been validated. Write access to /var/lib/glpi/files/data-documents has been validated. Write access to /var/lib/glpi/files/_dumps has been validated. Write access to /var/lib/glpi/files/_graphs has been validated. Write access to /var/lib/glpi/files/_lock has been validated. Write access to /var/lib/glpi/files/_pictures has been validated. Write access to /var/lib/glpi/files/_plugins has been validated. Write access to /var/lib/glpi/files/_rss has been validated. Write access to /var/lib/glpi/files/_sessions has been validated. Write access to /var/lib/glpi/files/_tmp has been validated. Write access to /var/lib/glpi/files/_uploads has been validated. For security reasons, SELinux mode should be Enforcing. Web server root directory configuration seems safe. Sessions configuration is secured. OS and PHP are relying on 64 bits integers. exif extension is installed. ldap extension is installed. openssl extension is installed. Following extensions are installed: bz2, Phar, zip. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. The directory could not be created in /usr/share/glpi/marketplace. Access to timezone database (mysql) is not allowed.GLPI constants
Libraries
LDAP directories
Server: none, Port: '389', BaseDN: none, Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: none, Use TLS: noneSQL replicas
Notifications
Plugins list
news Name: Alertas Version: 1.12.1 State: Enabled Install Method: Manual fields Name: Campos adicionais Version: 1.20.6 State: Enabled Install Method: Manual behaviors Name: Comportamentos Version: 2.7.2 State: Enabled Install Method: Manual datainjection Name: Data injection Version: 2.13.2 State: Enabled Install Method: Manual escalade Name: Escalonamento Version: 2.9.1 State: Enabled Install Method: Manual formcreator Name: Form Creator Version: 2.13.8.1 State: Enabled Install Method: Manual genericobject Name: Gerenciamento de objetos Version: 2.14.3 State: Enabled Install Method: Manual glpiinventory Name: GLPI Inventory Version: 1.2.1 State: Enabled Install Method: Manual pdf Name: Imprimir em PDF Version: 3.0.0 State: Enabled Install Method: Manual metabase Name: Metabase Version: 1.3.3 State: Enabled Install Method: Manual oauthimap Name: Oauth IMAP Version: 1.4.3 State: Enabled Install Method: Manual phpsaml Name: PHP SAML Version: 1.3.0 State: Enabled Install Method: Manual sdbsubtask Name: Plugin SDB SubTask Version: 1.2.1 State: Enabled Install Method: Manual sdbacaoporemail Name: Servicedesk Brasil - Ação por Version: 2.0.9 State: Enabled Install Method: ManualAnything else?
No response