Skip to Content
This question has been flagged
2 Replies
12546 Views
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
Discard
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
Discard
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
Discard