Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
2 Odgovori
13509 Prikazi
Avatar
ahmed 
Traceback (most recent call last):
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\http.py", line 1579, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\service\model.py", line 134, in retrying
    result = func()
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\http.py", line 1608, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\http.py", line 1805, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\addons\base\models\ir_http.py", line 144, in _dispatch
    result = endpoint(**request.params)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\http.py", line 698, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\addons\web\controllers\dataset.py", line 42, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\addons\web\controllers\dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\api.py", line 457, in call_kw
    result = _call_kw_model(method, model, args, kwargs)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\api.py", line 430, in _call_kw_model
    result = method(recs, *args, **kwargs)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\models.py", line 1634, in name_search
    return self.browse(ids).sudo().name_get()
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\addons\product\models\product_product.py", line 435, in name_get
    self.sudo().read(['name', 'default_code', 'product_tmpl_id'], load=False)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\models.py", line 2992, in read
    self._read(stored_fields)
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\models.py", line 3235, in _read
    cr.execute(query_str, params + [sub_ids])
  File "C:\Program Files\Odoo 16.0.20230115\server\odoo\sql_db.py", line 315, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: operator does not exist: integer = record
LINE 1: ...FROM "product_product" WHERE "product_product".id IN ((3904,...
                                                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.


The above server error caused the following client error:
RPC_ERROR: Odoo Server Error
    at makeErrorFromResponse (http://192.168.0.102:8069/web/assets/297-4e0fedd/web.assets_backend.min.js:969:163)
    at XMLHttpRequest. (http://192.168.0.102:8069/web/assets/297-4e0fedd/web.assets_backend.min.js:976:13)


Avatar
Opusti
Avatar
S.M Firoz Ahmed ( Daffodil Software Limited )
Best Answer

The error message you provided is related to a database query that is trying to compare an integer value to a record value, which is not allowed. It seems that there is an issue in the "name_search" method of the "product_product" model, specifically in the query that is trying to read the name, default_code, and product_tmpl_id fields of the product products.

It is likely that the problem is caused by a custom code or a third-party module that is modifying the behavior of the "name_search" method, and it could be a typo or a bug in that code.

To resolve this issue, you can try the following steps:

Check your custom code and third-party modules for any modifications to the "product_product" model, and look for any issues or bugs that might be causing this problem.

If you find any custom code or third-party modules that might be causing the issue, you can try disabling or uninstalling them to see if the problem is resolved.


Avatar
Opusti
Avatar
Derek Wolfson
Best Answer

I have this same issue -- and I am using plain vanilla enterprise Odoo hosted on their servers.

What gives?  I cannot click on the "more" button in my general ledger -- it's quite annoying and cannot be blamed on third party modules in my case. 

Avatar
Opusti