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

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

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

4454 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

This question has been flagged