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.18k stars 1.28k forks source link

Right panel of ticket is blank #11379

Closed DroidBV8 closed 2 years ago

DroidBV8 commented 2 years ago

Code of Conduct

Is there an existing issue for this?

Version

10.0

Bug description

Hello,

I have just upgraded from v.9.5.7 to V10 and it is impossible for me to edit a ticket: change the status etc...

the right block allowing this is just empty.

When creating a ticket, I don't even have a submit button..

It's very problematic l7Wp07SzjT l7Wp07SzjT m9rqwcA4Nj

I just tested a new install and it's perfect. So for me there is a problem when upgrading from 9.5.7 to v.10.

As soon as I use my BDD backup and update the BDD, I have this problem.

Very unfortunate. I didn't think I was the only one with this problem.

So I'm going to stay on 9.5.7 while waiting for a fix or a response from the Techlib devs

Relevant log output

No response

Page URL

No response

Steps To reproduce

Migrate glpi 9.5.7 to V.10:

Your GLPI setup information

Informations sur le système, l'installation et la configuration
GLPI 10.0.0 (/glpi => /var/www/html/glpi)
Installation mode: TARBALL
Current language:fr_FR
Server
 
Operating system: Linux srvglpi 5.10.0-13-amd64 #1 SMP Debian 5.10.106-1 (2022-03-17) x86_64
PHP 7.4.28 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu, bz2,
    calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, intl, json, ldap, libxml,
    mbstring, memcache, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard,
    sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlreader, 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.53 (Debian) (Apache/2.4.53 (Debian) Server at 172.23.62.213 Port 80
)
    Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.133 Safari/537.36
Server Software: Debian 11
    Server Version: 10.5.15-MariaDB-0+deb11u1
    Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    Parameters: glpiuser@localhost/glpidb
    Host info: Localhost via UNIX socket

PHP version (7.4.28) 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.5.15) 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 files directory is protected
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.0
GLPI_SCHEMA_VERSION: 10.0.0@9eb698d8fd49f9256d7bd63a6d747587e0effaff
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)
mpdf/mpdf in (/var/www/html/glpi/vendor/mpdf/mpdf/src)
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/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 in (/var/www/html/glpi/vendor/symfony/polyfill-php80)
symfony/polyfill-php81 in (/var/www/html/glpi/vendor/symfony/polyfill-php81)
SQL replicas
 
Not active
Notifications
 
Way of sending emails: SMTP+TLS (hadrien.binson@ville.angers.fr@smtp.office365.com)
Plugins list
 
    news                 Name: Alertes                        Version: 1.9.1      State: Error / to clean
    fields               Name: Champs supplémentaires         Version: 1.12.12    State: Error / to clean
    datainjection        Name: Data Injection                 Version: 2.10.1     State: Error / to clean
    escalade             Name: Escalades                      Version: 2.7.2      State: Error / to clean
    fusioninventory      Name: FusionInventory                Version: 9.5.0+1.0  State: Error / to clean

Anything else?

No response

cconard96 commented 2 years ago

Please check the GLPI log files for any entries around the time you tried viewing/editing a ticket. In particular, files/_log/php-errors.log and files/_log/sql-errors.log.

DroidBV8 commented 2 years ago

@cconard96

cat files/_log/php-errors.log

[2022-04-25 13:17:01] glpiphplog.WARNING: Test logger  
[2022-04-25 13:23:02] glpiphplog.WARNING: Test logger  
[2022-04-25 13:23:02] glpiphplog.WARNING: Test logger  
[2022-04-25 13:23:31] glpiphplog.DEBUG: Html::compileScss() in /var/www/html/glpi/src/Html.php line 6810
Compile css/palettes/auror.scss  {"user":"@srvglpi"} 
[2022-04-25 13:23:58] glpiphplog.CRITICAL:   *** Twig Error (Twig\Error\RuntimeError): "The merge filter only works with arrays or "Traversable", got "NULL" as first argument." in template "/var/www/html/glpi/templates/components/itilobject/fields/priority_matrix.html.twig" at line 58
  Backtrace :
  ...1c3bb90a055d4b5ba6904a8e98a710760be2790b.php:75 twig_array_merge()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_665c4fd0e1c348eabff08fc3f0dec40a9abe62bffe49d251be1628a847d5a0ab->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()
  ...d54d4a02510a85ebf1b95d52dca8aa290bd4b83.php:312 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_6c470747856d93a62bdecc99eb9b570586026045a1c8a53098e676df4cd4130f->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()
  ...3176d4f4a5c5d68f761da4c83b2a39ac619a423.php:149 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_e16cc0d180a6e8690c02d42d6e09dd222607f59b8508582007c04a8d557ae004->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()

