Closed michaelNFF closed 2 years ago
cconard96
commented
2 years ago I cannot recreate the issue with the comments being empty. I did confirm an issue with the KB linking.
Please provide the requested log output.
Specifically, entries from files/_log/php-errors.log and files/_log/sql-errors.log from around the time you experienced the issue.
michaelNFF
commented
2 years ago sql_errors.log
[2022-09-12 16:25:36] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTOglpi_itilfollowups(itemtype,items_id,content,requesttypes_id,is_private,users_id,timeline_position,date,date_creation,date_mod) VALUES ('Ticket', '9038', '<p>zdz</p>', '0', '', '1812', '4', '2022-09-12 16:25:36', '2022-09-12 16:25:36', '2022-09-12 16:25:36') Error: Incorrect integer value: '' for columnglpi.glpi_itilfollowups.is_privateat row 1 Backtrace : src/DBmysql.php:1312 src/CommonDBTM.php:705 DBmysql->insert() src/CommonDBTM.php:1304 CommonDBTM->addToDB() front/itilfollowup.form.php:55 CommonDBTM->add() {"user":"1812@nfmaglpi12"} [2022-09-12 16:26:22] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTOglpi_itilfollowups(itemtype,items_id,content,requesttypes_id,is_private,users_id,timeline_position,date,date_creation,date_mod) VALUES ('Ticket', '9038', '<p>----</p>', '0', '', '1812', '4', '2022-09-12 16:26:22', '2022-09-12 16:26:22', '2022-09-12 16:26:22') Error: Incorrect integer value: '' for columnglpi.glpi_itilfollowups.is_privateat row 1 Backtrace : src/DBmysql.php:1312 src/CommonDBTM.php:705 DBmysql->insert() src/CommonDBTM.php:1304 CommonDBTM->addToDB() front/itilfollowup.form.php:55 CommonDBTM->add() {"user":"1812@nfmaglpi12"}
php-errors.log stay empty
michaelNFF
commented
2 years ago Upgrade GLPI to 10.0.3 today
michaelNFF
commented
2 years ago This issue is solved by last GLPI version 10.0.3.
Good job.
Thanks.
Code of Conduct
Is there an existing issue for this?
Version
GLPI 10.0.2
Bug description
Hello,
No link between Knowledge base article and ticket solution. When I click on Use as a solution the comments solution field stay empty.
Regards
Relevant log output
No response
Page URL
No response
Steps To reproduce
No response
Your GLPI setup information
Informations sur le système, l'installation et la configuration
Server
Operating system: Linux nfmaglpi12 5.10.0-11-amd64 #1 SMP Debian 5.10.92-1 (2022-01-18) x86_64 PHP 7.4.25 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, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, 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.52 (Debian) (Apache/2.4.52 (Debian) Server at eoasis.novoferm.fr Port 443 ) Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36 Server Software: Debian 11 Server Version: 10.5.12-MariaDB-0+deb11u1 Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: root@localhost/glpi Host info: Localhost via UNIX socket PHP version (7.4.25) 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.12) 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 the files directory should not be allowed but this cannot be checked automatically on this instance. Make sure access to error log file (/files/_log/php-errors.log) is forbidden; otherwise review .htaccess file and web server configuration. 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
Libraries
LDAP directories
Server: 'ldap://nfmaldap11.novoferm.fr', Port: '389', BaseDN: 'dc=novosud,dc=fr', Connection filter: '(objectCategory=Person)', RootDN: 'cn=admin,dc=novosud,dc=fr', Use TLS: noneSQL replicas
Notifications
Plugins list
news Name: Alertes Version: 1.10.4 State: Enabled Install Method: Marketplace webapplications Name: Applications Web Version: 4.0.1 State: Enabled Install Method: Marketplace screenshot Name: Capture d'écran Version: 2.0.1 State: Installed / not activated Install Method: Marketplace printercounters Name: Compteurs Imprimantes Version: 2.0.0 State: Installed / not activated Install Method: Marketplace formcreator Name: Form Creator Version: 2.13.0-rc.2 State: Enabled Install Method: Marketplace glpiinventory Name: GLPI Inventory Version: 1.0.3 State: Enabled Install Method: Marketplace tasklists Name: Liste des tâches Version: 2.0.1 State: Enabled Install Method: Marketplace mreporting Name: Plus de rapports Version: 1.8.0 State: Enabled Install Method: MarketplaceAnything else?
No response