openerp-india team mailing list archive

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

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

** Description changed:

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

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