c2c-oerpscenario team mailing list archive

["Somesh Khare\(OpenERP\)" <718552@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

To reproduce the error,please follow the steps in web client,

1. In Extended view configure the Warehouse Management.
2. Go-to the Traceability >> Stock Move >> Select any move line( In Form View)
3.On right sidebar, Click on the Related Picking.

Traceback (most recent call last):
  File "/home/tiny/workspace/stable6.0/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/tiny/workspace/stable6.0/server/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/home/tiny/workspace/stable6.0/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/tiny/workspace/stable6.0/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/tiny/workspace/stable6.0/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/tiny/workspace/stable6.0/server/bin/osv/orm.py", line 1736, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/tiny/workspace/stable6.0/server/bin/osv/orm.py", line 3985, in _search
    query = self._where_calc(cr, user, args, context=context)
  File "/home/tiny/workspace/stable6.0/server/bin/osv/orm.py", line 3838, in _where_calc
    e.parse(cr, user, self, context)
  File "/home/tiny/workspace/stable6.0/server/bin/osv/expression.py", line 220, in parse
    self.__exp[i] = ('id', o2m_op, self.__execute_recursive_in(cr, field._fields_id, field_obj._table, 'id', ids2, operator, field._type))
  File "/home/tiny/workspace/stable6.0/server/bin/osv/expression.py", line 60, in __execute_recursive_in
    '  WHERE "%s" IN %%s' % (s, f, w),(tuple(subids),))
  File "/home/tiny/workspace/stable6.0/server/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/home/tiny/workspace/stable6.0/server/bin/sql_db.py", line 133, in execute
    res = self._obj.execute(query, params)
DataError: invalid input syntax for integer: "active_id"
LINE 1: ...T "picking_id"  FROM "stock_move"  WHERE "id" IN (E'active_i...
                                                             ^

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


** Tags: maintenance

** 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)

** Tags added: maintenance

-- 
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/718552

Title:
  [6.0.1] Error on parsing of active_id in domain on act_windows

Status in OpenERP Web Client:
  Confirmed

Bug description:
  To reproduce the error,please follow the steps in web client,

  1. In Extended view configure the Warehouse Management.
  2. Go-to the Traceability >> Stock Move >> Select any move line( In Form View)
  3.On right sidebar, Click on the Related Picking.

  Traceback (most recent call last):
    File "/home/tiny/workspace/stable6.0/server/bin/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/home/tiny/workspace/stable6.0/server/bin/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/home/tiny/workspace/stable6.0/server/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/tiny/workspace/stable6.0/server/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/tiny/workspace/stable6.0/server/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/tiny/workspace/stable6.0/server/bin/osv/orm.py", line 1736, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/home/tiny/workspace/stable6.0/server/bin/osv/orm.py", line 3985, in _search
      query = self._where_calc(cr, user, args, context=context)
    File "/home/tiny/workspace/stable6.0/server/bin/osv/orm.py", line 3838, in _where_calc
      e.parse(cr, user, self, context)
    File "/home/tiny/workspace/stable6.0/server/bin/osv/expression.py", line 220, in parse
      self.__exp[i] = ('id', o2m_op, self.__execute_recursive_in(cr, field._fields_id, field_obj._table, 'id', ids2, operator, field._type))
    File "/home/tiny/workspace/stable6.0/server/bin/osv/expression.py", line 60, in __execute_recursive_in
      '  WHERE "%s" IN %%s' % (s, f, w),(tuple(subids),))
    File "/home/tiny/workspace/stable6.0/server/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/home/tiny/workspace/stable6.0/server/bin/sql_db.py", line 133, in execute
      res = self._obj.execute(query, params)
  DataError: invalid input syntax for integer: "active_id"
  LINE 1: ...T "picking_id"  FROM "stock_move"  WHERE "id" IN (E'active_i...
                                                               ^