[2022-04-25 13:24:14] glpiphplog.CRITICAL:   *** Twig Error (Twig\Error\RuntimeError): "The merge filter only works with arrays or "Traversable", got "NULL" as first argument." in template "/var/www/html/glpi/templates/components/itilobject/fields/priority_matrix.html.twig" at line 58
  Backtrace :
  ...1c3bb90a055d4b5ba6904a8e98a710760be2790b.php:75 twig_array_merge()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_665c4fd0e1c348eabff08fc3f0dec40a9abe62bffe49d251be1628a847d5a0ab->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()
  ...d54d4a02510a85ebf1b95d52dca8aa290bd4b83.php:312 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_6c470747856d93a62bdecc99eb9b570586026045a1c8a53098e676df4cd4130f->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()
  ...3176d4f4a5c5d68f761da4c83b2a39ac619a423.php:149 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_e16cc0d180a6e8690c02d42d6e09dd222607f59b8508582007c04a8d557ae004->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()

[2022-04-25 13:39:10] glpiphplog.WARNING: Test logger  
[2022-04-25 13:40:03] glpiphplog.WARNING: Test logger  
[2022-04-25 13:42:58] glpiphplog.CRITICAL:   *** Twig Error (Twig\Error\RuntimeError): "The merge filter only works with arrays or "Traversable", got "NULL" as first argument." in template "/var/www/html/glpi/templates/components/itilobject/fields/priority_matrix.html.twig" at line 58
  Backtrace :
  ...1c3bb90a055d4b5ba6904a8e98a710760be2790b.php:75 twig_array_merge()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_665c4fd0e1c348eabff08fc3f0dec40a9abe62bffe49d251be1628a847d5a0ab->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()
  ...d54d4a02510a85ebf1b95d52dca8aa290bd4b83.php:312 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_6c470747856d93a62bdecc99eb9b570586026045a1c8a53098e676df4cd4130f->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()
  ...3176d4f4a5c5d68f761da4c83b2a39ac619a423.php:149 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_e16cc0d180a6e8690c02d42d6e09dd222607f59b8508582007c04a8d557ae004->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()

[2022-04-25 13:43:09] glpiphplog.CRITICAL:   *** Twig Error (Twig\Error\RuntimeError): "The merge filter only works with arrays or "Traversable", got "NULL" as first argument." in template "/var/www/html/glpi/templates/components/itilobject/fields/priority_matrix.html.twig" at line 58
  Backtrace :
  ...1c3bb90a055d4b5ba6904a8e98a710760be2790b.php:75 twig_array_merge()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_665c4fd0e1c348eabff08fc3f0dec40a9abe62bffe49d251be1628a847d5a0ab->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()
  ...d54d4a02510a85ebf1b95d52dca8aa290bd4b83.php:312 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_6c470747856d93a62bdecc99eb9b570586026045a1c8a53098e676df4cd4130f->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()
  ...3176d4f4a5c5d68f761da4c83b2a39ac619a423.php:149 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_e16cc0d180a6e8690c02d42d6e09dd222607f59b8508582007c04a8d557ae004->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()

[2022-04-25 13:52:29] glpiphplog.WARNING: Test logger  
[2022-04-25 14:02:40] glpiphplog.CRITICAL:   *** Twig Error (Twig\Error\RuntimeError): "The merge filter only works with arrays or "Traversable", got "NULL" as first argument." in template "/var/www/html/glpi/templates/components/itilobject/fields/priority_matrix.html.twig" at line 58
  Backtrace :
  ...1c3bb90a055d4b5ba6904a8e98a710760be2790b.php:75 twig_array_merge()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_665c4fd0e1c348eabff08fc3f0dec40a9abe62bffe49d251be1628a847d5a0ab->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()
  ...d54d4a02510a85ebf1b95d52dca8aa290bd4b83.php:312 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_6c470747856d93a62bdecc99eb9b570586026045a1c8a53098e676df4cd4130f->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()
  ...3176d4f4a5c5d68f761da4c83b2a39ac619a423.php:149 twig_include()
  vendor/twig/twig/src/Template.php:394              __TwigTemplate_e16cc0d180a6e8690c02d42d6e09dd222607f59b8508582007c04a8d557ae004->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()

