← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 821092] [NEW] clients- monthly turnover Division by zero

 

Public bug reported:


If I go Sales -> Clients form view and press Monthly turnover" on the side I get this.

Environment Information : 
System : Windows-XP-5.1.2600-SP3
OS Name : nt
Operating System Release : XP
Operating System Version : 5.1.2600
Operating System Architecture : 32bit
Operating System Locale : ro_RO.cp1252
Python Version : 2.5.2
OpenERP-Client Version : 6.0.2
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/usr/lib/openerp-server-6.0.1/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/usr/lib/openerp-server-6.0.1/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/openerp-server-6.0.1/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/openerp-server-6.0.1/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/openerp-server-6.0.1/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/openerp-server-6.0.1/osv/orm.py", line 2208, in read_group
    cr.execute('SELECT min(%s.id) AS id, count(%s.id) AS %s_count' % (self._table, self._table, group_count) + (flist and ',') + flist + ' FROM ' + from_clause + where_clause + gb + limit_str + offset_str, where_clause_params)
  File "/usr/lib/openerp-server-6.0.1/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/openerp-server-6.0.1/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
DataError: division by zero

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

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

Title:
  clients- monthly turnover Division by zero

Status in OpenERP Modules (addons):
  New

Bug description:
  
  If I go Sales -> Clients form view and press Monthly turnover" on the side I get this.

  Environment Information : 
  System : Windows-XP-5.1.2600-SP3
  OS Name : nt
  Operating System Release : XP
  Operating System Version : 5.1.2600
  Operating System Architecture : 32bit
  Operating System Locale : ro_RO.cp1252
  Python Version : 2.5.2
  OpenERP-Client Version : 6.0.2
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "/usr/lib/openerp-server-6.0.1/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/usr/lib/openerp-server-6.0.1/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/usr/lib/openerp-server-6.0.1/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/lib/openerp-server-6.0.1/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/lib/openerp-server-6.0.1/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/lib/openerp-server-6.0.1/osv/orm.py", line 2208, in read_group
      cr.execute('SELECT min(%s.id) AS id, count(%s.id) AS %s_count' % (self._table, self._table, group_count) + (flist and ',') + flist + ' FROM ' + from_clause + where_clause + gb + limit_str + offset_str, where_clause_params)
    File "/usr/lib/openerp-server-6.0.1/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/lib/openerp-server-6.0.1/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  DataError: division by zero

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


Follow ups

References