[12.0] mail_sent, psycopg2.ProgrammingError: column mail_message

[moblesmarti]

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! We accept bounties via Bountysource.

[moblesmarti]

when the mule is deactivated the error disappears...