odoo 12 - el tpv no fuciona da error y no registra en el servidor y se queda la luz roja

[Fernando Garcia Hansen - Humanoide]

Hola a todos,

En un odoo 12 el tpv no fuciona da error y no registra en el servidor y se queda la luz roja.

El error salta cuando se va a registrar la venta después de imprimir el tiket

adjunto abajo el error por si alguien sabe interpretarlo y el mensaje dice lo que está mal.

  File "/opt/odoo/odoo-server/odoo/tools/pycompat.py", line 87, in reraise

    raise value

  File "/opt/odoo/odoo-server/odoo/http.py", line 698, in dispatch

    result = self._call_function(**self.params)

  File "/opt/odoo/odoo-server/odoo/http.py", line 346, in _call_function

    return checked_call(self.db, *args, **kwargs)

  File "/opt/odoo/odoo-server/odoo/service/model.py", line 98, in wrapper

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

  File "/opt/odoo/odoo-server/odoo/http.py", line 339, in checked_call

    result = self.endpoint(*a, **kw)

  File "/opt/odoo/odoo-server/odoo/http.py", line 941, in __call__

    return self.method(*args, **kw)

  File "/opt/odoo/odoo-server/odoo/http.py", line 519, in response_wrap

    response = f(*args, **kw)

  File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 963, in call_kw

    return self._call_kw(model, method, args, kwargs)

  File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 955, in _call_kw

    return call_kw(request.env[model], method, args, kwargs)

  File "/opt/odoo/odoo-server/odoo/api.py", line 755, in call_kw

    return _call_kw_model(method, model, args, kwargs)

  File "/opt/odoo/odoo-server/odoo/api.py", line 728, in _call_kw_model

    result = method(recs, *args, **kwargs)

  File "/opt/odoo/pos/pos_invoice_send_mail/models/pos_order.py", line 21, in create_from_ui

    order.config_id.iface_invoice_mail

  File "/opt/odoo/odoo-server/odoo/fields.py", line 1036, in __get__

    self.determine_value(record)

  File "/opt/odoo/odoo-server/odoo/fields.py", line 1149, in determine_value

    self.compute_value(recs)

  File "/opt/odoo/odoo-server/odoo/fields.py", line 1103, in compute_value

    self._compute_value(records)

  File "/opt/odoo/odoo-server/odoo/fields.py", line 1096, in _compute_value

    self.compute(records)

  File "/opt/odoo/odoo-server/odoo/fields.py", line 646, in _compute_related

    values = [first(value[name]) for value in values]

  File "/opt/odoo/odoo-server/odoo/fields.py", line 646, in <listcomp>

    values = [first(value[name]) for value in values]

  File "/opt/odoo/odoo-server/odoo/models.py", line 5167, in __getitem__

    return self._fields[key].__get__(self, type(self))

  File "/opt/odoo/odoo-server/odoo/fields.py", line 1036, in __get__

    self.determine_value(record)

  File "/opt/odoo/odoo-server/odoo/fields.py", line 1139, in determine_value

    record._prefetch_field(self)

  File "/opt/odoo/odoo-server/odoo/models.py", line 2880, in _prefetch_field

    result = records.read([f.name for f in fs], load='_classic_write')

  File "/opt/odoo/odoo-server/odoo/models.py", line 2818, in read

    self._read_from_database(stored, inherited)

  File "/opt/odoo/odoo-server/odoo/models.py", line 2945, in _read_from_database

    cr.execute(query_str, params)

  File "/opt/odoo/odoo-server/odoo/sql_db.py", line 148, in wrapper

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

  File "/opt/odoo/odoo-server/odoo/sql_db.py", line 225, in execute

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

psycopg2.DataError: invalid input syntax for type integer: "invoices"

LINE 1: ...ser_id" FROM "pos_order" WHERE "pos_order".id IN ('invoices'...

                                                             ^

[Fernando Garcia Hansen - Humanoide]

Era un problema con el módulo que envía mail desde el pos. Una vez desinstalado este, dejó de dar el error.