c2c-oerpscenario team mailing list archive

[Todor Andreev <819178@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: openobject-client-web
     Importance: Undecided
         Status: New

** Description changed:

- Version of OpenERP: 6.0.2 with webclient and GTK clients. 
+ Version of OpenERP: 6.0.2 with webclient and GTK clients.
  Version of Linux server: DISTRIB_DESCRIPTION="Ubuntu 10.04.2 LTS"
  
  I created a skype field in res.partner.address.
- 	x_skype	Skype	char			Always Searchable	Custom Field	
+  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 it says:
- Environment Information : 
+ 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)
+   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...

** Description changed:

  Version of OpenERP: 6.0.2 with webclient and GTK clients.
- Version of Linux server: DISTRIB_DESCRIPTION="Ubuntu 10.04.2 LTS"
+ 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...

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

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