I am getting the below error:
odoo.sql_db: bad query: SELECT "website".id FROM "website" WHERE (unaccent("website"."domain":main"::text) ilike unaccent('%111.111.111.11%')) ORDER BY "website"."id"
ERROR: function unaccent_schema.unaccent(unknown, text) does not exist
LINE 2: SELECT unaccent_schema.unaccent('unaccent_sc...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:
SELECT unaccent_schema.unaccent('unaccent_schema.unaccent', $1)
CONTEXT: SQL function "unaccent" during inlining
2021-01-26 09:27:44,114 41151 INFO eastmagic werkzeug: 37.239.210.123 - - [26/Jan/2021 09:27:44] "GET /web/database/manager HTTP/1.1" 500 - >
2021-01-26 09:27:44,120 41151 ERROR eastmagic werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 85, in lookup
r = d[key]
File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 71, in wrapper
return func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/tools/lru.py", line 34, in __getitem__
a = self.d[obj]
KeyError: ('website', <function Website._get_current_website_id at 0x7f7d66dae700>, '111.111.111.11:8069', False, True)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 306, in run_wsgi
execute(self.server.app)
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 294, in execute
application_iter = app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 440, in app
return self.app(e, s)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 124, in application
return application_unproxied(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 99, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1294, in __call__
return self.dispatch(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1262, in __call__
return self.app(environ, start_wrapped)
File "/usr/lib/python3/dist-packages/werkzeug/middleware/shared_data.py", line 220, in __call__
return self.app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1464, in dispatch
result = ir_http._dispatch()
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_http.py", line 179, in _dispatch
request.website_routing = env['website'].get_current_website().id
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/website.py", line 568, in get_current_website
website_id = self._get_current_website_id(domain_name, country_id, fallback=fallback)
File "<decorator-gen-148>", line 2, in _get_current_website_id
File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 90, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/website.py", line 624, in _get_current_website_id
found_websites = self.search([('domain', 'ilike', _remove_port(domain_name))]).sorted('country_group_ids')
File "/usr/lib/python3/dist-packages/odoo/models.py", line 1698, in search
return res if count else self.browse(res)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 4909, in browse
if not ids:
File "/usr/lib/python3/dist-packages/odoo/osv/query.py", line 156, in __bool__
return bool(self._result)
File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 26, in __get__
value = self.fget(obj)
File "/usr/lib/python3/dist-packages/odoo/osv/query.py", line 149, in _result
self._cr.execute(query_str, params)
File "<decorator-gen-3>", line 2, in execute
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 96, in check
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 291, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function unaccent_schema.unaccent(unknown, text) does not exist
LINE 2: SELECT unaccent_schema.unaccent('unaccent_sc...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:
SELECT unaccent_schema.unaccent('unaccent_schema.unaccent', $1)
I tried the same - having the same error - were you able to resolve it?