getting "unaccent_schema.unaccent" error while restoring any databse

Question

odoo.addons.base.models.ir_qweb.QWebException: [1] Error while render the template
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)
CONTEXT:  SQL function "unaccent" during inlining

Template: web.frontend_layout
Pat

Israr · Accepted Answer

I finally found the solution.
I had to execute this sql request: DELETE FROM pg_proc WHERE proname='unaccent';
Because it seems like Odoo still detects the database as in unaccent mode.

Gerelateerde posts	Antwoorden	Weergaven
select column twice of same table on different condtion Psql Opgelost postgresql odoo psql odoo11	3 feb. 24	7657
How can i run a postgres function to create a view in odoo10 postgresql odoo psql odoo10	1 okt. 20	6825
I can't list the database which i restored thorough postgressql,but i can type the db name and login database postgresql odoo psql	2 mrt. 15	5361
Have You Faced Slow Pagination in Odoo List Views with Large Data? postgresql odoo	0 apr. 26	830
Digitalocean issue postgresql odoo	0 dec. 21	4481

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!