← Back to team overview

openerp-india team mailing list archive

[Bug 1047174] [NEW] Inventory analysis report when click on previous button give me "DataError: OFFSET must not be negative"

 

Public bug reported:

Hello,

Steps for reproduce error :
1. I create new db in trunk
2. Install Sale Management
3. Click on Reporting Menu -> Warehouse -> Inventory Analysis
4. In list view -> click on any record -> display Previous "<" button.
5. When I click on previous("<") button give me error 

Server Traceback (most recent call last):
  File "/home/tiny/rdtools/web/trunk/addons/web/common/session.py", line 51, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/tiny/rdtools/server/trunk/openerp/netsvc.py", line 362, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/tiny/rdtools/server/trunk/openerp/service/web_services.py", line 587, in dispatch
    res = fn(db, uid, *params)
  File "/home/tiny/rdtools/server/trunk/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/tiny/rdtools/server/trunk/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/tiny/rdtools/server/trunk/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/tiny/rdtools/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/tiny/rdtools/server/trunk/openerp/osv/orm.py", line 2277, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/tiny/rdtools/server/trunk/openerp/osv/orm.py", line 4683, 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/rdtools/server/trunk/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/home/tiny/rdtools/server/trunk/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
DataError: OFFSET must not be negative

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1047174

Title:
  Inventory analysis report when click on previous button give me
  "DataError: OFFSET must not be negative"

Status in OpenERP Addons (modules):
  New

Bug description:
  Hello,

  Steps for reproduce error :
  1. I create new db in trunk
  2. Install Sale Management
  3. Click on Reporting Menu -> Warehouse -> Inventory Analysis
  4. In list view -> click on any record -> display Previous "<" button.
  5. When I click on previous("<") button give me error 

  Server Traceback (most recent call last):
    File "/home/tiny/rdtools/web/trunk/addons/web/common/session.py", line 51, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/tiny/rdtools/server/trunk/openerp/netsvc.py", line 362, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/tiny/rdtools/server/trunk/openerp/service/web_services.py", line 587, in dispatch
      res = fn(db, uid, *params)
    File "/home/tiny/rdtools/server/trunk/openerp/osv/osv.py", line 167, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/home/tiny/rdtools/server/trunk/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/tiny/rdtools/server/trunk/openerp/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/tiny/rdtools/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/tiny/rdtools/server/trunk/openerp/osv/orm.py", line 2277, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/home/tiny/rdtools/server/trunk/openerp/osv/orm.py", line 4683, 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/rdtools/server/trunk/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/home/tiny/rdtools/server/trunk/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  DataError: OFFSET must not be negative

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1047174/+subscriptions


Follow ups

References