openerp-connector-community team mailing list archive

[Tero Juola <tjuola@xxxxxx>]

Hi Guewen

Thank you. You are the Man :)

Tero

> On 19 Oct 2015, at 11:02, Guewen Baconnier <guewen.baconnier@xxxxxxxxxxxxxx> wrote:
> 
> On Mon, Oct 19, 2015 at 9:57 AM, Tero Juola <tjuola@xxxxxx <mailto: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/ <http://www.camptocamp.com/> 
>