Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
1 Răspunde
2371 Vizualizări

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)


Imagine profil
Abandonează
Cel mai bun răspuns

Hi,

Can you make sure that you are using PostgreSQL v12 or above and using the latest source code of odoo 16.

Thanks

Imagine profil
Abandonează