On 08.08.2019 03:19, Abhilash Raj wrote:
On Wed, Aug 7, 2019, at 3:50 AM, Marvin Gülker wrote:
Am 07. August 2019 um 11:57 Uhr +0200 schrieb Lars Schimmer:
OperationalError at /hyperkitty/api/mailman/archive (1366, "Incorrect string value: '\\xF0\\x9F\\x8D\\x8E' for column
mailman3web.hyperkitty_email.subjectat row 1")[...] Has anyone a idea what went wrong or howto fix it?
U+1F34E RED APPLE (which is what the string value above evaluates to in UTF-8) is not a valid e-mail address. If you didn't create user accounts via another way than the Hyperkitty UI, this looks like a bug in Hyperkitty's e-mail validator to me. Such a value should never have entered the database.
It is not in the database, the exception originates from Mailman Core trying to archive a message coming from this sender and Hyperkitty failing to archive the message.
This should have been handled properly and a better exception message should have been raised instead of this error traceback.
Can you open a bug report about this Hyperkitty's issue tracker?
https://gitlab.com/mailman/hyperkitty/issues
It is issue #248 now.
Maybe you can delete the user with that "e-mail address" with your DB's command line tool.
Marvin
-- Blog: https://mg.guelker.eu
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
MfG, Lars Schimmer
TU Graz, Institut für ComputerGraphik & WissensVisualisierung Tel: +43 316 873-5405 E-Mail: l.schimmer@cgv.tugraz.at Fax: +43 316 873-5402 PGP-Key-ID: 0x4A9B1723