error No such external ID

Asked by Babacar DIENE on 2012-04-16

when i try to install prestashop openerp connector I got this problem and I don't know how to fix it if someone can help

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 1047, in call_button
    action = self.call_common(req, model, method, args, domain_id, context_id)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 991, in call_common
    return self._call_kw(req, model, method, args, {})
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1005, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  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 586, 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/module/wizard/base_module_upgrade.py", line 101, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/lib/pymodules/python2.7/openerp/pooler.py", line 39, in restart_pool
    registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
  File "/usr/lib/pymodules/python2.7/openerp/modules/registry.py", line 202, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 338, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 253, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 192, in load_module_graph
    load_update_xml(module_name, idref, mode)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 90, in <lambda>
    load_update_xml = lambda *args: _load_data(cr, *args, kind='update_xml')
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 132, in _load_data
    tools.convert_csv_import(cr, module_name, pathname, fp.read(), idref, mode, noupdate)
  File "/usr/lib/pymodules/python2.7/openerp/tools/convert.py", line 970, in convert_csv_import
    result, rows, warning_msg, dummy = pool.get(model).import_data(cr, uid, fields, datas,mode, module, noupdate, filename=fname_partial)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1412, in import_data
    process_liness(self, datas, [], current_module, self._name, fields_def, position=position)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1371, in process_liness
    res = _get_id(relation, line[i], current_module, mode)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1268, in _get_id
    record_id = ir_model_data_obj._get_id(cr, uid, module, xml_id)
  File "/usr/lib/pymodules/python2.7/openerp/tools/cache.py", line 18, in lookup
    r = self.lookup(self2, cr, *args)
  File "/usr/lib/pymodules/python2.7/openerp/tools/cache.py", line 46, in lookup
    value = d[args] = self.method(self2, cr, *args)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_model.py", line 647, in _get_id
    raise ValueError('No such external ID currently defined in the system: %s.%s' % (module, xml_id))
ValueError: No such external ID currently defined in the system: base_sale_multichannels.ecommerce

Question information

Language:
English Edit question
Status:
Open
For:
Prestashop OpenERP Connector Edit question
Assignee:
Guewen Baconnier @ Camptocamp Edit question
Last query:
2012-05-23
Last reply:
2012-05-23
Javier Llamas (javierllamas) said : #1

I have the same problem, Please Help. Thanks. Regards.

I have the same error. Please help to fix it.

crea_stg (crea-stg) said : #3

Me too, I don't now how to resolve it and nobody answer my questions!!

do you have the base_sale_multichannel module available and installed? It is a dependency of the prestashop connector and the error message seems to point in that direction.

Babacar DIENE (sakababs89) said : #5

Yes , I install base-sale_multichannel module from https://code.launchpad.net/e-commerce-addons .

I created a bug report for this issue https://bugs.launchpad.net/prestashoperpconnect/+bug/1003374

It tried to use a external.referential.category which does not exist in base_sale_multichannels.

Fixed on revision 48:
http://bazaar.launchpad.net/~prestashoperpconnect-core-editors/prestashoperpconnect/trunk/revision/48

Babacar DIENE (sakababs89) said : #7

With the new module : http://bazaar.launchpad.net/~prestashoperpconnect-core-editors/prestashoperpconnect/trunk/revision/48
we have a new problem
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 586, 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/module/wizard/base_module_upgrade.py", line 101, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/lib/pymodules/python2.7/openerp/pooler.py", line 39, in restart_pool
    registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
  File "/usr/lib/pymodules/python2.7/openerp/modules/registry.py", line 202, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 338, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 253, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 192, in load_module_graph
    load_update_xml(module_name, idref, mode)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 90, in <lambda>
    load_update_xml = lambda *args: _load_data(cr, *args, kind='update_xml')
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 132, in _load_data
    tools.convert_csv_import(cr, module_name, pathname, fp.read(), idref, mode, noupdate)
  File "/usr/lib/pymodules/python2.7/openerp/tools/convert.py", line 973, in convert_csv_import
    raise Exception(_('Module loading failed: file %s/%s could not be processed:\n %s') % (module, fname, warning_msg))
Exception: Module loading failed: file prestashoperpconnect4/prestashoperpconnect4/settings/external.referential.type.csv could not be processed:
 Line 1 : null value in column "code" violates not-null constraint

and i try to add in the file /settings/external.referential.type.csv

"id","name","categ_id:id",code
"prestashop","Prestashop","base_sale_multichannels.multichannels",prestashop

but i have another 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 1047, in call_button
    action = self.call_common(req, model, method, args, domain_id, context_id)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 991, in call_common
    return self._call_kw(req, model, method, args, {})
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1005, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  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 586, 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/module/wizard/base_module_upgrade.py", line 101, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/lib/pymodules/python2.7/openerp/pooler.py", line 39, in restart_pool
    registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
  File "/usr/lib/pymodules/python2.7/openerp/modules/registry.py", line 202, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 338, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 253, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 192, in load_module_graph
    load_update_xml(module_name, idref, mode)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 90, in <lambda>
    load_update_xml = lambda *args: _load_data(cr, *args, kind='update_xml')
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 132, in _load_data
    tools.convert_csv_import(cr, module_name, pathname, fp.read(), idref, mode, noupdate)
  File "/usr/lib/pymodules/python2.7/openerp/tools/convert.py", line 970, in convert_csv_import
    result, rows, warning_msg, dummy = pool.get(model).import_data(cr, uid, fields, datas,mode, module, noupdate, filename=fname_partial)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1412, in import_data
    process_liness(self, datas, [], current_module, self._name, fields_def, position=position)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1371, in process_liness
    res = _get_id(relation, line[i], current_module, mode)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1268, in _get_id
    record_id = ir_model_data_obj._get_id(cr, uid, module, xml_id)
  File "/usr/lib/pymodules/python2.7/openerp/tools/cache.py", line 18, in lookup
    r = self.lookup(self2, cr, *args)
  File "/usr/lib/pymodules/python2.7/openerp/tools/cache.py", line 46, in lookup
    value = d[args] = self.method(self2, cr, *args)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_model.py", line 647, in _get_id
    raise ValueError('No such external ID currently defined in the system: %s.%s' % (module, xml_id))
ValueError: No such external ID currently defined in the system: prestashoperpconnect.prestashop1400

Can you help with this problem?

Provide an answer of your own, or ask Babacar DIENE for more information if necessary.

To post a message you must log in.