cat files/_log/sql-errors.log

[2022-04-25 13:19:04] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 368
  *** MySQL query error:
  SQL: INSERT INTO `glpi_tickets_users` (`use_notification`, `alternative_email`, `tickets_id`, `users_id`, `type`) VALUES ('', '', '1', '2', '1')
  Error: Incorrect integer value: '' for column `glpidb`.`glpi_tickets_users`.`use_notification` at row 1
  Backtrace :
  src/DBmysql.php:1310                               
  src/CommonDBTM.php:682                             DBmysql->insert()
  src/CommonDBTM.php:1274                            CommonDBTM->addToDB()
  src/CommonITILObject.php:8389                      CommonDBTM->add()
  src/CommonITILObject.php:2498                      CommonITILObject->updateActors()
  src/Ticket.php:2130                                CommonITILObject->post_addItem()
  src/CommonDBTM.php:1275                            Ticket->post_addItem()
  front/ticket.form.php:72                           CommonDBTM->add()
  {"user":"2@srvglpi"} 
[2022-04-25 13:19:04] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 368
  *** MySQL query error:
  SQL: INSERT INTO `glpi_tickets_users` (`use_notification`, `alternative_email`, `tickets_id`, `users_id`, `type`) VALUES ('', '', '1', '2', '2')
  Error: Incorrect integer value: '' for column `glpidb`.`glpi_tickets_users`.`use_notification` at row 1
  Backtrace :
  src/DBmysql.php:1310                               
  src/CommonDBTM.php:682                             DBmysql->insert()
  src/CommonDBTM.php:1274                            CommonDBTM->addToDB()
  src/CommonITILObject.php:8389                      CommonDBTM->add()
  src/CommonITILObject.php:2498                      CommonITILObject->updateActors()
  src/Ticket.php:2130                                CommonITILObject->post_addItem()
  src/CommonDBTM.php:1275                            Ticket->post_addItem()
  front/ticket.form.php:72                           CommonDBTM->add()
  {"user":"2@srvglpi","mem_usage":"0.001\", 4.95Mio)"} 
[2022-04-25 13:23:57] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 402
  *** MySQL query warnings:
  SQL: SELECT * FROM `glpi_documents_items` WHERE (((`glpi_documents_items`.`itemtype` = 'Ticket' AND `glpi_documents_items`.`items_id` = '') OR (`glpi_documents_items`.`itemtype` = 'ITILFollowup' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilfollowups` WHERE `glpi_itilfollowups`.`itemtype` = 'Ticket' AND `glpi_itilfollowups`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'ITILSolution' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilsolutions` WHERE `glpi_itilsolutions`.`itemtype` = 'Ticket' AND `glpi_itilsolutions`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketValidation' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_ticketvalidations` WHERE `glpi_ticketvalidations`.`tickets_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketTask' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_tickettasks` WHERE `tickets_id` = '')))) AND `timeline_position` > '-1'
  Warnings: 
1292: Truncated incorrect DOUBLE value: ''
  Backtrace :
  src/DBmysqlIterator.php:108                        
  src/DBmysql.php:1046                               DBmysqlIterator->execute()
  src/CommonDBTM.php:540                             DBmysql->request()
  src/CommonITILObject.php:7125                      CommonDBTM->find()
  src/CommonITILObject.php:7433                      CommonITILObject->getTimelineItems()
  src/CommonGLPI.php:310                             CommonITILObject->addDefaultFormTab()
  src/CommonGLPI.php:882                             CommonGLPI->defineAllTabs()
  src/CommonGLPI.php:1169                            CommonGLPI->showTabsContent()
  src/CommonDBTM.php:6307                            CommonGLPI->display()
  front/ticket.form.php:288                          CommonDBTM::displayFullPageForItem()
  {"user":"7@srvglpi"} 
[2022-04-25 13:23:57] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 402
  *** MySQL query warnings:
  SQL: SELECT * FROM `glpi_documents_items` WHERE (((`glpi_documents_items`.`itemtype` = 'Ticket' AND `glpi_documents_items`.`items_id` = '') OR (`glpi_documents_items`.`itemtype` = 'ITILFollowup' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilfollowups` WHERE `glpi_itilfollowups`.`itemtype` = 'Ticket' AND `glpi_itilfollowups`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'ITILSolution' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilsolutions` WHERE `glpi_itilsolutions`.`itemtype` = 'Ticket' AND `glpi_itilsolutions`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketValidation' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_ticketvalidations` WHERE `glpi_ticketvalidations`.`tickets_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketTask' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_tickettasks` WHERE `tickets_id` = '')))) AND `timeline_position` > '-1'
  Warnings: 
