openerp-india team mailing list archive

Thread
Date
[Bug 1026950] [NEW] Programming error: There's no column "location_id" in "crm_lead"

To: openerp-india@xxxxxxxxxxxxxxxxxxx
From: Marcos Garcia <1026950@xxxxxxxxxxxxxxxxxx>
Date: Fri, 20 Jul 2012 08:00:00 -0000
Reply-to: Bug 1026950 <1026950@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

Hello,

I've configured an email account in OpenERP 6.1.1 (downloaded .tar.gz
under Debian from openerp.com) that forwards emails to "crm.lead" in
order to create Leads when a new Email arrives. But an error is thrown:

Su versión de OpenERP no está soportada. Los servicios de soporte & mantenimiento están disponibles aqui:OpenERP Enterprise.
OpenERP Server Error
Client Traceback (most recent call last):
  File "/opt/server/openerp/addons/web/common/http.py", line 180, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/opt/server/openerp/addons/web/controllers/main.py", line 1047, in call_button
    action = self.call_common(req, model, method, args, domain_id, context_id)
  File "/opt/server/openerp/addons/web/controllers/main.py", line 991, in call_common
    return self._call_kw(req, model, method, args, {})
  File "/opt/server/openerp/addons/web/controllers/main.py", line 1005, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/opt/server/openerp/addons/web/common/openerplib/main.py", line 250, in proxy
    args, kw)
  File "/opt/server/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/opt/server/openerp/addons/web/common/http.py", line 611, in send
    raise fault


Server Traceback (most recent call last):
  File "/opt/server/openerp/addons/web/common/http.py", line 592, in send
    result = openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/netsvc.py", line 360, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/server/openerp/addons/audittrail/audittrail.py", line 495, in execute_cr
    return fct_src(cr, uid, model, method, *args)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/server/openerp/addons/fetchmail/fetchmail.py", line 231, in fetch_mail
    server.write({'date': time.strftime(tools.DEFAULT_SERVER_DATETIME_FORMAT)})
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/orm.py", line 368, in function_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/orm.py", line 3927, in write
    'where id IN %s', upd1 + [sub_ids])
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción

2012-07-20 07:52:19,115 1049 INFO ? fetchmail: start checking for new emails on imap server comercial@xxxxxx
2012-07-20 07:52:19,516 1049 ERROR ? openerp.sql_db: Programming error: no existe la columna Â«location_idÂ» en la relaci                                                                                                  Ã³n Â«crm_leadÂ»
LINE 1: ... "crm_lead" (id,"user_id","name","optout","color","location_...
                                                             ^
, in query insert into "crm_lead" (id,"user_id","name","optout","color","location_id","optin","company_id","section_id","                                                                                                  priority","state","active","type","email_from",create_uid,create_date) values (1,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%                                                                                                  s,(now() at time zone 'UTC'))
2012-07-20 07:52:19,558 1049 ERROR ? openerp.sql_db: bad query: update fetchmail_server set "date"=E'2012-07-20 07:52:19'                                                                                                  ,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (2)
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 212, in exe                                                                                                  cute
    res = self._obj.execute(query, params)
InternalError: transacciÃ³n abortada, las Ã³rdenes serÃ¡n ignoradas hasta el fin de bloque de transacciÃ³n

2012-07-20 07:52:19,559 1049 ERROR ? openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 121, in wr                                                                                                  apper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 176, in ex                                                                                                  ecute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/server/openerp/addons/audittrail/audittrail.py", line 495, in execute_cr
    return fct_src(cr, uid, model, method, *args)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 164, in ex                                                                                                  ecute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/server/openerp/addons/fetchmail/fetchmail.py", line 231, in fetch_mail
    server.write({'date': time.strftime(tools.DEFAULT_SERVER_DATETIME_FORMAT)})
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/orm.py", line 368, in fu                                                                                                  nction_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/orm.py", line 3927, in w                                                                                                  rite
    'where id IN %s', upd1 + [sub_ids])
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 152, in wra                                                                                                  pper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 212, in exe                                                                                                  cute
    res = self._obj.execute(query, params)
InternalError: transacciÃ³n abortada, las Ã³rdenes serÃ¡n ignoradas hasta el fin de bloque de transacciÃ³n

2012-07-20 07:52:19,596 1049 ERROR ? openerp.netsvc: transacciÃ³n
abortada, las Ã³rdenes serÃ¡n ignoradas hasta el fin de
bloque de transacciÃ³n

** Affects: openobject-server
     Importance: Undecided
         Status: New

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

Title:
  Programming error: There's no column "location_id" in "crm_lead"

Status in OpenERP Server:
  New

