Skip to Content
This question has been flagged
postgresqlunaccentodooschemapsql
1 Respondre
1701 Vistes
Avatar
Sneha Vora

odoo.addons.base.models.ir_qweb.QWebException: 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

Path: /t/html/head/t[1]

Node:

Avatar
Descartar
Avatar
Israr
Best 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.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
select column twice of same table on different condtion Psql Solved
postgresql odoo psql odoo11
Avatar
Avatar
Avatar
3
de febr. 24
5309
How can i run a postgres function to create a view in odoo10
postgresql odoo psql odoo10
Avatar
Avatar
1
d’oct. 20
4250
I can't list the database which i restored thorough postgressql,but i can type the db name and login
database postgresql odoo psql
Avatar
Avatar
2
de març 15
3559
Digitalocean issue
postgresql odoo
Avatar
0
de des. 21
1966
2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`
postgresql odoo
Avatar
Avatar
2
de febr. 19
9114