1292: Truncated incorrect DOUBLE value: ''
  Backtrace :
  src/DBmysqlIterator.php:108                        
  src/DBmysql.php:1046                               DBmysqlIterator->execute()
  src/CommonDBTM.php:540                             DBmysql->request()
  src/CommonITILObject.php:7125                      CommonDBTM->find()
  src/CommonITILObject.php:7433                      CommonITILObject->getTimelineItems()
  src/CommonGLPI.php:310                             CommonITILObject->addDefaultFormTab()
  src/Toolbox.php:3392                               CommonGLPI->defineAllTabs()
  ajax/common.tabs.php:91                            Toolbox::getAvailablesTabs()
  {"user":"7@srvglpi"} 
[2022-04-25 13:23:58] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 402
  *** MySQL query warnings:
  SQL: SELECT * FROM `glpi_documents_items` WHERE (((`glpi_documents_items`.`itemtype` = 'Ticket' AND `glpi_documents_items`.`items_id` = '') OR (`glpi_documents_items`.`itemtype` = 'ITILFollowup' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilfollowups` WHERE `glpi_itilfollowups`.`itemtype` = 'Ticket' AND `glpi_itilfollowups`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'ITILSolution' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilsolutions` WHERE `glpi_itilsolutions`.`itemtype` = 'Ticket' AND `glpi_itilsolutions`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketValidation' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_ticketvalidations` WHERE `glpi_ticketvalidations`.`tickets_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketTask' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_tickettasks` WHERE `tickets_id` = '')))) AND `timeline_position` > '-1'
  Warnings: 
1292: Truncated incorrect DOUBLE value: ''
  Backtrace :
  src/DBmysqlIterator.php:108                        
  src/DBmysql.php:1046                               DBmysqlIterator->execute()
  src/CommonDBTM.php:540                             DBmysql->request()
  src/CommonITILObject.php:7125                      CommonDBTM->find()
  src/CommonITILObject.php:7433                      CommonITILObject->getTimelineItems()
  src/CommonGLPI.php:310                             CommonITILObject->addDefaultFormTab()
  src/Toolbox.php:3392                               CommonGLPI->defineAllTabs()
  ajax/updatecurrenttab.php:42                       Toolbox::getAvailablesTabs()
  {"user":"7@srvglpi"} 
[2022-04-25 13:43:08] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 402
  *** MySQL query warnings:
  SQL: SELECT * FROM `glpi_documents_items` WHERE (((`glpi_documents_items`.`itemtype` = 'Ticket' AND `glpi_documents_items`.`items_id` = '') OR (`glpi_documents_items`.`itemtype` = 'ITILFollowup' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilfollowups` WHERE `glpi_itilfollowups`.`itemtype` = 'Ticket' AND `glpi_itilfollowups`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'ITILSolution' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilsolutions` WHERE `glpi_itilsolutions`.`itemtype` = 'Ticket' AND `glpi_itilsolutions`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketValidation' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_ticketvalidations` WHERE `glpi_ticketvalidations`.`tickets_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketTask' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_tickettasks` WHERE `tickets_id` = '')))) AND `timeline_position` > '-1'
  Warnings: 
1292: Truncated incorrect DOUBLE value: ''
  Backtrace :
  src/DBmysqlIterator.php:108                        
  src/DBmysql.php:1046                               DBmysqlIterator->execute()
  src/CommonDBTM.php:540                             DBmysql->request()
  src/CommonITILObject.php:7125                      CommonDBTM->find()
  src/CommonITILObject.php:7433                      CommonITILObject->getTimelineItems()
  src/CommonGLPI.php:310                             CommonITILObject->addDefaultFormTab()
  src/CommonGLPI.php:882                             CommonGLPI->defineAllTabs()
  src/CommonGLPI.php:1169                            CommonGLPI->showTabsContent()
  src/CommonDBTM.php:6307                            CommonGLPI->display()
  front/ticket.form.php:288                          CommonDBTM::displayFullPageForItem()
  {"user":"7@srvglpi"} 
