When I use the restore function of the database manager from a backup I did on odoo.sh I get the following error:
2021-02-26 12:43:17,172 82281 INFO prod_2602 odoo.addons.base.models.ir_http: Generating routing map for key None
2021-02-26 12:44:58,000 82281 ERROR prod_2602 odoo.sql_db: bad query: SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent("ir_attachment"."url"::text) like unaccent('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent("ir_attachment"."url"::text) like unaccent('/web/content/%-f80683a/%%%'))))) ORDER BY "ir_attachment"."id" DESC
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-02-26 12:44:58,469 82281 ERROR prod_2602 odoo.sql_db: bad query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (("ir_ui_view"."active" = true) AND ("ir_ui_view"."key" = 'web.frontend_layout')) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" ,"ir_ui_view"."id" LIMIT 1
ERROR: current transaction is aborted, commands ignored until end of transaction block
Has anyone an idea on what could be causing it? I saw that there is a settings unaccent=False in my config file but setting it to true doesn't solve anything.
I'm on mac os catalina, the database is postgresql 11, I use python 3.6
Do you find the issue?
Not yet unfortunatelly
I've got the same issue :'(
If you haven't already, please open a Support ticket with us at https://www.odoo.com/help
Thanks Ray I just did it. I wanted to ask here first because I'm not sure that it is covered by your support as it might be a local issue.