search

glpi-project / glpi

GLPI is a Free Asset and IT Management Software package, Data center management, ITIL Service Desk, licenses tracking and software auditing.
https://glpi-project.org
GNU General Public License v3.0
4.3k stars 1.29k forks source link

Management > Contracts > Manual Links is showing __NULL__$#$ - GLPI 10.0.8 #15145

Closed Gambware closed 1 year ago

Gambware commented 1 year ago

Code of Conduct

Is there an existing issue for this?

Version

10.0.8

Bug description

After upgrade GLPI from 10.0.7 to 10.0.8, the column that show The Manual Links in contracts is __NULL__$#$ to contract without any link as image:

image

Relevant log output

No response

Page URL

https://10.100.0.102/front/contract.php

Steps To reproduce

  1. add column Manual Links in the contract view 2- It will show the error

Your GLPI setup information

GLPI 10.0.8 ( => /dados/www/glpi) Installation mode: TARBALL Current language:pt_BR

Server

Operating system: Linux WIT-CLD1-GLPI-FRONTEND-001 5.15.0-1041-azure #48-Ubuntu SMP Tue Jun 20 20:34:08 UTC 2023 x86_64 PHP 8.1.2-1ubuntu2.11 fpm-fcgi (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, igbinary, imagick, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, redis, session, shmop, soap, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="600" memory_limit="1024M" post_max_size="50M" safe_mode="" session.save_handler="files" upload_max_filesize="50M" Software: Apache () Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/114.0 Server Software: Ubuntu 20.04 Server Version: 10.3.38-MariaDB-0ubuntu0.20.04.1 Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: xxxxxxxxxx@10.81.1.4/xxxxxxxxxxxxxx Host info: 10.81.1.4 via TCP/IP

PHP version (8.1.2-1ubuntu2.11) is supported.PHP version (8.1.2-1ubuntu2.11) 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.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.The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (10.3.38) is supported.Database engine version (10.3.38) 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 /dados/glpi_downstream/glpi/files/_cache has been validated. Write access to /dados/glpi_downstream/glpi/etc has been validated. Write access to /dados/glpi_downstream/glpi/files/_cron has been validated. Write access to /dados/glpi_downstream/glpi/files/_documents has been validated. Write access to /dados/glpi_downstream/glpi/files/_dumps has been validated. Write access to /dados/glpi_downstream/glpi/files/_graphs has been validated. Write access to /dados/glpi_downstream/glpi/files/_lock has been validated. Write access to /dados/glpi_downstream/glpi/files/_pictures has been validated. Write access to /dados/glpi_downstream/glpi/files/_plugins has been validated. Write access to /dados/glpi_downstream/glpi/files/_rss has been validated. Write access to /dados/glpi_downstream/glpi/files/_sessions has been validated. Write access to /dados/glpi_downstream/glpi/files/_tmp has been validated. Write access to /dados/glpi_downstream/glpi/files/_uploads has been validated.Write access to /dados/glpi_downstream/glpi/files/_cache has been validated. Write access to /dados/glpi_downstream/glpi/etc has been validated. Write access to /dados/glpi_downstream/glpi/files/_cron has been validated. Write access to /dados/glpi_downstream/glpi/files/_documents has been validated. Write access to /dados/glpi_downstream/glpi/files/_dumps has been validated. Write access to /dados/glpi_downstream/glpi/files/_graphs has been validated. Write access to /dados/glpi_downstream/glpi/files/_lock has been validated. Write access to /dados/glpi_downstream/glpi/files/_pictures has been validated. Write access to /dados/glpi_downstream/glpi/files/_plugins has been validated. Write access to /dados/glpi_downstream/glpi/files/_rss has been validated. Write access to /dados/glpi_downstream/glpi/files/_sessions has been validated. Write access to /dados/glpi_downstream/glpi/files/_tmp has been validated. Write access to /dados/glpi_downstream/glpi/files/_uploads has been validated.

Web server root directory configuration seems safe.Web server root directory configuration seems safe. Sessions configuration is secured.Sessions configuration is secured. OS and PHP are relying on 64 bits integers.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.openssl extension is installed. Following extensions are installed: bz2, Phar, zip.Following extensions are installed: bz2, Phar, zip. Zend OPcache extension is installed.Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium.Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /dados/www/glpi/marketplace has been validated.Write access to /dados/www/glpi/marketplace has been validated. Timezones seems loaded in database.Timezones seems loaded in database.

