Odoo Help


"HINT: Perhaps you need a different "datestyle" setting." error during installation of ODOO 9

on 12/3/15, 10:09 PM 2,861 views


I'm trying to install the modules , While installation I'm facing the below issue.

I referred some blogs and set the PostgreSQL Date format as datestyle=(iso,dmy)

######################### Error ############################

Odoo Server Error

Traceback (most recent call last):

File "/opt/odoo/openerp/http.py", line 599, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/opt/odoo/openerp/http.py", line 636, in dispatch

result = self._call_function(**self.params)

File "/opt/odoo/openerp/http.py", line 315, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/opt/odoo/openerp/service/model.py", line 118, in wrapper

return f(dbname, *args, **kwargs)

File "/opt/odoo/openerp/http.py", line 308, in checked_call

result = self.endpoint(*a, **kw)

File "/opt/odoo/openerp/http.py", line 887, in __call__

return self.method(*args, **kw)

File "/opt/odoo/openerp/http.py", line 465, in response_wrap

response = f(*args, **kw)

File "/opt/odoo/addons/web/controllers/main.py", line 975, in call_button

action = self._call_kw(model, method, args, {})

File "/opt/odoo/addons/web/controllers/main.py", line 963, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/opt/odoo/openerp/api.py", line 232, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/openerp/addons/base/module/module.py", line 459, in button_immediate_install

return self._button_immediate_function(cr, uid, ids, self.button_install, context=context)

File "/opt/odoo/openerp/api.py", line 232, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/openerp/addons/base/module/module.py", line 533, in _button_immediate_function

registry = openerp.modules.registry.RegistryManager.new(cr.dbname, update_module=True)

File "/opt/odoo/openerp/modules/registry.py", line 385, in new

openerp.modules.load_modules(registry._db, force_demo, status, update_module)

File "/opt/odoo/openerp/modules/loading.py", line 337, in load_modules

loaded_modules, update_module)

File "/opt/odoo/openerp/modules/loading.py", line 237, in load_marked_modules

loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)

File "/opt/odoo/openerp/modules/loading.py", line 156, in load_module_graph

_load_data(cr, module_name, idref, mode, kind='data')

File "/opt/odoo/openerp/modules/loading.py", line 98, in _load_data

tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)

File "/opt/odoo/openerp/tools/convert.py", line 852, in convert_file

convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

File "/opt/odoo/openerp/tools/convert.py", line 939, in convert_xml_import

obj.parse(doc.getroot(), mode=mode)

File "/opt/odoo/openerp/tools/convert.py", line 802, in parse

self.parse(rec, mode)

File "/opt/odoo/openerp/tools/convert.py", line 805, in parse

self._tags[rec.tag](self.cr, rec, de, mode=mode)

File "/opt/odoo/openerp/tools/convert.py", line 709, in _tag_record

id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )

File "/opt/odoo/openerp/api.py", line 232, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/openerp/addons/base/ir/ir_model.py", line 1107, in _update

res_id = model_obj.create(cr, uid, values, context=context)

File "/opt/odoo/openerp/api.py", line 232, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/addons/project/project.py", line 647, in create

task_id = super(task, self).create(cr, uid, vals, context=create_context)

File "/opt/odoo/openerp/api.py", line 232, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/openerp/api.py", line 327, in old_api

result = method(recs, *args, **kwargs)

File "/opt/odoo/addons/mail/models/mail_thread.py", line 230, in create

thread = super(MailThread, self).create(values)

File "/opt/odoo/openerp/api.py", line 230, in wrapper

return new_api(self, *args, **kwargs)

File "/opt/odoo/openerp/models.py", line 4130, in create

record = self.browse(self._create(old_vals))

File "/opt/odoo/openerp/api.py", line 230, in wrapper

return new_api(self, *args, **kwargs)

File "/opt/odoo/openerp/api.py", line 463, in new_api

result = method(self._model, cr, uid, *args, **kwargs)

File "/opt/odoo/openerp/models.py", line 4268, in _create

tuple([u[2] for u in updates if len(u) > 2])

File "/opt/odoo/openerp/sql_db.py", line 139, in wrapper

return f(self, *args, **kwargs)

File "/opt/odoo/openerp/sql_db.py", line 215, in execute

res = self._obj.execute(query, params)

ParseError: "date/time field value out of range: "2015-13-01"

LINE 1: ... 'normal', 1, 'You can set a deadline on a task', '2015-13-0...


HINT: Perhaps you need a different "datestyle" setting.

" while parsing /opt/odoo/addons/project/project_data.xml:293, near

<record id="project_task_data_11" model="project.task">

<field name="user_id" ref="base.user_root"/>

<field name="priority">0</field>

<field name="project_id" ref="project.project_project_data"/>

<field name="name">You can set a deadline on a task</field>

<field name="stage_id" ref="project_stage_data_1"/>

<field name="date_deadline" eval="'2015-%s-01' %(datetime.now().month+1)"/>


Hello, Is it a custom module ?

on 12/4/15, 12:11 AM

NO yaar. I tried to install odoo default modules.

on 12/6/15, 8:29 PM

Ermin Trevisan

--Ermin Trevisan--
| 6 5 7
Walchwil, Switzerland
--Ermin Trevisan--

Ermin Trevisan
On 12/4/15, 1:45 AM

This was a bug, when installing with demo data. It is fixed since 3 days, see https://github.com/odoo/odoo/issues/9826

Ermin Trevisan , Already check with the comment, No use of that.

on 12/8/15, 9:45 PM

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: 12/3/15, 10:09 PM
Seen: 2861 times
Last updated: 12/6/15, 2:19 PM