Skip to content

GLPI 11.0.1 : Collector mail error charset #21540

@picinformatique

Description

@picinformatique

Code of Conduct

  • I agree to follow this project's Code of Conduct

Is there an existing issue for this?

  • I have searched the existing issues

Version

11.0.1

Bug description

Hello,

I've been getting an error since updating glpi, when my mail collector retrieves certain DMARC emails (yahoo.com).

I'm attaching the .eml file.

Do you have a solution?

[Externe]Report Domain Submitter yahoo.fr Report-ID 1760751944.336174.eml

Relevant log output

glpi.ERROR:   *** Caught RuntimeException: MySQL query error: Incorrect string value: '\xE8ces j...' for column `glpi`.`glpi_tickets`.`content` at row 1 (1366) in SQL query "INSERT INTO `glpi_tickets` (`date`, `name`, `content`, `urgency`, `requesttypes_id`, `entities_id`, `status`, `impact`, `priority`, `itilcategories_id`, `global_validation`, `type`, `date_creation`, `date_mod`) VALUES ('2025-10-18 12:53:50', '[Externe]Report Domain: pharmaciedurondpointcorte.com Submitter: yahoo.fr Report-ID: <1760751944.336174>', 'ATTENTION: Ne cliquez pas sur les liens ou n\'ouvrez pas les pi▒ces jointes si vous n\'▒tes pas s▒r du contenu.\n\'\n\nThis is an aggregate DMARC report from Yahoo for your domain \"pharmaciedurondpointcorte.com\".\n\nThis domain has a DMARC record set up. You are receiving this report because your email address is included in the \'rua\' tag which is part of that DMARC record. DMARC is set up in the DNS settings of your domain.\n\nIf you have questions about DMARC, please refer to the DMARC.org website, or contact your email service or hosting provider.\n\nIf you no longer wish to receive these reports, or if you would like them to be sent to a different location, please update the \'rua\' tag of the DMARC record of your domain. To do this please contact your email, domain or hosting provider. Please do not contact us as we will not be able to help you with updates to the DNS settings of your domain.\n\nPlease note that this email address is not monitored, and you will not receive a response if you reply to this email. For any feedback or questions, please reach out to dmarchelp@yahooinc.com.\n\nDocument joint incorrect : msg_1_externe-report-domain-pharmaciedurondpointcorte.com-submitter-yahoo.fr-report-id-1760751944.336174.EML (text/plain)', '3', '2', '0', '1', '3', '3', '0', '1', '1', '2025-10-18 21:55:01', '2025-10-18 21:55:01')".
  Backtrace :
  ./src/DBmysql.php:371
  ./src/DBmysql.php:1327                             DBmysql->doQuery()
  ./src/CommonDBTM.php:775                           DBmysql->insert()
  ./src/CommonDBTM.php:1380                          CommonDBTM->addToDB()
  ./src/MailCollector.php:773                        CommonDBTM->add()
  ./src/MailCollector.php:1813                       MailCollector->collect()
  ./src/CronTask.php:885                             MailCollector::cronMailgate()
  ./front/cron.php:130                               CronTask::launch()

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions