openerp-india team mailing list archive

[Serpent Consulting Services <1051634@xxxxxxxxxxxxxxxxxx>]

** Changed in: openerp-web
       Status: New => Invalid

** Project changed: openerp-web => openobject-server

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1051634

Title:
  ProgrammingError: ERREUR:  la colonne res_partner.email n'existe pas

Status in OpenERP Server:
  Invalid

Bug description:
  Hi,

  I get this error when trying to add a new supplier :

  Traceback (most recent call last):
    File "/home/erp_user/openerp/production/server/bin/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/home/erp_user/openerp/production/server/bin/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/home/erp_user/openerp/production/server/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/erp_user/openerp/production/server/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/erp_user/openerp/production/server/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/erp_user/openerp/production/server/bin/osv/orm.py", line 3691, in create
      self._validate(cr, user, [id_new], context)
    File "/home/erp_user/openerp/production/server/bin/osv/orm.py", line 930, in _validate
      if not fun(self, cr, uid, ids):
    File "/home/erp_user/openerp/production/server/bin/addons/base_vat/base_vat.py", line 61, in check_vat
      if not partner.vat:
    File "/home/erp_user/openerp/production/server/bin/osv/orm.py", line 292, in __getattr__
      return self[name]
    File "/home/erp_user/openerp/production/server/bin/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 "/home/erp_user/openerp/production/server/bin/osv/orm.py", line 2947, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/erp_user/openerp/production/server/bin/osv/orm.py", line 3006, in _read_flat
      cr.execute(query, (tuple(sub_ids),))
    File "/home/erp_user/openerp/production/server/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/home/erp_user/openerp/production/server/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: ERREUR:  la colonne res_partner.email n'existe pas
  LIGNE 1 : ...it_limit,res_partner.name,res_partner.debit_limit,res_partne...
                                                                 ^
  Some log :

  2012-09-16 18:10:22 CEST ERREUR:  la colonne res_partner.email n'existe pas au caractère 449
  2012-09-16 18:10:22 CEST INSTRUCTION :  SELECT res_partner.comment,res_partner.ean13,res_partner.supplier,res_partner.user_id,res_partner.title,res_partner.company_id,res_partner.parent_id,res_partner.last_reconciliation_date,res_partner.ref,res_partner.vat,res_partner.website,res_partner.lang,res_partner.vat_subjected,res_partner.section_id,res_partner.employee,res_partner.date,res_partner.active,res_partner.customer,res_partner.credit_limit,res_partner.name,res_partner.debit_limit,res_partner.email,res_partner.magento_id,res_partner.id FROM "res_partner" WHERE res_partner.id IN (16) ORDER BY name

  I'm not used with postgresql.

  What could I check to debug ?

  thanks you for some help / hints

  Platform : Debian 6 / postgresql 8 / OpenERP Web Version 6.0.4

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