Hello community,
since the update to version 11, no more automatic notifications of reminders are sent.
The first entry in the error log is this entry:
Traceback (most recent call last):
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/email/doctype/notification/notification.py”, line 305, in evaluate_alert_
_ alert.send(doc)_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/email/doctype/notification/notification.py”, line 119, in send_
_ self.send_an_email(doc, context)_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/email/doctype/notification/notification.py”, line 135, in send_an_email_
_ attachments = self.get_attachment(doc)_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/email/doctype/notification/notification.py”, line 222, in get_attachment_
_ if self.print_format else ‘en’_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 484, in get_value_
_ order_by, cache=cache)_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 528, in get_values_
_ out = self.get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update)
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 670, in get_values_from_table
_ as_dict=as_dict, debug=debug, update=update)_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 199, in sql_
_ self.cursor.execute(query, values)
_ File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 170, in execute_
_ result = self.query(query)
_ File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 328, in query
_ conn.query(q)_
_ File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 516, in query_
_ self.affected_rows = self.read_query_result(unbuffered=unbuffered)
_ File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 727, in read_query_result
_ result.read()
_ File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1066, in read_
_ first_packet = self.connection.read_packet()
_ File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 683, in read_packet
_ packet.check_error()_
_ File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/protocol.py”, line 220, in check_error_
_ err.raise_mysql_exception(self.data)
_ File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception_
_ raise errorclass(errno, errval)_
InternalError: (1054, u"Unknown column ‘default_print_language’ in ‘field list’")
The second entry in the errorlog seems to be a consequence of the first one. Both entries in the error log have the same time and date.
{‘event’: u’daily’, ‘retry’: 0, ‘log’: <function log at 0x7f9b8961e050>, ‘site’: u’erpn.lixtherm.ch’, ‘job_name’: u’frappe.email.doctype.notification.notification.trigger_daily_alerts’, ‘method_name’: u’frappe.email.doctype.notification.notification.trigger_daily_alerts’, ‘method’: <function trigger_daily_alerts at 0x7f9b8961ed70>, ‘user’: u’Administrator’, ‘kwargs’: {}, ‘is_async’: True}
Traceback (most recent call last):
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 103, in execute_job_
_ method(**kwargs)_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/email/doctype/notification/notification.py”, line 259, in trigger_daily_alerts_
_ trigger_notifications(None, “daily”)_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/email/doctype/notification/notification.py”, line 271, in trigger_notifications_
_ evaluate_alert(doc, alert, alert.event)_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/email/doctype/notification/notification.py”, line 310, in evaluate_alert_
_ frappe.throw((“Error in Notification”))
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 353, in throw_
_ msgprint(msg, raise_exception=exc, title=title, indicator=‘red’)_
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 339, in msgprint_
_ raise_exception()
_ File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 312, in raise_exception
_ raise raise_exception(msg)_
ValidationError: Error in Notification
Is it sufficient to create the column default_print_language in the field list?
Our version:
ERPNext: v11.1.14 (master)
Frappe Framework: v11.1.14 (master)
Best regards
neacal