Odoo Help


OpenERP 7 - Error while creating first database

Networld Team
on 7/18/14, 12:37 AM 1,323 views

Hi all,

on my first database creation i get this error. Any idea to fix it ?

I'm on debian 7, Openerp 7. Thanks

OpenERP Server Error

Client Traceback (most recent call last):
  File "/home/openerp/web/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/openerp/web/addons/web/controllers/main.py", line 774, in create
  File "/home/openerp/web/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/openerp/web/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/home/openerp/web/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/openerp/server/openerp/netsvc.py", line 296, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/openerp/server/openerp/service/web_services.py", line 122, in dispatch
    return fn(*params)
  File "/home/openerp/server/openerp/service/web_services.py", line 167, in exp_create_database
  File "/home/openerp/server/openerp/service/web_services.py", line 136, in _create_empty_database
    cr.execute("""CREATE DATABASE "%s" ENCODING 'unicode' TEMPLATE "%s" """ % (name, chosen_template))
  File "/home/openerp/server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/home/openerp/server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
DataError: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT:  Use the same encoding as in the template database, or use template0 as template.





Jeudy Nicolas

--Jeudy Nicolas--

| 6 7 8
Pelousey, France
--Jeudy Nicolas--

- Linux administrator - Functional guy with OpenERP - Python, html, css, javascript developer OpenERP Ready Partner

Jeudy Nicolas
On 7/18/14, 3:03 AM


The message you is:

- You have installed Postgresql with SQL_ASCII default encoding, but Odoo use UTF8 encoding.

To correct this, setup postgresql with defaut UTF8 encoding or reinstall Postgresql with UTF8 encoding.

You work on Windows ? Linux ? I can update the response with more detail If you comment my answer with the systeme you use.

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 7/18/14, 12:37 AM
Seen: 1323 times
Last updated: 3/16/15, 8:10 AM