ProgrammingError: ERREUR: la colonne « location_id » de la relation « crm_lead » n'existe pas

[Claude Roux]

Version 6.1
CRM v 6.1.1.0

When creating a new lead, I get the following error message when I save the lead :

OpenERP Server Error
Client Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 180, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 922, in create
    r = m.create(data, req.session.eval_context(req.context))
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 250, in proxy
    args, kw)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 611, in send
    raise fault

Server Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 592, in send
    result = openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 572, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base_contact/base_contact.py", line 223, in create
    result = super(res_partner_address, self).create(cr, uid, data, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 4154, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
ProgrammingError: ERREUR: la colonne « location_id » de la relation « crm_lead » n'existe pas
LIGNE 1 : ...id","city","user_id","zip","title","partner_name","location_...
                                                               ^

Regards
C Roux

[Claude Roux (claude-roux)]

Column "location_id" does not exist in crm_lead PostgreSqL table.

[Claude Roux (claude-roux)]

Requires creation of "location_id" and "contact_id" field in the crm_lead table

[Claude Roux (claude-roux)]

You wrote :
*** This bug is a duplicate of bug 982751 ***
    https://bugs.launchpad.net/bugs/982751
** This bug has been marked a duplicate of bug 982751
   6.1 - Installing the Document Management module breaks leads

I disagree with the reason for duplicate status, because : I DID NOT INSTALL DOCUMENT MANAGEMENT MODULE !

Please find below the list of modules and extras installed :
crm Customer Relationship Management CRM Easy OpenERP SA 6.1.1.0 6.1.1.0 Installed
project Project Management Project Management Easy OpenERP SA 6.1.1.1 6.1.1.1 Installed
account_accountant Accounting & Finance Accounting and Finance Normal OpenERP SA 6.1.1.1 6.1.1.1 Installed
hr Human Resources Employee Directory Easy OpenERP SA 6.1.1.1 6.1.1.1 Installed
sale Sales Management Sales Management Easy OpenERP SA 6.1.1.0 6.1.1.0 Installed
hr_timesheet_sheet Human Resources Timesheets Validation Normal OpenERP SA 6.1.1.0 6.1.1.0 Installed
stock Warehouse Management Warehouse Management Easy OpenERP SA 6.1.1.1 6.1.1.1 Installed
purchase Purchase Management Purchase Management Easy OpenERP SA 6.1.1.1 6.1.1.1 Installed
project_gtd Project Management Todo Lists Easy OpenERP SA 6.1.1.0 6.1.1.0 Installed
project_issue Project Management Issues Tracker Easy OpenERP SA 6.1.1.0 6.1.1.0 Installed
hr_recruitment Human Resources Recruitment Process Easy OpenERP SA 6.1.1.0 6.1.1.0 Installed
hr_holidays Human Resources Leaves Management Easy OpenERP SA 6.1.1.5 6.1.1.5 Installed
hr_expense Human Resources Expenses Management Easy OpenERP SA 6.1.1.0 6.1.1.0 Installed
hr_payroll Human Resources Payroll Normal OpenERP SA 6.1.1.0 6.1.1.0 Installed
account Accounting & Finance eInvoicing Easy OpenERP SA 6.1.1.1 6.1.1.1 Installed
account_analytic_analysis Sales Management Contracts Management Normal Camptocamp 6.1.1.1 6.1.1.1 Installed
account_analytic_default Accounting & Finance Account Analytic Defaults Normal OpenERP SA 6.1.1.0 6.1.1.0 Installed
account_analytic_plans Accounting & Finance Multiple Analytic Plans Normal OpenERP SA 6.1.1.0 6.1.1.0 Installed
account_budget Accounting & Finance Budgets Management Normal OpenERP SA 6.1.1.0 6.1.1.0 Installed
analytic_journal_billing_rate Sales Management Billing Rates on Contracts Normal OpenERP SA 6.1.1.0 6.1.1.0 Installed
analytic_user_function Sales Management Jobs on Contracts Normal OpenERP SA 6.1.1.0 6.1.1.0 Installed
base_action_rule Sales Management Automated Action Rules Normal OpenERP SA 6.1.1.0 6.1.1.0 Installed
base_contact Customer Relationship Management Contacts Management Expert OpenERP SA 6.1.1.0 6.1.1.0 Installed
edi Extra Tools Electronic Data Interchange (EDI) Easy OpenERP SA 6.1.1.0 6.1.1.0 Installed
email_template Marketing E-Mail Templates Expert OpenERP,OpenLabs 6.1.1.1 6.1.1.1 Installed
fetchmail Extra Tools Email Gateway Normal OpenERP SA 6.1.1.0 6.1.1.0 Installed
hr_attendance Human Resources Attendances Easy OpenERP SA 6.1.1.1 6.1.1.1 Installed
hr_contract Human Resources Employee C...

[Amit Parik (amit-parik)]

Hello,

The problem doesn't related to document management, but the problem exist due to base_contact module.

This problem is occurs when you installed crm first and then installed base_contact module because in crm_lead.py we have inherit the res.partner.address object (on crm.lead) and location_id as well as contact_id field added on base_contact.py (res.partner.location).

So if you first install base_contact and then crm all are working expected. So this bug is same as a lp:982751.

Thanks for understanding!

[Amit Parik (amit-parik)]

Mainly we are trying to doing this also form the server side, If we have use _inheit with _name the class become modular please check lp:996816.

Thank you!