date widget in search: invalid format

[Olivier Laurent (Open ERP)]

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

[Olivier Laurent (Open ERP) (olt)]

This is after I changed the language of the uesr to french.

[Olivier Laurent (Open ERP) (olt)]

typo: uesr -> user

[Olivier Laurent (Open ERP) (olt)]

Fixed by: http://bazaar.launchpad.net/~openerp/openobject-client-web/trunk/revision/3996

[Olivier Laurent (Open ERP) (olt)]

In some very rare cases, the problem could still be there:

Steps:

 * your user is configured in french
 * you have already opened the Sale Orders page in tree view
 * you open the preference dialog and change your language to english
 * in the Sale Orders tree view, you choose the 2010-12-31 'order date' and execute a search
 * -> error because even if you change your language in the preference popup, the date widget is not aware of your change and displays the date in the old language format

[Olivier Laurent (Open ERP) (olt)]

Importance: Medium -> Low

Will only happens in some very rare cases.

[Sananaz (Open ERP) (sma-tiny)]

Hello Olivier (Open ERP),

Its fixed in trunk web-client. Please update your code and notify us.

Revision-info:
4228 <email address hidden>

Thank you.