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

Bug #1026950 reported by Marcos Garcia
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Server (MOVED TO GITHUB)
New
Undecided
Unassigned

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 <email address hidden>
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 post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.