Comment 2 for bug 706776

Revision history for this message
Regina Tsui (regina-tsui) wrote :

Hello Amit,

Here attached the error code for your reference.
And for more information, I am using web-client for testing this processes.
------------------------------------------------------------------------------------------------------------------------

Traceback (most recent call last):
  File "/apps/openerp/openerp-server-6.0.1/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/apps/openerp/openerp-server-6.0.1/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/apps/openerp/openerp-server-6.0.1/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 "/apps/openerp/openerp-server-6.0.1/bin/osv/orm.py", line 3968, in _search
    query = self._where_calc(cr, user, args, context=context)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/orm.py", line 3821, in _where_calc
    e.parse(cr, user, self, context)
  File "/apps/openerp/openerp-server-6.0.1/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 "/apps/openerp/openerp-server-6.0.1/bin/osv/expression.py", line 60, in __execute_recursive_in
    ' WHERE "%s" IN %%s' % (s, f, w),(tuple(subids),))
  File "/apps/openerp/openerp-server-6.0.1/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/apps/openerp/openerp-server-6.0.1/bin/sql_db.py", line 131, 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...

------------------------------------------------------------------------------------------------------------------------