c2c-oerpscenario team mailing list archive

["Olivier \(Open ERP\)" <683138@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I just installed French language in openerp. In Sale Orders, when
selecting a date with the calednar popup, the search returns an error:

Traceback (most recent call last):
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/service/web_services.py", line 596, in dispatch
    res = fn(db, uid, *params)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/orm.py", line 1842, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/orm.py", line 4055, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
DataError: date/time field value out of range: "30/11/2010"
HINT:  Perhaps you need a different "datestyle" setting.

The date string returned by the calendar popup was: 30/11/2010

SQL query was:
  SELECT "sale_order".id FROM "sale_order" WHERE (sale_order.date_order >= E'30/11/2010') ORDER BY name desc  limit 80

** Affects: openobject-client-web
     Importance: Medium
     Assignee: OpenERP SA's Web Client R&D (openerp-dev-web)
         Status: Confirmed

** Changed in: openobject-client-web
       Status: New => Confirmed

** Changed in: openobject-client-web
   Importance: Undecided => Medium

** Changed in: openobject-client-web
     Assignee: (unassigned) => OpenERP SA's Web Client R&D (openerp-dev-web)

-- 
date widget in search: invalid format
https://bugs.launchpad.net/bugs/683138
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Web Client: Confirmed

Bug description:
I just installed French language in openerp. In Sale Orders, when selecting a date with the calednar popup, the search returns an error:

Traceback (most recent call last):
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/service/web_services.py", line 596, in dispatch
    res = fn(db, uid, *params)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/orm.py", line 1842, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/osv/orm.py", line 4055, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/oli/work/bzr_repos/trunk/server_addons_only/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
DataError: date/time field value out of range: "30/11/2010"
HINT:  Perhaps you need a different "datestyle" setting.

The date string returned by the calendar popup was: 30/11/2010

SQL query was:
  SELECT "sale_order".id FROM "sale_order" WHERE (sale_order.date_order >= E'30/11/2010') ORDER BY name desc  limit 80