Using ODOO 16.0+e (enterprise edition)
When I click products or product variants I get the following error. Can anyone help me fix this? I am unable to access products or product variants from any of the modules.
RPC_ERROR
Odoo Server Error
Traceback (most recent call last):
File "/home/odoo/src/odoo/16.0/odoo/http\.py",\ line\ 1584,\ in\ _serve_db
\ \ \ \ return\ service_model\.retrying\(self\._serve_ir_http,\ self\.env\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/service/model\.py",\ line\ 134,\ in\ retrying
\ \ \ \ result\ =\ func\(\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/http\.py",\ line\ 1613,\ in\ _serve_ir_http
\ \ \ \ response\ =\ self\.dispatcher\.dispatch\(rule\.endpoint,\ args\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/http\.py",\ line\ 1810,\ in\ dispatch
\ \ \ \ result\ =\ self\.request\.registry\['ir\.http'\]\._dispatch\(endpoint\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/addons/base/models/ir_http\.py",\ line\ 149,\ in\ _dispatch
\ \ \ \ result\ =\ endpoint\(\*\*request\.params\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/http\.py",\ line\ 699,\ in\ route_wrapper
\ \ \ \ result\ =\ endpoint\(self,\ \*args,\ \*\*params_ok\)
\ \ File\ "/home/odoo/src/odoo/16\.0/addons/web/controllers/dataset\.py",\ line\ 42,\ in\ call_kw
\ \ \ \ return\ self\._call_kw\(model,\ method,\ args,\ kwargs\)
\ \ File\ "/home/odoo/src/odoo/16\.0/addons/web/controllers/dataset\.py",\ line\ 33,\ in\ _call_kw
\ \ \ \ return\ call_kw\(request\.env\[model\],\ method,\ args,\ kwargs\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/api\.py",\ line\ 457,\ in\ call_kw
\ \ \ \ result\ =\ _call_kw_model\(method,\ model,\ args,\ kwargs\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/api\.py",\ line\ 430,\ in\ _call_kw_model
\ \ \ \ result\ =\ method\(recs,\ \*args,\ \*\*kwargs\)
\ \ File\ "/home/odoo/src/odoo/16\.0/addons/web/models/models\.py",\ line\ 62,\ in\ web_search_read
\ \ \ \ records\ =\ self\.search_read\(domain,\ fields,\ offset=offset,\ limit=limit,\ order=order\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/models\.py",\ line\ 4955,\ in\ search_read
\ \ \ \ records\ =\ self\.search\(domain\ or\ \[\],\ offset=offset,\ limit=limit,\ order=order\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/models\.py",\ line\ 1509,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/models\.py",\ line\ 5082,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/tools/query\.py",\ line\ 217,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/tools/func\.py",\ line\ 28,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/tools/query\.py",\ line\ 210,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "/home/odoo/src/odoo/16\.0/odoo/sql_db\.py",\ line\ 313,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.UndefinedFunction:\ operator\ does\ not\ exist:\ integer\ =\ boolean
LINE\ 1:\ \.\.\.d"\ in\ \(1,\ 2\)\)\ OR\ \("product_template"\."company_id"\ =\ true\)\)\ O\.\.\.
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \^
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:
OwlError:\ The\ following\ error\ occurred\ in\ onWillStart:\ "Odoo\ Server\ Error"
\ \ \ \ at\ wrapError\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/460\-c9fe2bd/web\.assets_common\.min\.js:1589:77\)
\ \ \ \ at\ onWillStart\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/460\-c9fe2bd/web\.assets_common\.min\.js:1595:117\)
\ \ \ \ at\ useModel\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/461\-ca4ddec/web\.assets_backend\.min\.js:4756:1\)
\ \ \ \ at\ KanbanController\.setup\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/461\-ca4ddec/web\.assets_backend\.min\.js:4205:851\)
\ \ \ \ at\ new\ ComponentNode\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/460\-c9fe2bd/web\.assets_common\.min\.js:1551:202\)
\ \ \ \ at\ https://paradise\-pillow\-inc\.odoo\.com/web/assets/460\-c9fe2bd/web\.assets_common\.min\.js:2077:6
\ \ \ \ at\ View\.slot1\ \(eval\ at\ compile\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/460\-c9fe2bd/web\.assets_common\.min\.js:2039:370\),\ :15:36\)
\ \ \ \ at\ callSlot\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/460\-c9fe2bd/web\.assets_common\.min\.js:1652:25\)
\ \ \ \ at\ WithSearch\.template\ \(eval\ at\ compile\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/460\-c9fe2bd/web\.assets_common\.min\.js:2039:370\),\ :8:12\)
\ \ \ \ at\ Fiber\._render\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/460\-c9fe2bd/web\.assets_common\.min\.js:1478:96\)
Caused\ by:\ RPC_ERROR:\ Odoo\ Server\ Error
\ \ \ \ at\ makeErrorFromResponse\ \(https://paradise\-pillow\-inc\.odoo\.com/web/assets/461\-ca4ddec/web\.assets_backend\.min\.js:974:163\)
\ \ \ \ at\ XMLHttpRequest\.\ \(https://paradise-pillow-inc.odoo.com/web/assets/461-ca4ddec/web.assets_backend.min.js:982:13)