Email Alert returning an error

Hi,

I’m using version 10.0.22 and am getting an error with email alerts not sending out. I’m using the alert to send me an update on when to follow up on a Lead. Here’s the output from the error log:

frappe.email.doctype.email_alert.email_alert.trigger_daily_alerts

{‘retry’: 0, ‘log’: <function log at 0x7ffaa1b79050>, ‘site’: u’site1.local’, ‘event’: u’daily’, ‘method_name’: u’frappe.email.doctype.email_alert.email_alert.trigger_daily_alerts’, ‘method’: <function trigger_daily_alerts at 0x7ffaa1b79f50>, ‘user’: u’Administrator’, ‘kwargs’: {}, ‘async’: True, ‘job_name’: u’frappe.email.doctype.email_alert.email_alert.trigger_daily_alerts’}
Traceback (most recent call last):
File “/home/malcolm_wilson/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 95, in execute_job
method(**kwargs)
File “/home/malcolm_wilson/frappe-bench/apps/frappe/frappe/email/doctype/email_alert/email_alert.py”, line 215, in trigger_daily_alerts
trigger_email_alerts(None, “daily”)
File “/home/malcolm_wilson/frappe-bench/apps/frappe/frappe/email/doctype/email_alert/email_alert.py”, line 227, in trigger_email_alerts
evaluate_alert(doc, alert, alert.event)
File “/home/malcolm_wilson/frappe-bench/apps/frappe/frappe/email/doctype/email_alert/email_alert.py”, line 266, in evaluate_alert
frappe.log_error(message=frappe.get_traceback(), title=e)
File “/home/malcolm_wilson/frappe-bench/apps/frappe/frappe/init.py”, line 1376, in log_error
method=title)).insert(ignore_permissions=True)
File “/home/malcolm_wilson/frappe-bench/apps/frappe/frappe/model/document.py”, line 230, in insert
self.db_insert()
File “/home/malcolm_wilson/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 303, in db_insert
), list(d.values()))
File “/home/malcolm_wilson/frappe-bench/apps/frappe/frappe/database.py”, line 166, in sql
self._cursor.execute(query, values)
File “/home/malcolm_wilson/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 163, in execute
query = self.mogrify(query, args)
File “/home/malcolm_wilson/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 142, in mogrify
query = query % self._escape_args(args, conn)
File “/home/malcolm_wilson/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 117, in _escape_args
return tuple(conn.literal(arg) for arg in args)
File “/home/malcolm_wilson/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 117, in
return tuple(conn.literal(arg) for arg in args)
File “/home/malcolm_wilson/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 819, in literal
return self.escape(obj, self.encoders)
File “/home/malcolm_wilson/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 812, in escape
return converters.escape_item(obj, self.charset, mapping=mapping)
File “/home/malcolm_wilson/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/converters.py”, line 27, in escape_item
val = encoder(val, mapping)
File “/home/malcolm_wilson/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/converters.py”, line 118, in escape_unicode
return u"‘%s’" % _escape_unicode(value)
File “/home/malcolm_wilson/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/converters.py”, line 73, in _escape_unicode
return value.translate(_escape_table)
AttributeError: ‘OutgoingEmailError’ object has no attribute ‘translate’

Welcome Winnipeg!

You seem to be caught up in some character mapping encoding translating limbo?

Maybe run ‘sudo apt-get update’ to see if that makes a difference.