Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Creating database in new installation results in "server error"

on 2/19/13, 4:09 PM 1,926 views

I'm installing OpenERP version 7.0-20130219-002614-1 (the deb package) on Debian Squeeze. The install goes OK (after some some failed installs because of old Python versions hanging around), but when I try to create the initial database, I get the following message:

OpenERP Server Error

Client Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.6/openerp/addons/web/http.py", line 195, in dispatch
    response["result"] = method(self, **self.params)
  File "/usr/lib/pymodules/python2.6/openerp/addons/web/controllers/main.py", line 719, in create
  File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 104, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/lib/pymodules/python2.6/openerp/netsvc.py", line 295, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.6/openerp/service/web_services.py", line 122, in dispatch
    return fn(*params)
  File "/usr/lib/pymodules/python2.6/openerp/service/web_services.py", line 167, in exp_create_database
  File "/usr/lib/pymodules/python2.6/openerp/service/web_services.py", line 136, in _create_empty_database
    cr.execute("""CREATE DATABASE "%s" ENCODING 'unicode' TEMPLATE "%s" """ % (name, chosen_template))
  File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 162, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
DataError: encoding UTF8 does not match locale en_IE@euro
DETAIL:  The chosen LC_CTYPE setting requires encoding LATIN9.

Can anybody shed some light on why this might be happening?

Thanks very much.


Cyril Gaspard (GEM)

--Cyril Gaspard (GEM)--
| 5 6 8
Paris, France
--Cyril Gaspard (GEM)--

Forum contributor since 2008

Cyril Gaspard (GEM)
On 3/9/13, 9:11 PM


just configure postgresql to use utf-8 as encoding and not unicode as it is displayed in your log :

cr.execute("""CREATE DATABASE "%s" ENCODING 'unicode' TEMPLATE "%s" """ % (name, chosen_template))


Thanks. I'm not very familiar with Postgres but I reconfigured the server to use UTF-8 everywhere and OpenERP works fine now.

on 3/11/13, 10:17 AM

Hi, good news.Bye

Cyril Gaspard (GEM)
on 3/11/13, 6:06 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


Asked: 2/19/13, 4:09 PM
Seen: 1926 times
Last updated: 3/16/15, 8:10 AM