Hi everyone,

I am on odoo 12, configured IMAP address to send emails out, it works for a few cases (like inviting a user to the platform from settings) but the rest of the time it doesn't:

• Assignment of user to an order

• Sending out an invoice to a client

• sending out a quote/order to a client

• 
  

Here is a sample of an error I got when I go to the email queue where all the emails appear red:

Odoo Server Error

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1032, in get
    value = self._data[field][record.id][key]
KeyError: (<odoo.sql_db.Cursor object at 0x0708AFF0>, 2)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 970, in __get__
    value = record.env.cache.get(record, self)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1034, in get
    raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('mail.mail(17,).mail_server_id', None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1032, in get
    value = self._data[field][record.id][key]
KeyError: (<odoo.sql_db.Cursor object at 0x0708AFF0>, 2)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 970, in __get__
    value = record.env.cache.get(record, self)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1034, in get
    raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('mail.message(124,).mail_server_id', None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 653, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 312, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\pycompat.py", line 87, in reraise
    raise value
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 695, in dispatch
    result = self._call_function(**self.params)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 344, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\service\model.py", line 97, in wrapper
    return f(dbname, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 337, in checked_call
    result = self.endpoint(*a, **kw)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 938, in __call__
    return self.method(*args, **kw)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 517, in response_wrap
    response = f(*args, **kw)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\addons\web\controllers\main.py", line 966, in call_button
    action = self._call_kw(model, method, args, {})
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\addons\web\controllers\main.py", line 954, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 749, in call_kw
    return _call_kw_multi(method, model, args, kwargs)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 736, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\addons\mail\models\mail_mail.py", line 235, in send
    for server_id, batch_ids in self._split_by_server():
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\addons\mail\models\mail_mail.py", line 212, in _split_by_server
    groups[mail.mail_server_id.id].append(mail.id)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 974, in __get__
    self.determine_value(record)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1085, in determine_value
    self.compute_value(recs)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1041, in compute_value
    self._compute_value(records)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1034, in _compute_value
    self.compute(records)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 608, in _compute_related
    record[self.name] = value[self.related_field.name]
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 5047, in __getitem__
    return self._fields[key].__get__(self, type(self))
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 974, in __get__
    self.determine_value(record)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1075, in determine_value
    record._prefetch_field(self)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2813, in _prefetch_field
    result = records.read([f.name for f in fs], load='_classic_write')
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\addons\mail\models\mail_message.py", line 986, in read
    self.check_access_rule('read')
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\addons\website_mail\models\mail_message.py", line 58, in check_access_rule
    return super(MailMessage, self).check_access_rule(operation=operation)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\addons\mail\models\mail_message.py", line 871, in check_access_rule
    self.env['mail.thread'].check_mail_message_access(mids.ids, operation, model_name=model)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\addons\mail\models\mail_thread.py", line 501, in check_mail_message_access
    DocModel.browse(res_ids).check_access_rule(check_operation)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 3007, in check_access_rule
    invalid = self - self._filter_access_rules(operation)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 3042, in _filter_access_rules
    self._cr.execute(query, (tuple(self.ids), self._uid))
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 148, in wrapper
    return f(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 225, in execute
    res = self._obj.execute(query, params)
psycopg2.ProgrammingError: syntax error at or near ")"
LINE 1: SELECT id FROM portal_wizard_user WHERE id IN () AND create_...
                                                       ^