← Back to team overview

openerp-connector-community team mailing list archive

Re: Import a record from Magento

 

On Mon, Oct 19, 2015 at 9:57 AM, Tero Juola <tjuola@xxxxxx> wrote:

> Hi
>
> I get following error message when Odoo tries to import (scheduled) sales
> order from Magento:
> openerp.addons.magentoerpconnect.unit.import_synchronizer.import_record('magento.sale.order',
> 1, '400001143’)
>
> This has worked fine before.
>
> Traceback (most recent call last): File
> "/opt/bitnami/apps/magentoconnector/connector/connector/queue/worker.py",
> line 124, in run_job job.perform(session) File
> "/opt/bitnami/apps/magentoconnector/connector/connector/queue/job.py", line
> 467, in perform self.result = self.func(session, *self.args, **self.kwargs)
> File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py",
> line 379, in import_record importer.run(magento_id, force=force) File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py",
> line 220, in run record = self._create_data(map_record) File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/sale.py",
> line 908, in _create_data **kwargs) File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py",
> line 164, in _create_data return map_record.values(for_create=True,
> **kwargs) File
> "/opt/bitnami/apps/magentoconnector/connector/connector/unit/mapper.py",
> line 934, in values values = self._mapper._apply(self, options=options)
> File
> "/opt/bitnami/apps/magentoconnector/connector/connector/unit/mapper.py",
> line 718, in _apply return self._apply_with_options(map_record) File
> "/opt/bitnami/apps/magentoconnector/connector/connector/unit/mapper.py",
> line 769, in _apply_with_options return self.finalize(map_record, result)
> File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/sale.py",
> line 511, in finalize return onchange.play(values,
> values['magento_order_line_ids']) File
> "/opt/bitnami/apps/magentoconnector/connector-ecommerce/connector_ecommerce/unit/sale_order_onchange.py",
> line 203, in play order = self._play_order_onchange(order) File
> "/opt/bitnami/apps/magentoconnector/connector-ecommerce/connector_ecommerce/unit/sale_order_onchange.py",
> line 98, in _play_order_onchange onchange_specs) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/api.py",
> line 239, in wrapper return new_api(self, *args, **kwargs) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py",
> line 5843, in onchange record._onchange_eval(name, field_onchange[name],
> result) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py",
> line 5724, in _onchange_eval method_res = method(self) File
> "/opt/bitnami/apps/magentoconnector/e-commerce/sale_automatic_workflow/sale.py",
> line 61, in onchange_workflow_process_id if workflow.section_id: File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/fields.py",
> line 817, in __get__ self.determine_value(record) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/fields.py",
> line 910, in determine_value record._prefetch_field(self) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/api.py",
> line 239, in wrapper return new_api(self, *args, **kwargs) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py",
> line 3215, in _prefetch_field result = records.read(list(fnames),
> load='_classic_write') File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/api.py",
> line 239, in wrapper return new_api(self, *args, **kwargs) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py",
> line 3160, in read self._read_from_database(stored, inherited) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/api.py",
> line 239, in wrapper return new_api(self, *args, **kwargs) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py",
> line 3283, in _read_from_database cr.execute(query_str, [tuple(sub_ids)] +
> where_params) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/sql_db.py",
> line 158, in wrapper return f(self, *args, **kwargs) File
> "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/sql_db.py",
> line 234, in execute res = self._obj.execute(query, params)
> ProgrammingError: column sale_workflow_process.section_id does not exist
> LINE 1: SELECT "sale_workflow_process"."id","sale_workflow_process”…
>
> Tero
>
>
>
>
Hi,

The table 'sale_workflow_process' miss a 'section_id' column. I guess you
updated the module 'sale_automatic_workflow' but did not upgraded the
module in Odoo. Try to start Odoo with the option '-u
sale_automatic_workflow' or run the upgrade of the module from the Odoo
interface.


-- 
Guewen Baconnier
Business Solutions Software Developer

Camptocamp SA
PSE A, CH-1015 Lausanne
Phone: +41 21 619 10 39
Office: +41 21 619 10 10
http://www.camptocamp.com/

Follow ups

References