openerp-india team mailing list archive

["DBR \(OpenERP\)" <1235140@xxxxxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1146866 ***
    https://bugs.launchpad.net/bugs/1146866

Public bug reported:

Hello,

Tested with latest V7 on rnbt.
Create one or two invoice of xyz products with 0 qty.
validate those invoices.
Go to xyz product form view and with help of more button open product margin wizard
set period and open & Paid  invoice state click on 'Open Margins'.

Output:

Client Traceback (most recent call last):
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/controllers/main.py", line 1054, in search_read
    return self.do_search_read(req, model, fields, offset, limit, domain, sort)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/controllers/main.py", line 1089, in do_search_read
    records = Model.read(ids, fields or False, req.context)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/session.py", line 42, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last):
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/audittrail/audittrail.py", line 514, in execute_cr
    return fct_src(cr, uid, model, method, *args, **kw)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/orm.py", line 3608, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/orm.py", line 3716, in _read_flat
    res2 = self._columns[val[0]].get(cr, self, ids, val, user, context=context, values=res)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/fields.py", line 1133, in get
    result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/product_margin/product_margin.py", line 68, in _product_margin
    cr.execute(sqlstr, (val.id, states, invoice_types, date_from, date_to))
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
DataError: division by zero

This error will raised because of wrong query. we can not assume that
all time we get qty will be one or more then one. we can set null if
when we apply a division in query.

Thanks & regards,
Devishree(DBR)

** 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/1235140

Title:
  [V7] : Product margins have an issue

Status in OpenERP Addons (modules):
  New

Bug description:
  Hello,

  Tested with latest V7 on rnbt.
  Create one or two invoice of xyz products with 0 qty.
  validate those invoices.
  Go to xyz product form view and with help of more button open product margin wizard
  set period and open & Paid  invoice state click on 'Open Margins'.

  Output:

  Client Traceback (most recent call last):
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/http.py", line 204, in dispatch
      response["result"] = method(self, **self.params)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/controllers/main.py", line 1054, in search_read
      return self.do_search_read(req, model, fields, offset, limit, domain, sort)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/controllers/main.py", line 1089, in do_search_read
      records = Model.read(ids, fields or False, req.context)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/session.py", line 42, in proxy
      result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/session.py", line 30, in proxy_method
      result = self.session.send(self.service_name, method, *args)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/session.py", line 103, in send
      raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

  Server Traceback (most recent call last):
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/web/session.py", line 89, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/netsvc.py", line 292, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/service/web_services.py", line 626, in dispatch
      res = fn(db, uid, *params)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/osv.py", line 188, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/osv.py", line 131, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/osv.py", line 197, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/audittrail/audittrail.py", line 514, in execute_cr
      return fct_src(cr, uid, model, method, *args, **kw)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/osv.py", line 185, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/orm.py", line 3608, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/orm.py", line 3716, in _read_flat
      res2 = self._columns[val[0]].get(cr, self, ids, val, user, context=context, values=res)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/osv/fields.py", line 1133, in get
      result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/addons/product_margin/product_margin.py", line 68, in _product_margin
      cr.execute(sqlstr, (val.id, states, invoice_types, date_from, date_to))
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/sql_db.py", line 161, in wrapper
      return f(self, *args, **kwargs)
    File "/home/odoo/runbot/static/openerp-dev-7-0-21760/server/openerp/sql_db.py", line 226, in execute
      res = self._obj.execute(query, params)
  DataError: division by zero

  This error will raised because of wrong query. we can not assume that
  all time we get qty will be one or more then one. we can set null if
  when we apply a division in query.

  Thanks & regards,
  Devishree(DBR)

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