On Wed, Jul 10, 2024 at 1:36 PM <zoltan@circle-interactive.co.uk> wrote:
Thank you Mark!
I think I tracked down the related django error for that message. mailmanweb.log says
MySQLdb.OperationalError: (1366, "Incorrect string value: '\\xF0\\x9F\\x98\\x8A. ...' for column
mailmanweb.hyperkitty_email.contentat row 1")but collation is utf8mb4_general_ci on the table.
Do I need to maybe specify it in settings file?
Does your Django settings for the DATABASE look like the below?
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'DBNAME', # Example, change as needed 'USER': 'USER', 'PASSWORD': 'XXXXXXXXX', 'HOST': '127.0.0.1', 'PORT': '', 'OPTIONS': { 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'", 'charset': 'utf8mb4', }, } }
I think the OPTIONS bit was required to mitigate that error.
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]