← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 819178] Re: Opportunities cannot save after creation of new field in Addresses

 

OK, you are right. When I tried reproducing this bug, it didn't occur, too. I don't really know what happened, but the result is this - the field "x_skype" appeared in the list only after I created another field, called "x_test" AND it appears as a "Base field". I don't know what exactly is the idea of "Base" fields, but if the idea is to differentiate the fields we create and the integrated ones, then I don't know how it became "Base" field. I didn't make it Base field, moreover, don't know how to.
Well there is definitely some bug here, because:
1. It is obviously not removed (I removed it from Web interface before)
2. It showed ONLY after I created another one
3. It is now changed to Base field (somehow).

I'm not sure if this bug will receive any further development, as it is obviously not reproducable now, but at least if anyone knows how to remove the field (I think it should be changed to Custom field first), I will be very thankful.
And if anyone could explain the idea of "Base" and "Custom" fields, and how are the "Base" fields removed then..
Thanks!

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

Title:
  Opportunities cannot save after creation of new field in Addresses

Status in OpenERP Web Client:
  Incomplete

Bug description:
  Version of OpenERP: 6.0.2 with webclient and GTK clients.
  Version of Linux server: DISTRIB_DESCRIPTION="Ubuntu 10.04.3 LTS"

  I created a skype field in res.partner.address.
   x_skype	Skype	char			Always Searchable	Custom Field

  Added it in the form view "View Editor 130 - res.partner.address":

  <group>

  <separator string="Communication">

  <field name="phone">

  <field name="fax">

  <field name="mobile">

  <field name="email">

  <field name="x_skype">

  After that added it in view "View Editor 135 - res.partner.form":

  <group>

  <separator string="Communication">

  <field name="phone">

  <field name="mobile">

  <field name="fax">

  <field name="email">

  <field name="x_skype">

  Now when I try to save an opportunity, both in web and GTK, it says:

  Environment Information :
  System : Linux-2.6.32-33-generic-i686-with-Ubuntu-10.04-lucid
  OS Name : posix
  Distributor ID:	Ubuntu
  Description:	Ubuntu 10.04.3 LTS
  Release:	10.04
  Codename:	lucid
  Operating System Release : 2.6.32-33-generic
  Operating System Version : #70-Ubuntu SMP Thu Jul 7 21:09:46 UTC 2011
  Operating System Architecture : 32bit
  Operating System Locale : en_US.UTF8
  Python Version : 2.6.5
  OpenERP-Client Version : 6.0.2
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "/usr/share/pyshared/openerp-server/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/usr/share/pyshared/openerp-server/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/usr/share/pyshared/openerp-server/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/share/pyshared/openerp-server/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/share/pyshared/openerp-server/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/share/pyshared/openerp-server/addons/crm/crm_lead.py", line 308, in write
      return super(crm_lead,self).write(cr, uid, ids, vals, context)
    File "/usr/share/pyshared/openerp-server/osv/orm.py", line 3518, in write
      self.pool.get(object)._store_set_values(cr, user, todo, fields_to_recompute, context)
    File "/usr/share/pyshared/openerp-server/osv/orm.py", line 3786, in _store_set_values
      result = self._columns[val[0]].get(cr, self, ids, val, 1, context=context)
    File "/usr/share/pyshared/openerp-server/osv/fields.py", line 793, in get
      res = self._fnct(obj, cr, user, ids, name, self._arg, context)
    File "/usr/share/pyshared/openerp-server/addons/crm/crm_lead.py", line 68, in _compute_day
      if lead.date_closed:
    File "/usr/share/pyshared/openerp-server/osv/orm.py", line 292, in __getattr__
      return self[name]
    File "/usr/share/pyshared/openerp-server/osv/orm.py", line 205, in __getitem__
      field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
    File "/usr/share/pyshared/openerp-server/osv/orm.py", line 2940, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/usr/share/pyshared/openerp-server/osv/orm.py", line 2999, in _read_flat
      cr.execute(query, (tuple(sub_ids),))
    File "/usr/share/pyshared/openerp-server/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/share/pyshared/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column crm_lead.x_skype does not exist
  LINE 1: ...te,crm_lead.email_cc,crm_lead.type,crm_lead.email,crm_lead.x...

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-client-web/+bug/819178/+subscriptions


References