Skip to Content
This question has been flagged
2 Replies
5103 Zobrazenia
Avatar
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>

Avatar
Zrušiť
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.

Avatar
hakimtawerghi@gmail.com
Best Answer

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
Avatar
Zrušiť