c2c-oerpscenario team mailing list archive

["Dhruti Shastri\(OpenERP\)" <709052@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Hello, 
 
Following is the traceback:

Traceback (most recent call last):
  File "/home/tiny/workspace/trunk/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/tiny/workspace/trunk/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/tiny/workspace/trunk/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/tiny/workspace/trunk/server/bin/osv/orm.py", line 1735, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/tiny/workspace/trunk/server/bin/osv/orm.py", line 3981, 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/tiny/workspace/trunk/server/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/home/tiny/workspace/trunk/server/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
DataError: invalid input syntax for type date: "11/0128"
LINE 1: ...= E'2011-01-28') AND (sale_report.date_confirm >= E'11/0...

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

** Project changed: openobject-addons => openobject-client-web

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

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

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

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/709052

Title:
  web-clilent sending wrong date format to server result in crashes the
  web-client

Status in OpenERP Web Client:
  Confirmed

Bug description:
  Hello, 
   
  Following is the traceback:

  Traceback (most recent call last):
    File "/home/tiny/workspace/trunk/server/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/tiny/workspace/trunk/server/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/tiny/workspace/trunk/server/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/tiny/workspace/trunk/server/bin/osv/orm.py", line 1735, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/home/tiny/workspace/trunk/server/bin/osv/orm.py", line 3981, 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/tiny/workspace/trunk/server/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/home/tiny/workspace/trunk/server/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  DataError: invalid input syntax for type date: "11/0128"
  LINE 1: ...= E'2011-01-28') AND (sale_report.date_confirm >= E'11/0...