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.

İlgili Gönderiler	Cevaplar	Görünümler
select column twice of same table on different condtion Psql Çözüldü postgresql odoo psql odoo11	3 Şub 24	7670
How can i run a postgres function to create a view in odoo10 postgresql odoo psql odoo10	1 Eki 20	6836
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 Mar 15	5363
Have You Faced Slow Pagination in Odoo List Views with Large Data? postgresql odoo	0 Nis 26	840
Digitalocean issue postgresql odoo	0 Ara 21	4486

Bu soru işaretlendi

Tartışma hoşunuza mı gidiyor? Sadece okumakla kalmayın, katılın!