GLPI constants

GLPI_ROOT: "/dados/www/glpi" GLPI_CONFIG_DIR: "/dados/glpi_downstream/glpi/etc" GLPI_MARKETPLACE_ALLOW_OVERRIDE: false GLPI_VAR_DIR: "/dados/glpi_downstream/glpi/files" GLPI_DOC_DIR: "/dados/glpi_downstream/glpi/files/_documents" GLPI_CRON_DIR: "/dados/glpi_downstream/glpi/files/_cron" GLPI_DUMP_DIR: "/dados/glpi_downstream/glpi/files/_dumps" GLPI_GRAPH_DIR: "/dados/glpi_downstream/glpi/files/_graphs" GLPI_LOCK_DIR: "/dados/glpi_downstream/glpi/files/_lock" GLPI_PICTURE_DIR: "/dados/glpi_downstream/glpi/files/_pictures" GLPI_PLUGIN_DOC_DIR: "/dados/glpi_downstream/glpi/files/_plugins" GLPI_RSS_DIR: "/dados/glpi_downstream/glpi/files/_rss" GLPI_SESSION_DIR: "/dados/glpi_downstream/glpi/files/_sessions" GLPI_TMP_DIR: "/dados/glpi_downstream/glpi/files/_tmp" GLPI_UPLOAD_DIR: "/dados/glpi_downstream/glpi/files/_uploads" GLPI_CACHE_DIR: "/dados/glpi_downstream/glpi/files/_cache" GLPI_LOG_DIR: "/var/log/glpi" GLPI_SYSTEM_CRON: true GLPI_MARKETPLACE_DIR: "/dados/www/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: false GLPI_SERVERSIDE_URL_ALLOWLIST: ["/^(https?|feed):\/\/[^@:]+(\/.*)?$/"] 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_MANUAL_DOWNLOADS: true 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_LOCAL_I18N_DIR: "/dados/glpi_downstream/glpi/files/_locales" GLPI_INVENTORY_DIR: "/dados/glpi_downstream/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/marketplace/" GLPI_I18N_DIR: "/dados/www/glpi/locales" GLPI_VERSION: "10.0.8" GLPI_SCHEMA_VERSION: "10.0.8@77fc44668eaae89b61d95fe606d20d93d66110cd" GLPI_MARKETPLACE_PRERELEASES: false GLPI_MIN_PHP: "7.4.0" GLPI_MAX_PHP: "8.3.0" GLPI_YEAR: "2023"

Libraries

