search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.29k stars 2.74k forks source link

Email Collector php class fetch funtionality does not work #24548

Closed kilian099 closed 1 year ago

kilian099 commented 1 year ago

Bug

Menu manager: eldy_menu.php

Modules/Applications: user, syslog, emailcollector, mailing, stripe, clicktodial, externalsite, cron, notification, printing, debugbar, blockedlog, adherent, contrat, partnership, holiday, expensereport, ficheinter, recruitment, multicurrency, facture, export, banque, tax, hrm, salaries, loan, prelevement, propal, paymentbybanktransfer, fournisseur, societe, commande, expedition, margin, knowledgemanagement, product, comptabilite, service, projet, eventorganization, agenda, categorie, ecm, website, fckeditor, ticket, opensurvey XDebug informations: File: crm-erp/htdocs/emailcollector/class/emailcollector.class.php Line: 2531 Function: fetch

Environment Version

Dolibarr: 17.0.0

Environment OS

Rocky Linux

Environment Web server

LiteSpeed

Environment PHP

7.4.33

Environment Database

mySQL

Environment URL(s)

htdocs/emailcollector/class/emailcollector.class.php

Expected and actual behavior

It Seems when I press test collector for collecting emails, it gives me an error:

Failed to create ticket: Error Incorrect string value: '\xEF\xBF\xBD Bo...' for column admin_dolibarr.llx_ticket.message at row 1

and I suspect, following other articles my DB is not reading emojis. However, I set the collation to all my tables into utf8mb4_unicode_ci and still the issue persist

Steps to reproduce the behavior

Clicking Test email collector

Attached files

No response

frederic34 commented 1 year ago

https://github.com/Dolibarr/dolibarr/pull/24561

there is also a repair script at install/repair.php?force_utf8mb4_on_tables=confirmed