Error: Odoo Server Error Traceback (most recent call last): File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/api.py", line 1032, in get value = self._data[field][record.id][key] KeyError: During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/fields.py", line 970, in __get__ value = record.env.cache.get(rec

I need help .. Im using odoo 12 community version, in my CRM Email Marketing module when i click to create a mailing list it Shows following error :

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

All Posts People Badges

Tags (View all)

odoo v14 accounting v15 odoo16features

About this forum

Help

I need help .. Im using odoo 12 community version, in my CRM Email Marketing module when i click to create a mailing list it Shows following error :

2 Replies

4590 Views

Muhammad kamran

Error:

Odoo Server Error

Traceback (most recent call last):

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/api.py", line 1032, in get

value = self._data[field][record.id][key]

KeyError: <odoo.api.Environment object at 0x7f5d17520ef0>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/fields.py", line 970, in __get__

value = record.env.cache.get(record, self)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/api.py", line 1034, in get

raise CacheMiss(record, field)

odoo.exceptions.CacheMiss: ('mail.mass_mailing.list(1,).contact_nbr', None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/loglevels.py", line 92, in ustr

return text_type(value)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/tools/func.py", line 150, in __str__

def __str__(self): return str(self._value)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/tools/func.py", line 137, in _value

value = self._func(*self._args, **self._kwargs)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/tools/func.py", line 167, in __getitem__

def __getitem__(self, key): return self._value[key]

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/tools/func.py", line 137, in _value

value = self._func(*self._args, **self._kwargs)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/models.py", line 5640, in <lambda>

names = tools.lazy(lambda: dict(self.name_get()))

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/addons/mass_mailing/models/mass_mailing.py", line 132, in name_get

return [(list.id, "%s (%s)" % (list.name, list.contact_nbr)) for list in self]

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/addons/mass_mailing/models/mass_mailing.py", line 132, in <listcomp>

return [(list.id, "%s (%s)" % (list.name, list.contact_nbr)) for list in self]

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/fields.py", line 974, in __get__

self.determine_value(record)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/fields.py", line 1085, in determine_value

self.compute_value(recs)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/fields.py", line 1041, in compute_value

self._compute_value(records)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/fields.py", line 1032, in _compute_value

getattr(records, self.compute)()

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/addons/mass_mailing/models/mass_mailing.py", line 125, in _compute_contact_nbr

''')

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/sql_db.py", line 148, in wrapper

return f(self, *args, **kwargs)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/sql_db.py", line 225, in execute

res = self._obj.execute(query, params)

psycopg2.ProgrammingError: syntax error at or near "%"

LINE 7: ...in mail_blacklist bl on (LOWER(substring(c.email, %s)) = bl....

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/http.py", line 653, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/http.py", line 312, in _handle_exception

raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/tools/pycompat.py", line 87, in reraise

raise value

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/http.py", line 709, in dispatch

return self._json_response(result)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/http.py", line 641, in _json_response

body = json.dumps(response, default=date_utils.json_default)

File "/opt/bitnami/python/lib/python3.7/json/__init__.py", line 238, in dumps

**kw).encode(obj)

File "/opt/bitnami/python/lib/python3.7/json/encoder.py", line 199, in encode

chunks = self.iterencode(o, _one_shot=True)

File "/opt/bitnami/python/lib/python3.7/json/encoder.py", line 257, in iterencode

return _iterencode(o, 0)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/tools/date_utils.py", line 179, in json_default

return ustr(obj)

File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181118-py3.7.egg/odoo/loglevels.py", line 94, in ustr

raise UnicodeError('unable to convert %r' % (value,))

UnicodeError: unable to convert <odoo.tools.func.lazy object at 0x7f5d07f7dd38>

Yenthe Van Ginneken (Mainframe Monkey)

You might want to update your Odoo source code as it seems to work fine out of the box on the latest Odoo 12.

hakimtawerghi@gmail.com

i have same error , but i find the reason of this , is the indent of your function code:

def name_get(self):
    res = []
    for field in self:
        res.append((field.id,'%s -  %s' % (field.name_seq , field.patient_name)))
        # res.append((field.id, '%s' % field.name_seq))
        print(res)
    return res

and when you use this code bellow , you getting the error (look at return )

def name_get(self):
    res = []
    for field in self:
        res.append((field.id,'%s -  %s' % (field.name_seq , field.patient_name)))
        # res.append((field.id, '%s' % field.name_seq))
        print(res)
        return res

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

This question has been flagged

Enjoying the discussion? Don't just read, join in!