Backup status email template

[wf]

Hi,

Is there a way to amend the backup status email template so it does not include the nice images?

I import the backup status emails into our control panel and all import ok unless they are have the failure status siren which fails to import with an error message.

Error - OperationalError: (1366, "Incorrect string value: '\xF0\x9F\x9A\xA8' for column 'subject' at row 1")

Thanks

[olivierlambert]

Hi,

It's not an image but an emoji. Can you be more specific on the exact operation you did? Importing to what? (so we understand better the context)

[wf]

@olivierlambert

I am importing the emails into a control panel build using MySQL and Python/Django.

Upon importing the emails I get the error unless it is the sucess tick emoji.

query _mysql.connection.query(self, query)
django.db.utils.OperationalError: (1366, "Incorrect string value: '\xF0\x9F\x9A\xA8' for column 'subject' at row 1")

The error seems to only happens with the failure siren.

[olivierlambert]

Hmm I wonder, is your DB in UTF8 format?

[wf]

@olivierlambert

Yes it is.

Server charset: UTF-8 Unicode (utf8mb4)

[olivierlambert]

That's the right format, what about your Django app settings?

DATABASES = {
    'default': {
        'ENGINE':'django.db.backends.mysql',
        ...
        'OPTIONS': {'charset': 'utf8mb4'},
    }
}

edit: more details at https://dba.stackexchange.com/questions/161460/error-1366-incorrect-string-value-xf0-x9f-x98-x8a-x0ac-for-column-text-bo or https://stackoverflow.com/questions/63141740/django-db-utils-operationalerror-1366-incorrect-string-value-django-mysql for example

[wf]

@olivierlambert
Well spotted, I missed tht one.

All apprears to be importing, although I will find out properly if another backup one fails and the auto import rule runs through OK.

Thanks again.

[olivierlambert]

Great!