You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2022-06-02 10:33:16

fplantard
Member
Registered: 2022-06-02
Posts: 4

Ticket details column empty since GLPI 10 upgrade

Hello,

I have a problem in tickets details since migration from 9.5.5 to 10.0.0, the right column is totally empty (grey)
In GLPI logs, i see this error :

[2022-06-02 10:01:32] glpiphplog.CRITICAL:   *** Uncaught Exception TypeError: CommonTreeDropdown::sanitizeSeparatorInCompletename(): Argument #1 ($completename) must be of type string, null given, called in /var/www/glpi/src/Dropdown.php on line 2927 in /var/www/glpi/src/CommonTreeDropdown.php at line 994
  Backtrace :
  src/Dropdown.php:2927                              CommonTreeDropdown::sanitizeSeparatorInCompletename()
  src/Dropdown.php:246                               Dropdown::getDropdownValue()
  src/CommonDBTM.php:3969                            Dropdown::show()
  ...ication/View/Extension/ItemtypeExtension.php:96 CommonDBTM::dropdown()
  ...es/81/81a9437f0ff6007d0919489932a2fe1c.php:2146 Glpi\Application\View\Extension\ItemtypeExtension->getItemtypeDropdown()
  .../twig/twig/src/Extension/CoreExtension.php:1202 __TwigTemplate_72df9058fe66bd3c7bbc1b885336196d->macro_dropdownField()
  ...tes/97/97726a7e4d929d31a40afd4e0e403dc8.php:322 twig_call_macro()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_ba4d194cd61653adceebe208b953da73->doDisplay()
  vendor/twig/twig/src/Template.php:367              Twig\Template->displayWithErrorHandling()
  vendor/twig/twig/src/Template.php:379              Twig\Template->display()
  vendor/twig/twig/src/TemplateWrapper.php:40        Twig\Template->render()
  .../twig/twig/src/Extension/CoreExtension.php:1323 Twig\TemplateWrapper->render()
  ...tes/aa/aab1914e54c4f71127a548b115977945.php:149 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_40d233d33d0e4c5a05b3e9e12066d60a->doDisplay()
  vendor/twig/twig/src/Template.php:367              Twig\Template->displayWithErrorHandling()
  vendor/twig/twig/src/TemplateWrapper.php:47        Twig\Template->display()
  src/Application/View/TemplateRenderer.php:177      Twig\TemplateWrapper->display()
  src/Ticket.php:4397                                Glpi\Application\View\TemplateRenderer->display()
  src/CommonGLPI.php:655                             Ticket->showForm()
  ajax/common.tabs.php:107                           CommonGLPI::displayStandardTab()

Server details :

Operating system: Linux 5.4.0-113-generic #127-Ubuntu SMP Wed May 18 14:30:56 UTC 2022 x86_64
PHP 8.1.6 fpm-fcgi (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bz2, calendar, cgi-fcgi, ctype, curl, date,
    dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre,
    pdo_mysql, posix, readline, session, shmop, soap, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tokenizer, xml,
    xmlreader, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="600" memory_limit="256M" post_max_size="8M" safe_mode="" session.save_handler="files"
    upload_max_filesize="100M"
Software: nginx/1.20.2
    Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.80 Safari/537.36
Server Software: mariadb.org binary distribution
    Server Version: 10.7.4-MariaDB-1:10.7.4+maria~focal
    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

Thanks for your help

Offline

#2 2022-06-20 15:04:43

ITPM
Member
Registered: 2022-06-20
Posts: 4

Re: Ticket details column empty since GLPI 10 upgrade

Hello, I have this same problem.
After upgrade from 9.5.7 to 10.0.0.

Offline

#3 2022-06-20 15:09:53

fplantard
Member
Registered: 2022-06-02
Posts: 4

Re: Ticket details column empty since GLPI 10 upgrade

After a lot of tests i found something :

The problem was in the glpi_locations table.
I had a lot of locations with NULL description. So i purged this table just keeping good locations and after that the description column in tickets was good.

Could you please look in this table ?

Offline

#4 2022-06-20 15:17:34

ITPM
Member
Registered: 2022-06-20
Posts: 4

Re: Ticket details column empty since GLPI 10 upgrade

fplantard wrote:

After a lot of tests i found something :

The problem was in the glpi_locations table.
I had a lot of locations with NULL description. So i purged this table just keeping good locations and after that the description column in tickets was good.

Could you please look in this table ?


Thanks!!
I deleted one row in glpi_locations where name was NULL and now all is working

Offline

Board footer

Powered by FluxBB