[2022-04-25 13:43:09] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 402
  *** MySQL query warnings:
  SQL: SELECT * FROM `glpi_documents_items` WHERE (((`glpi_documents_items`.`itemtype` = 'Ticket' AND `glpi_documents_items`.`items_id` = '') OR (`glpi_documents_items`.`itemtype` = 'ITILFollowup' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilfollowups` WHERE `glpi_itilfollowups`.`itemtype` = 'Ticket' AND `glpi_itilfollowups`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'ITILSolution' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilsolutions` WHERE `glpi_itilsolutions`.`itemtype` = 'Ticket' AND `glpi_itilsolutions`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketValidation' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_ticketvalidations` WHERE `glpi_ticketvalidations`.`tickets_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketTask' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_tickettasks` WHERE `tickets_id` = '')))) AND `timeline_position` > '-1'
  Warnings: 
1292: Truncated incorrect DOUBLE value: ''
  Backtrace :
  src/DBmysqlIterator.php:108                        
  src/DBmysql.php:1046                               DBmysqlIterator->execute()
  src/CommonDBTM.php:540                             DBmysql->request()
  src/CommonITILObject.php:7125                      CommonDBTM->find()
  src/CommonITILObject.php:7433                      CommonITILObject->getTimelineItems()
  src/CommonGLPI.php:310                             CommonITILObject->addDefaultFormTab()
  src/Toolbox.php:3392                               CommonGLPI->defineAllTabs()
  ajax/common.tabs.php:91                            Toolbox::getAvailablesTabs()
  {"user":"7@srvglpi"} 
[2022-04-25 13:43:09] glpisqllog.WARNING: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 402
  *** MySQL query warnings:
  SQL: SELECT * FROM `glpi_documents_items` WHERE (((`glpi_documents_items`.`itemtype` = 'Ticket' AND `glpi_documents_items`.`items_id` = '') OR (`glpi_documents_items`.`itemtype` = 'ITILFollowup' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilfollowups` WHERE `glpi_itilfollowups`.`itemtype` = 'Ticket' AND `glpi_itilfollowups`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'ITILSolution' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_itilsolutions` WHERE `glpi_itilsolutions`.`itemtype` = 'Ticket' AND `glpi_itilsolutions`.`items_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketValidation' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_ticketvalidations` WHERE `glpi_ticketvalidations`.`tickets_id` = '')) OR (`glpi_documents_items`.`itemtype` = 'TicketTask' AND `glpi_documents_items`.`items_id` IN (SELECT `id` FROM `glpi_tickettasks` WHERE `tickets_id` = '')))) AND `timeline_position` > '-1'
  Warnings: 
1292: Truncated incorrect DOUBLE value: ''
  Backtrace :
  src/DBmysqlIterator.php:108                        
  src/DBmysql.php:1046                               DBmysqlIterator->execute()
  src/CommonDBTM.php:540                             DBmysql->request()
  src/CommonITILObject.php:7125                      CommonDBTM->find()
  src/CommonITILObject.php:7433                      CommonITILObject->getTimelineItems()
  src/CommonGLPI.php:310                             CommonITILObject->addDefaultFormTab()
  src/Toolbox.php:3392                               CommonGLPI->defineAllTabs()
  ajax/updatecurrenttab.php:42                       Toolbox::getAvailablesTabs()
  {"user":"7@srvglpi"}
cconard96 commented 2 years ago

Can you check if #11380 fixes the issue at least for creating Tickets? It seems that if the Impact field is mandatory in the template, a typo would cause the rendering of at least part of the UI to fail.

DroidBV8 commented 2 years ago

Yeah the fix is good !!!

DroidBV8 commented 2 years ago

You are on the job I am very impressed with the speed of the response and fix

cconard96 commented 2 years ago

I don't think editing would be fixed by it, but is that working too or is there another issue?

DroidBV8 commented 2 years ago

@cconard96

When I said to edit, I rather meant the edition of the status of the ticket and not the subject of the ticket (it worked correctly)

godsom commented 2 years ago

@cconard96 I got quite same issue here after migration,show error at right panel Twig Error (Twig\Error\RuntimeError): "The merge filter only works with arrays or "Traversable", got "NULL" as first argument." in template "/var/www/html/glpi10/glpi/templates/components/itilobject/fields/priority_matrix.html.twig" at line 58 So it can troubleshoot by remove mandatory field = impact out of template.or fix soure code following your https://github.com/glpi-project/glpi/pull/11380