c2c-oerpscenario team mailing list archive

[ciprian <ciprian.parfon@xxxxxxxxx>]

Hi gents,

Has this been resolved? I have the same issue. I can see on status that there is a "Fix Released". Where is this fix? How do I apply it ?
Please help.

Thanks.

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/431247

Title:
  Integrity Errors should appear as user-friendly!

Status in OpenERP Server:
  Fix Released

Bug description:
  Hello,

  When I delete a partner, the corresponding line in res_partner_address
  is not deleted or at least the value in the field partner_id. then, If
  I've some contacts that were affilied to the same address, the fact to
  display them causes a crash :

  Environment Information : 
  System : Windows-32bit-SP1
  OS Name : nt
  Operating System Release : 
  Operating System Version : 32bit
  Operating System Architecture : 32bit
  Operating System Locale : fr_CH.cp1252
  Python Version : 2.5.2
  OpenERP-Client Version : 5.0.3
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/netsvc.py", line 244, in dispatch
      result = LocalService(service_name)(method, *params)
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/netsvc.py", line 73, in __call__
      return getattr(self, method)(*params)
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/service/web_services.py", line 583, in execute
      res = service.execute(db, uid, object, method, *args)
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/osv/osv.py", line 59, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/osv/osv.py", line 118, in execute
      res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/osv/osv.py", line 110, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/osv/orm.py", line 2080, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/osv/orm.py", line 2191, in _read_flat
      res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/osv/fields.py", line 640, in get
      res = self._fnct(obj, cr, user, ids, name, self._arg, context)
    File "/usr/lib/python2.5/site-packages/openerp-server-5.0.3.1/bin/osv/fields.py", line 759, in _fnct_read
      return res
  KeyError: 7610

  
  the KeyErrro value is the id of the partner that was deleted.

  Now, In the same way. If I try to delete a partner that has an invoice in account_invoice, I get the following warning :
  null value in column "partner_id" violates not-null constraint
  CONTEXT:  SQL statement "UPDATE ONLY "public"."account_invoice" SET "partner_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "partner_id""

  For end users, wouldn't it be better to have a message like ' Deleting
  not possible, corresponding recors in the accounting  ...' ?

  thanks

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