With the last update of Sentbox when trying to mark as done a planned activity the following error appears:
Odoo Server Error
Traceback (most recent call last):
File "/opt/odoo/odoo/api.py", line 1039, in get
value = self._data[key][field][record._ids[0]]
KeyError: 23
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/odoo/odoo/fields.py", line 981, in get
value = record.env.cache.get(record, self)
File "/opt/odoo/odoo/api.py", line 1041, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('mail.compose.message(23,).sent', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/odoo/odoo/api.py", line 1039, in get
value = self._data[key][field][record._ids[0]]
KeyError: 23
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/odoo/odoo/fields.py", line 981, in get
value = record.env.cache.get(record, self)
File "/opt/odoo/odoo/api.py", line 1041, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('mail.compose.message(23,).channel_ids', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/odoo/odoo/http.py", line 656, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo/odoo/http.py", line 314, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "/opt/odoo/odoo/tools/pycompat.py", line 87, in reraise
raise value
File "/opt/odoo/odoo/http.py", line 698, in dispatch
result = self._call_function(self.params)
File "/opt/odoo/odoo/http.py", line 346, in _call_function
return checked_call(self.db, *args, *kwargs)
File "/opt/odoo/odoo/service/model.py", line 97, in wrapper
return f(dbname, args, kwargs)
File "/opt/odoo/odoo/http.py", line 339, in checked_call
result = self.endpoint(*a, kw)
File "/opt/odoo/odoo/http.py", line 941, in call
return self.method(*args, *kw)
File "/opt/odoo/odoo/http.py", line 519, in response_wrap
response = f(args, kw)
File "/opt/odoo/addons/web/controllers/main.py", line 962, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/opt/odoo/addons/web/controllers/main.py", line 954, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/opt/odoo/odoo/api.py", line 749, in call_kw
return _call_kw_multi(method, model, args, kwargs)
File "/opt/odoo/odoo/api.py", line 736, in _call_kw_multi
result = method(recs, *args, kwargs)
File "/opt/odoo/addons/calendar/models/mail_activity.py", line 34, in action_feedback
res = super(MailActivity, self).action_feedback(feedback)
File "/opt/odoo/addons/mail/models/mail_activity.py", line 374, in action_feedback
mail_activity_type_id=activity.activity_type_id.id,
File "/opt/odoo/addons/mail/models/mail_thread.py", line 2119, in message_post_with_view
record.message_post_with_template(False, kwargs)
File "/opt/odoo/addons/mass_mailing/models/mail_thread.py", line 54, in message_post_with_template
return super(MailThread, no_massmail).message_post_with_template(template_id, *kwargs)
File "/opt/odoo/addons/mail/models/mail_thread.py", line 2146, in message_post_with_template
).create(kwargs)
File "</usr/local/lib/python3.6/dist-packages/decorator.py:decorator-gen-122>", line 2, in create
File "/opt/odoo/odoo/api.py", line 430, in _model_create_single
return create(self, arg)
File "/opt/odoo/addons/mail/models/mail_message.py", line 988, in create
message = super(Message, self).create(values)
File "</usr/local/lib/python3.6/dist-packages/decorator.py:decorator-gen-3>", line 2, in create
File "/opt/odoo/odoo/api.py", line 451, in _model_create_multi
return create(self, [arg])
File "/opt/odoo/odoo/models.py", line 3607, in create
self.recompute()
File "/opt/odoo/odoo/models.py", line 5270, in recompute
vals = {n: rec[n] for n in ns}
File "/opt/odoo/odoo/models.py", line 5270, in
vals = {n: rec[n] for n in ns}
File "/opt/odoo/odoo/models.py", line 5117, in getitem
return self._fields[key].get(self, type(self))
File "/opt/odoo/odoo/fields.py", line 985, in get
self.determine_value(record)
File "/opt/odoo/odoo/fields.py", line 1074, in determine_value
self.compute_value(recs)
File "/opt/odoo/odoo/fields.py", line 1052, in compute_value
self._compute_value(records)
File "/opt/odoo/odoo/fields.py", line 1043, in _compute_value
getattr(records, self.compute)()
File "/opt/odoo/mail-addons/mail_sent/models.py", line 23, in _compute_sent
len(r_sudo.channel_ids)
File "/opt/odoo/odoo/fields.py", line 985, in get
self.determine_value(record)
File "/opt/odoo/odoo/fields.py", line 1088, in determine_value
record._prefetch_field(self)
File "/opt/odoo/odoo/models.py", line 2836, in _prefetch_field
result = records.read([f.name for f in fs], load='_classic_write')
File "/opt/odoo/addons/mail/models/mail_message.py", line 1011, in read
return super(Message, self).read(fields=fields, load=load)
File "/opt/odoo/odoo/models.py", line 2774, in read
self._read_from_database(stored, inherited)
File "/opt/odoo/odoo/models.py", line 2935, in _read_from_database
field.read(fetched)
File "/opt/odoo/odoo/fields.py", line 2676, in read
records._cr.execute(query, where_params)
File "/opt/odoo/odoo/sql_db.py", line 148, in wrapper
return f(self, args, **kwargs)
File "/opt/odoo/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError: column mail_message_mail_channel_rel.mail_compose_message_id does not exist
LINE 1: SELECT mail_message_mail_channel_rel.mail_compose_message_i...
^
Thanks,
---
Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/77784182-12-0-mail_sent-psycopg2-programmingerror-column-mail_message?utm_campaign=plugin&utm_content=tracker%2F24901677&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F24901677&utm_medium=issues&utm_source=github).
With the last update of Sentbox when trying to mark as done a planned activity the following error appears: Odoo Server Error
Traceback (most recent call last): File "/opt/odoo/odoo/api.py", line 1039, in get value = self._data[key][field][record._ids[0]] KeyError: 23
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/opt/odoo/odoo/fields.py", line 981, in get value = record.env.cache.get(record, self) File "/opt/odoo/odoo/api.py", line 1041, in get raise CacheMiss(record, field) odoo.exceptions.CacheMiss: ('mail.compose.message(23,).sent', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/opt/odoo/odoo/api.py", line 1039, in get value = self._data[key][field][record._ids[0]] KeyError: 23
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/opt/odoo/odoo/fields.py", line 981, in get value = record.env.cache.get(record, self) File "/opt/odoo/odoo/api.py", line 1041, in get raise CacheMiss(record, field) odoo.exceptions.CacheMiss: ('mail.compose.message(23,).channel_ids', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/opt/odoo/odoo/http.py", line 656, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/opt/odoo/odoo/http.py", line 314, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/opt/odoo/odoo/tools/pycompat.py", line 87, in reraise raise value File "/opt/odoo/odoo/http.py", line 698, in dispatch result = self._call_function(self.params) File "/opt/odoo/odoo/http.py", line 346, in _call_function return checked_call(self.db, *args, *kwargs) File "/opt/odoo/odoo/service/model.py", line 97, in wrapper return f(dbname, args, kwargs) File "/opt/odoo/odoo/http.py", line 339, in checked_call result = self.endpoint(*a, kw) File "/opt/odoo/odoo/http.py", line 941, in call return self.method(*args, *kw) File "/opt/odoo/odoo/http.py", line 519, in response_wrap response = f(args, kw) File "/opt/odoo/addons/web/controllers/main.py", line 962, in call_kw return self._call_kw(model, method, args, kwargs) File "/opt/odoo/addons/web/controllers/main.py", line 954, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/odoo/odoo/api.py", line 749, in call_kw return _call_kw_multi(method, model, args, kwargs) File "/opt/odoo/odoo/api.py", line 736, in _call_kw_multi result = method(recs, *args, kwargs) File "/opt/odoo/addons/calendar/models/mail_activity.py", line 34, in action_feedback res = super(MailActivity, self).action_feedback(feedback) File "/opt/odoo/addons/mail/models/mail_activity.py", line 374, in action_feedback mail_activity_type_id=activity.activity_type_id.id, File "/opt/odoo/addons/mail/models/mail_thread.py", line 2119, in message_post_with_view record.message_post_with_template(False, kwargs) File "/opt/odoo/addons/mass_mailing/models/mail_thread.py", line 54, in message_post_with_template return super(MailThread, no_massmail).message_post_with_template(template_id, *kwargs) File "/opt/odoo/addons/mail/models/mail_thread.py", line 2146, in message_post_with_template ).create(kwargs) File "</usr/local/lib/python3.6/dist-packages/decorator.py:decorator-gen-122>", line 2, in create File "/opt/odoo/odoo/api.py", line 430, in _model_create_single return create(self, arg) File "/opt/odoo/addons/mail/models/mail_message.py", line 988, in create message = super(Message, self).create(values) File "</usr/local/lib/python3.6/dist-packages/decorator.py:decorator-gen-3>", line 2, in create File "/opt/odoo/odoo/api.py", line 451, in _model_create_multi return create(self, [arg]) File "/opt/odoo/odoo/models.py", line 3607, in create self.recompute() File "/opt/odoo/odoo/models.py", line 5270, in recompute vals = {n: rec[n] for n in ns} File "/opt/odoo/odoo/models.py", line 5270, in
vals = {n: rec[n] for n in ns}
File "/opt/odoo/odoo/models.py", line 5117, in getitem
return self._fields[key].get(self, type(self))
File "/opt/odoo/odoo/fields.py", line 985, in get
self.determine_value(record)
File "/opt/odoo/odoo/fields.py", line 1074, in determine_value
self.compute_value(recs)
File "/opt/odoo/odoo/fields.py", line 1052, in compute_value
self._compute_value(records)
File "/opt/odoo/odoo/fields.py", line 1043, in _compute_value
getattr(records, self.compute)()
File "/opt/odoo/mail-addons/mail_sent/models.py", line 23, in _compute_sent
len(r_sudo.channel_ids)
File "/opt/odoo/odoo/fields.py", line 985, in get
self.determine_value(record)
File "/opt/odoo/odoo/fields.py", line 1088, in determine_value
record._prefetch_field(self)
File "/opt/odoo/odoo/models.py", line 2836, in _prefetch_field
result = records.read([f.name for f in fs], load='_classic_write')
File "/opt/odoo/addons/mail/models/mail_message.py", line 1011, in read
return super(Message, self).read(fields=fields, load=load)
File "/opt/odoo/odoo/models.py", line 2774, in read
self._read_from_database(stored, inherited)
File "/opt/odoo/odoo/models.py", line 2935, in _read_from_database
field.read(fetched)
File "/opt/odoo/odoo/fields.py", line 2676, in read
records._cr.execute(query, where_params)
File "/opt/odoo/odoo/sql_db.py", line 148, in wrapper
return f(self, args, **kwargs)
File "/opt/odoo/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError: column mail_message_mail_channel_rel.mail_compose_message_id does not exist
LINE 1: SELECT mail_message_mail_channel_rel.mail_compose_message_i...
^
Thanks,