htmlawed/htmlawed version 1.2.14 in (/dados/www/glpi/vendor/htmlawed/htmlawed) phpmailer/phpmailer version 6.8.0 in (/dados/www/glpi/vendor/phpmailer/phpmailer/src) simplepie/simplepie version 1.5.8 in (/dados/www/glpi/vendor/simplepie/simplepie/library) tecnickcom/tcpdf version 6.6.2 in (/dados/www/glpi/vendor/tecnickcom/tcpdf) michelf/php-markdown in (/dados/www/glpi/vendor/michelf/php-markdown/Michelf) true/punycode in (/dados/www/glpi/vendor/true/punycode/src) iamcal/lib_autolink in (/dados/www/glpi/vendor/iamcal/lib_autolink) sabre/dav in (/dados/www/glpi/vendor/sabre/dav/lib/DAV) sabre/http in (/dados/www/glpi/vendor/sabre/http/lib) sabre/uri in (/dados/www/glpi/vendor/sabre/uri/lib) sabre/vobject in (/dados/www/glpi/vendor/sabre/vobject/lib) laminas/laminas-i18n in (/dados/www/glpi/vendor/laminas/laminas-i18n/src) laminas/laminas-servicemanager in (/dados/www/glpi/vendor/laminas/laminas-servicemanager/src) monolog/monolog in (/dados/www/glpi/vendor/monolog/monolog/src/Monolog) sebastian/diff in (/dados/www/glpi/vendor/sebastian/diff/src) donatj/phpuseragentparser in (/dados/www/glpi/vendor/donatj/phpuseragentparser/src/UserAgent) elvanto/litemoji in (/dados/www/glpi/vendor/elvanto/litemoji/src) symfony/console in (/dados/www/glpi/vendor/symfony/console) scssphp/scssphp in (/dados/www/glpi/vendor/scssphp/scssphp/src) laminas/laminas-mail in (/dados/www/glpi/vendor/laminas/laminas-mail/src/Protocol) laminas/laminas-mime in (/dados/www/glpi/vendor/laminas/laminas-mime/src) rlanvin/php-rrule in (/dados/www/glpi/vendor/rlanvin/php-rrule/src) blueimp/jquery-file-upload in (/dados/www/glpi/vendor/blueimp/jquery-file-upload/server/php) ramsey/uuid in (/dados/www/glpi/vendor/ramsey/uuid/src) psr/log in (/dados/www/glpi/vendor/psr/log/Psr/Log) psr/simple-cache in (/dados/www/glpi/vendor/psr/simple-cache/src) psr/cache in (/dados/www/glpi/vendor/psr/cache/src) league/csv in (/dados/www/glpi/vendor/league/csv/src) mexitek/phpcolors in (/dados/www/glpi/vendor/mexitek/phpcolors/src/Mexitek/PHPColors) guzzlehttp/guzzle in (/dados/www/glpi/vendor/guzzlehttp/guzzle/src) guzzlehttp/psr7 in (/dados/www/glpi/vendor/guzzlehttp/psr7/src) glpi-project/inventory_format in (/dados/www/glpi/vendor/glpi-project/inventory_format/lib/php) wapmorgan/unified-archive in (/dados/www/glpi/vendor/wapmorgan/unified-archive/src) paragonie/sodium_compat in (/dados/www/glpi/vendor/paragonie/sodium_compat/src) symfony/cache in (/dados/www/glpi/vendor/symfony/cache) html2text/html2text in (/dados/www/glpi/vendor/html2text/html2text/src) symfony/css-selector in (/dados/www/glpi/vendor/symfony/css-selector) symfony/dom-crawler in (/dados/www/glpi/vendor/symfony/dom-crawler) twig/twig in (/dados/www/glpi/vendor/twig/twig/src) twig/string-extra in (/dados/www/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 symfony/polyfill-php82 in (/dados/www/glpi/vendor/symfony/polyfill-php82) league/oauth2-client in (/dados/www/glpi/vendor/league/oauth2-client/src/Provider) league/oauth2-google in (/dados/www/glpi/vendor/league/oauth2-google/src/Provider) thenetworg/oauth2-azure in (/dados/www/glpi/vendor/thenetworg/oauth2-azure/src/Provider) phpCas version 1.3.8 in (/usr/share/php/CAS/source)

LDAP directories

Server: 'ldaps://1.1.1.1', Port: '636', BaseDN: 'OU=AADDC Users,DC=Cliente,DC=com,DC=br', Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: 'glpi.ad@Cliente.com.br', Use TLS: none

SQL replicas

Not active

Notifications

Way of sending emails: SMTP (anonymous@127.0.0.1)

Mails receivers

Name: 'Chamados Cliente' Active: No Server: '{outlook.office365.com:993/imap-oauth-1/ssl}' Login: 'chamado@Cliente.com.br' Password: Yes

Plugins list

actualtime           Name: ActualTime                     Version: 2.1.0      State: Installed / not activated               
    Install Method: Marketplace
advancedplanning     Name: advancedplanning               Version: 1.1.0      State: Installed / not activated               
    Install Method: Marketplace
news                 Name: Alertas                        Version: 1.12.1     State: Not installed                           
    Install Method: Marketplace
chatcorp             Name: API Chat Corp                  Version: 1.5.6      State: Installed / not activated               
    Install Method: Manual
barcode              Name: Barcode                        Version: 2.7.1      State: Not installed                           
    Install Method: Marketplace
fields               Name: Campos adicionais              Version: 1.20.6     State: Installed / not activated               
    Install Method: Marketplace
screenshot           Name: Captura de tela                Version: 2.0.2      State: Not installed                           
    Install Method: Marketplace
credit               Name: Cargas de crédito              Version: 1.11.3     State: Not installed                           
    Install Method: Marketplace
cmdb                 Name: CMDB                           Version: 3.0.3      State: Installed / not activated               
    Install Method: Marketplace
behaviors            Name: Comportamentos                 Version: 2.7.2      State: Installed / not activated               
    Install Method: Manual
accounts             Name: Contas                         Version: 3.0.3      State: Not installed                           
    Install Method: Marketplace
dividirdropdown      Name: Dividir Dropdown               Version: 1.0.0      State: Installed / not activated               
    Install Method: Manual
escalade             Name: Escalonamento                  Version: 2.9.0      State: Installed / not activated               
    Install Method: Marketplace
formcreator          Name: Form Creator                   Version: 2.13.6     State: Installed / not activated               
    Install Method: Marketplace
gantt                Name: gantt                          Version: 1.0.4      State: Installed / not activated               
    Install Method: Marketplace
gappessentials       Name: Gapp Essentials                Version: 2.1.1      State: Installed / not activated               
    Install Method: Marketplace
genericobject        Name: Gerenciamento de objetos       Version: 2.14.1     State: Installed / not activated               
    Install Method: Marketplace
datainjection        Name: Importação de dados            Version: 2.13.1     State: Installed / not activated               
    Install Method: Marketplace
releases             Name: Liberações                     Version: 2.0.3      State: Not installed                           
    Install Method: Marketplace
timelineticket       Name: Linha do tempo dos chamados    Version: 10.0+1.1   State: Installed / not activated               
    Install Method: Marketplace
mailanalyzer         Name: Mail Analyzer                  Version: 3.0.0      State: Installed / not activated               
    Install Method: Manual
mailbehaviours       Name: Mail Behaviours                Version: 2.0.0      State: Installed / not activated               
    Install Method: Manual
moreticket           Name: Mais Chamados                  Version: 1.7.1      State: Not installed                           
    Install Method: Marketplace
mreporting           Name: Mais Relatórios                Version: 1.8.2      State: Installed / not activated               
    Install Method: Marketplace
satisfaction         Name: Mais satisfação                Version: 1.6.1      State: Installed / not activated               
    Install Method: Marketplace
metabase             Name: Metabase                       Version: 1.3.2      State: Installed / not activated               
    Install Method: Marketplace
mydashboard          Name: Meu Painel                     Version: 2.1.4      State: Installed / not activated               
    Install Method: Manual
oauthimap            Name: Oauth IMAP                     Version: 1.4.1      State: Installed / not activated               
    Install Method: Manual
dashboard            Name: Painel                         Version: 1.0.3      State: Installed / not activated               
    Install Method: Manual
phpsaml              Name: PHP SAML                       Version: 1.2.1      State: Installed / not activated               
    Install Method: Manual
ticketfilter         Name: Plugin TICKETFILTER            Version: 1.0.0      State: Installed / not activated               
    Install Method: Marketplace
pdf                  Name: Print to pdf                   Version: 3.0.0      State: Installed / not activated               
    Install Method: Marketplace
reports              Name: Relatórios                     Version: 1.16.0     State: Installed / not activated               
    Install Method: Manual
singlesignon         Name: Single Sign-on                 Version: 1.3.3      State: Installed / not activated               
    Install Method: Manual
splitdropdown        Name: Split dropdown                 Version: 1.0.0      State: Not installed                           
    Install Method: Manual
tag                  Name: Tag Management                 Version: 2.11.1     State: Not installed                           
    Install Method: Marketplace
taskdrop             Name: TaskDrop                       Version: 2.0.0      State: Not installed                           
    Install Method: Marketplace
tasklists            Name: Tasks list                     Version: 2.0.3      State: Not installed                           
    Install Method: Marketplace
vip                  Name: VIP                            Version: 1.8.2      State: Installed / not activated               
    Install Method: Marketplace
webhook              Name: Webhooks                       Version: 1.0.12     State: Installed / not activated               
    Install Method: Marketplace
yagp                 Name: yagp                           Version: 2.1.1      State: Installed / not activated               
    Install Method: Marketplace

Anything else?

No response

trasher commented 1 year ago

This issue exists (at least) since 10.0.6.

trasher commented 1 year ago

Seems introduced in... 2015.

Gambware commented 1 year ago

Great! It worked. Now the field appears empty instead of __NULL$#$.__

Thank you!