Skip to Content
This question has been flagged
postgresqlunaccentodooschemapsql
1 Reply
1690 Views
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
Discard
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
Discard
Related Posts Replies Views Activity
select column twice of same table on different condtion Psql Solved
postgresql odoo psql odoo11
Avatar
Avatar
Avatar
3
Feb 24
5309
How can i run a postgres function to create a view in odoo10
postgresql odoo psql odoo10
Avatar
Avatar
1
Oct 20
4245
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
Mar 15
3556
Digitalocean issue
postgresql odoo
Avatar
0
Dec 21
1961
2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`
postgresql odoo
Avatar
Avatar
2
Feb 19
9110