Bug description:
  Hello,

  I've configured an email account in OpenERP 6.1.1 (downloaded .tar.gz
  under Debian from openerp.com) that forwards emails to "crm.lead" in
  order to create Leads when a new Email arrives. But an error is
  thrown:

  Su versión de OpenERP no está soportada. Los servicios de soporte & mantenimiento están disponibles aqui:OpenERP Enterprise.
  OpenERP Server Error
  Client Traceback (most recent call last):
    File "/opt/server/openerp/addons/web/common/http.py", line 180, in dispatch
      response["result"] = method(controller, self, **self.params)
    File "/opt/server/openerp/addons/web/controllers/main.py", line 1047, in call_button
      action = self.call_common(req, model, method, args, domain_id, context_id)
    File "/opt/server/openerp/addons/web/controllers/main.py", line 991, in call_common
      return self._call_kw(req, model, method, args, {})
    File "/opt/server/openerp/addons/web/controllers/main.py", line 1005, in _call_kw
      return getattr(req.session.model(model), method)(*args, **kwargs)
    File "/opt/server/openerp/addons/web/common/openerplib/main.py", line 250, in proxy
      args, kw)
    File "/opt/server/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/opt/server/openerp/addons/web/common/http.py", line 611, in send
      raise fault

  
  Server Traceback (most recent call last):
    File "/opt/server/openerp/addons/web/common/http.py", line 592, in send
      result = openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/netsvc.py", line 360, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/service/web_services.py", line 586, in dispatch
      res = fn(db, uid, *params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 167, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/opt/server/openerp/addons/audittrail/audittrail.py", line 495, in execute_cr
      return fct_src(cr, uid, model, method, *args)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/opt/server/openerp/addons/fetchmail/fetchmail.py", line 231, in fetch_mail
      server.write({'date': time.strftime(tools.DEFAULT_SERVER_DATETIME_FORMAT)})
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/orm.py", line 368, in function_proxy
      return attr(self._cr, self._uid, [self._id], *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/orm.py", line 3927, in write
      'where id IN %s', upd1 + [sub_ids])
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  InternalError: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción

  2012-07-20 07:52:19,115 1049 INFO ? fetchmail: start checking for new emails on imap server comercial@xxxxxx
  2012-07-20 07:52:19,516 1049 ERROR ? openerp.sql_db: Programming error: no existe la columna Â«location_idÂ» en la relaci                                                                                                  Ã³n Â«crm_leadÂ»
  LINE 1: ... "crm_lead" (id,"user_id","name","optout","color","location_...
                                                               ^
  , in query insert into "crm_lead" (id,"user_id","name","optout","color","location_id","optin","company_id","section_id","                                                                                                  priority","state","active","type","email_from",create_uid,create_date) values (1,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%                                                                                                  s,(now() at time zone 'UTC'))
  2012-07-20 07:52:19,558 1049 ERROR ? openerp.sql_db: bad query: update fetchmail_server set "date"=E'2012-07-20 07:52:19'                                                                                                  ,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (2)
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 212, in exe                                                                                                  cute
      res = self._obj.execute(query, params)
  InternalError: transacciÃ³n abortada, las Ã³rdenes serÃ¡n ignoradas hasta el fin de bloque de transacciÃ³n

  2012-07-20 07:52:19,559 1049 ERROR ? openerp.osv.osv: Uncaught exception
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 121, in wr                                                                                                  apper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 176, in ex                                                                                                  ecute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/opt/server/openerp/addons/audittrail/audittrail.py", line 495, in execute_cr
      return fct_src(cr, uid, model, method, *args)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/osv.py", line 164, in ex                                                                                                  ecute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/opt/server/openerp/addons/fetchmail/fetchmail.py", line 231, in fetch_mail
      server.write({'date': time.strftime(tools.DEFAULT_SERVER_DATETIME_FORMAT)})
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/orm.py", line 368, in fu                                                                                                  nction_proxy
      return attr(self._cr, self._uid, [self._id], *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/osv/orm.py", line 3927, in w                                                                                                  rite
      'where id IN %s', upd1 + [sub_ids])
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 152, in wra                                                                                                  pper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-6.1_20120709_233338-py2.6.egg/openerp/sql_db.py", line 212, in exe                                                                                                  cute
      res = self._obj.execute(query, params)
  InternalError: transacciÃ³n abortada, las Ã³rdenes serÃ¡n ignoradas hasta el fin de bloque de transacciÃ³n

  2012-07-20 07:52:19,596 1049 ERROR ? openerp.netsvc: transacciÃ³n
  abortada, las Ã³rdenes serÃ¡n ignoradas hasta el fin de
  bloque de transacciÃ³n

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

[Bug 1026950] Re: Programming error: There's no column "location_id" in "crm_lead"
From: Amit Parik (OpenERP), 2012-07-20
[Bug 1026950] [NEW] Programming error: There's no column "location_id" in "crm_lead"
From: Marcos Garcia, 2012-07-20
References

[Bug 1026950] [NEW] Programming error: There's no column "location_id" in "crm_lead"
From: Marcos Garcia, 2012-07-20