c2c-oerpscenario team mailing list archive

[Todor Andreev <819178@xxxxxxxxxxxxxxxxxx>]

Well, as you can see the error is in the crm.lead object. I tried to
save or create a lead and as expected it didn't work, giving the same
error. I checked everywhere for this x_skype field, it was present only
in Addresses. I remembered then that I have created this "x_skype" field
in the leads object and then decided to remove it. I have removed it and
it didn't show in the list of fields (as you can see in the first
movie). Well, after I remembered this now, I decided to try to reproduce
the bug. I created a field x_test (from web interface) and after the
refresh it showed x_test and x_skype also!?!? X_skype obviously was not
deleted, but now (as shown in this video) it is a Base field and I
cannot delete it anymore. I don't know how it happened to be a Base
field. And why it didn't show before. It is definitely a bug, but I
cannot reproduce it with the x_test field now. There is something wrong
here. Neither the GTK nor the web interface showed a x_skype field in
the crm.lead object. I show the screenshot of my earlier search for
evidence. The second screenshot shows the result now. I don't know what
to do, to remove it and it is definitely a bug.

** Attachment added: "out.ogv"
   https://bugs.launchpad.net/openobject-client-web/+bug/819178/+attachment/2249705/+files/out.ogv

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