In the support module, when assigning a ticket to a user the mail notification is not being sent.
I found these errors in the logs, maybe they are related?
Any help is greatly appreciated!
Thanks
Adrian
tail -n200 logs/worker.error.log
OperationalError: (1054, “Unknown column ‘everyone’ in ‘where clause’”)
[2015-11-13 15:40:29,315: WARNING/Worker-1] frappe.tasks.scheduler_task[50494d81-0412-4463-bb47-d6537f4ec9c6]: Method: all, Handler: frappe.email.bulk.flush
Traceback (innermost last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/tasks.py”, line 89, in scheduler_task
frappe.get_attr(handler)()
File “/home/frappe/frappe-bench/apps/frappe/frappe/email/bulk.py”, line 252, in flush
order by priority desc, creation asc limit 1 for update"“”, now_datetime(), as_dict=1)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 135, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, “Unknown column ‘priority’ in ‘order clause’”)
[2015-11-13 15:40:29,317: ERROR/MainProcess] Task frappe.tasks.scheduler_task[50494d81-0412-4463-bb47-d6537f4ec9c6] raised unexpected: OperationalError(1054, “Unknown column ‘priority’ in ‘order clause’”)
Traceback (most recent call last):
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/celery/app/trace.py”, line 240, in trace_task
R = retval = fun(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/celery/app/trace.py”, line 438, in protected_call
return self.run(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/tasks.py”, line 89, in scheduler_task
frappe.get_attr(handler)()
File “/home/frappe/frappe-bench/apps/frappe/frappe/email/bulk.py”, line 252, in flush
order by priority desc, creation asc limit 1 for update"“”, now_datetime(), as_dict=1)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 135, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, “Unknown column ‘priority’ in ‘order clause’”)