trasher
commented
10 months ago Please provide logs with only related entries. PHP log is 4Mio, SQL one is 8Mio; that's way too huge to find what went wrong for your current issue.
Closed Olfa17 closed 10 months ago
trasher
commented
10 months ago Please provide logs with only related entries. PHP log is 4Mio, SQL one is 8Mio; that's way too huge to find what went wrong for your current issue.
Olfa17
commented
10 months ago Sorry about that. I have purged the files, reproduced the error on the GLPI page and attached the log files. php-errors.log sql-errors.log
trasher
commented
10 months ago Your error log complains about missing mysqli_report; GLPI should not work at all... Check all required extensions are installed, for your issue you can try without any plugin.
Olfa17
commented
10 months ago Yes I see that
Here are the tests carried out: -Change browser => problem still present -Deactivating extensions => problem still present -Deactivating plugins => problem still present -Private window on Firefox and Chrome => problem still present -Clearing cache => problem still present
I have the same version of GLPI and Pulgin in my DEV server, i don't have this problèm
cconard96
commented
10 months ago The mysqli_report issues seems to be affecting the cron endpoint only, so I guess your system-default version of PHP (php --version) is different to the one running in Apache (apachectl -M) and it is missing the mysqli extension. It would only be blocking the execution of automatic actions running in CLI mode and block the use of the GLPI CLI.
For the saved search issue, it looks like one of your saved searches may reference an item type that doesn't exist. Maybe a plugin is missing?
Olfa17
commented
10 months ago Hi @cconard96
For mysqli_report, i have execute your 2 request on my PROD and DEV server: Here the result:
DEV sv-glpi-dev ~ $ php --version PHP 8.2.13 (cli) (built: Nov 24 2023 13:10:01) (NTS) Copyright (c) The PHP Group Zend Engine v4.2.13, Copyright (c) Zend Technologies with Zend OPcache v8.2.13, Copyright (c), by Zend Technologies sv-glpi-dev ~ $ apachectl -M Loaded Modules: core_module (static) so_module (static) watchdog_module (static) http_module (static) log_config_module (static) logio_module (static) version_module (static) unixd_module (static) access_compat_module (shared) alias_module (shared) auth_basic_module (shared) authn_core_module (shared) authn_file_module (shared) authz_core_module (shared) authz_host_module (shared) authz_user_module (shared) autoindex_module (shared) deflate_module (shared) dir_module (shared) env_module (shared) filter_module (shared) mime_module (shared) mpm_prefork_module (shared) negotiation_module (shared) php7_module (shared) reqtimeout_module (shared) setenvif_module (shared) socache_shmcb_module (shared) status_module (shared)
PROD sv-glpi ~ $ php --version PHP 8.2.13 (cli) (built: Nov 24 2023 13:10:01) (NTS) Copyright (c) The PHP Group Zend Engine v4.2.13, Copyright (c) Zend Technologies with Zend OPcache v8.2.13, Copyright (c), by Zend Technologies sv-glpi ~ $ apachectl -M Loaded Modules: core_module (static) so_module (static) watchdog_module (static) http_module (static) log_config_module (static) logio_module (static) version_module (static) unixd_module (static) access_compat_module (shared) alias_module (shared) auth_basic_module (shared) authn_core_module (shared) authn_file_module (shared) authz_core_module (shared) authz_host_module (shared) authz_user_module (shared) autoindex_module (shared) deflate_module (shared) dir_module (shared) env_module (shared) filter_module (shared) mime_module (shared) mpm_prefork_module (shared) negotiation_module (shared) php7_module (shared) reqtimeout_module (shared) setenvif_module (shared) status_module (shared)
I saw the module " socache_shmcb_module (shared)" si missing on my PROD server, maybe the mysqli_report bug about that ?
Fir the saved search issue, i found the issue. We had saved searches of people who had left the company. I deleted them, and everything went back to normal.
cconard96
commented
10 months ago php7_module (shared)
Your web server is still running PHP 7. Disable the PHP7 Apache module, enable the PHP8.2 module, and then make sure all required PHP extensions are installed for PHP 8.2.
Olfa17
commented
10 months ago I can disable the php 7 and enable php 8.2 with these commands lines only ?
phpdismod -v 7 mbstring phpenmod -v 8.2 mbstring
trasher
commented
10 months ago Please rely on your distribution support, or ask on GLPI forums to setup properly your PHP environments.
Since the "white screen" issue has been fixed; I close this one.
Code of Conduct
Is there an existing issue for this?
Version
10.0.10
Bug description
Hello,
In my company, we have a DEV server and a PROD server. We updated the DEV to 10.0.10 in order to test it without encountering any problems. At the end of last week, we updated the PROD to the same version.
However, we are encountering a display problem in the favorites list (for ticket filters). Example: DEV:
PROD:
Log files: PHP: php-errors.log
SQL: sql-errors.log
Both servers updated, same apache2 version, kernel etc... apache2 service restarted => NOK PROD server restarted => NOK
Do you have any idea where the problem might be coming from?
Thanks in advance, Best regards,
Relevant log output
No response
Page URL
No response
Steps To reproduce
Your GLPI setup information
Informations sur le système, l'installation et la configuration
Server
Operating system: Linux sv-glpi 5.10.0-26-amd64 #1 SMP Debian 5.10.197-1 (2023-09-29) x86_64 PHP 7.4.33 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu, 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, pspell, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tidy, 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.56 (Debian) (Apache/2.4.56 (Debian) Server at sv-glpi Port 80 ) Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Server Software: Debian 11 Server Version: 10.5.21-MariaDB-0+deb11u1 Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: glpi@localhost/glpi Host info: Localhost via UNIX socket PHP version (7.4.33) 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 (10.5.21) is supported. No files from previous GLPI version detected. 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. PHP 7.4 official support has ended. An upgrade to a more recent PHP version is recommended. 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 "/var/www/html/glpi": ‣ "/var/www/html/glpi/files" ("GLPI_VAR_DIR") ‣ "/var/www/html/glpi/config" ("GLPI_CONFIG_DIR") You can ignore this suggestion if your web server root directory is "/var/www/html/glpi/public". 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. 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, sodium. Write access to /var/www/html/glpi/marketplace has been validated. Access to timezone database (mysql) is not allowed.GLPI constants
Libraries
LDAP directories
Server: 'dc01.grp.zolux.local', Port: '389', BaseDN: 'OU=Utilisateurs,DC=grp,DC=zolux,DC=local', Connection filter: none, RootDN: 'CN=GLPI_Search,OU=Utilisateurs,DC=grp,DC=zolux,DC=local', Use TLS: noneSQL replicas
Notifications
Plugins list
fields Name: Champs supplémentaires Version: 1.21.6 State: Enabled Install Method: Manual formcreator Name: Form Creator Version: 2.13.8 State: Enabled Install Method: Manual fusioninventory Name: FusionInventory Version: 10.0.6+1.1 State: Not installed Install Method: ManualAnything else?
No response