Hi,
I get the following error (in Odoo log file) when a partner replies to an email sent from any Odoo form:
odoo14 odoo.sql_db: bad query: SELECT
"res_partner".id FROM "res_partner" WHERE
((("res_partner"."id" in (%s)) AND
("res_partner"."active" = %s)) AND
(("res_partner"."type" != %s) OR
"res_partner"."type" IS NULL)) ORDER BY
"res_partner"."display_name"
ERROR: can't adapt type
'res.partner'
2022-11-16 10:51:21,815 1 [1;32m[1;49mINFO[0m
odoo14 odoo.addons.fetchmail.models.fetchmail: Failed to process mail from imap
server myemailadress.
Traceback (most recent call
last):
File
"/usr/lib/python3/dist-packages/odoo/addons/fetchmail/models/fetchmail.py",
line 192, in fetch_mail
res_id =
MailThread.with_context(**additionnal_context).message_process(server.object_id.model,
data[0][1], save_original=server.original, strip_attachments=(not
server.attach))
File
"/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py",
line 1145, in message_process
thread_id =
self._message_route_process(message, msg_dict, routes)
File
"/usr/lib/python3/dist-packages/odoo/addons/mass_mailing/models/mail_thread.py",
line 28, in _message_route_process
return
super(MailThread, self)._message_route_process(message, message_dict, routes)
File
"/mnt/extra-addons/mail_tracking/models/mail_thread.py", line 45, in
_message_route_process
return
super()._message_route_process(message, message_dict, routes)
File
"/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py",
line 1056, in _message_route_process
thread =
ModelCtx.message_new(message_dict, custom_values)
File
"/mnt/extra-addons/helpdesk_mgmt/models/helpdesk_ticket.py", line
221, in message_new
ticket.message_subscribe(partner_ids)
File
"/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py",
line 2714, in message_subscribe
partner_ids =
self.env['res.partner'].sudo().search([('id', 'in', partner_ids), ('active',
'=', True), ('type', '!=', 'private')]).ids
File
"/mnt/extra-addons/partner_multi_relation/models/res_partner.py",
line 169, in search
count=count,
File "/mnt/extra-addons/partner_contact_in_several_companies/models/res_partner.py",
line 71, in search
args, offset=offset,
limit=limit, order=order, count=count
File
"/usr/lib/python3/dist-packages/odoo/models.py", line 1709, in search
return res if count
else self.browse(res)
File
"/usr/lib/python3/dist-packages/odoo/models.py", line 4982, in browse
if not ids:
File
"/usr/lib/python3/dist-packages/odoo/osv/query.py", line 172, in
__bool__
return
bool(self._result)
File
"/usr/lib/python3/dist-packages/odoo/tools/func.py", line 26, in
__get__
value = self.fget(obj)
File
"/usr/lib/python3/dist-packages/odoo/osv/query.py", line 165, in
_result
self._cr.execute(query_str,
params)
File
"/mnt/extra-addons/slow_statement_logger/__init__.py", line 38, in
execute
return
super().execute(query, params, log_exceptions)
File
"", line 2, in execute
File
"/usr/lib/python3/dist-packages/odoo/sql_db.py", line 101, in check
return f(self, *args,
**kwargs)
File
"/usr/lib/python3/dist-packages/odoo/sql_db.py", line 300, in execute
res =
self._obj.execute(query, params)
psycopg2.ProgrammingError:
can't adapt type 'res.partner'
2022-11-16 10:51:22,011 1 [1;32m[1;49mINFO[0m
odoo14 odoo.addons.fetchmail.models.fetchmail: Fetched 1 email(s) on imap
server myemailaddress; 0 succeeded, 1 failed.
I tried uninstalling the modules " partner_contact_in_several_companies " and " partner_multi_relation " but it is the same.
Help would be appreciated.
Regards
Yves
