← Back to team overview

openerp-connector-community team mailing list archive

Re: Prices are managed in OpenERP with pricelists error

 

Because you probably hadn't cloned the entire repository:
https://github.com/OCA/connector-magento/
Best practices are:
1. clone the full repository somewhere
2. modify the odoo configuration file and add the path of
'connector-magento' in 'addons_path'


-- 
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/

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

> Another question:
> When I try to enable Magentoerpconnect Extensions: Prices are managed in
> OpenERP with pricelists in Settings, Connector I get this error message:
> Odoo
>
> Odoo Server Error
>
> ------------------------------
>
> Traceback (most recent call last):
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 537, in _handle_exception
>     return super(JsonRequest, self)._handle_exception(exception)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 574, in dispatch
>     result = self._call_function(**self.params)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 310, in _call_function
>     return checked_call(self.db, *args, **kwargs)
>   File "/home/odoo/src/odoo/8.0/openerp/service/model.py", line 113, in wrapper
>     return f(dbname, *args, **kwargs)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 307, in checked_call
>     return self.endpoint(*a, **kw)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 803, in __call__
>     return self.method(*args, **kw)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 403, in response_wrap
>     response = f(*args, **kw)
>   File "/home/odoo/src/custom/private/loempia/controllers/embed.py", line 49, in download_urls
>     mods_to_install = Modules.compute_modules_to_install(series, module_names, local_modules)
>   File "/home/odoo/src/odoo/8.0/openerp/api.py", line 239, in wrapper
>     return new_api(self, *args, **kwargs)
>   File "/home/odoo/src/custom/private/loempia/loempia2.py", line 996, in compute_modules_to_install
>     assert len(mids) == len(set(requested_mods)), 'Unknown modules requested: %r' % requested_mods
> AssertionError: Unknown modules requested: ['magentoerpconnect_pricing']
>
>
> Tero
>
>
> On 19 Oct 2015, at 11:20, Tero Juola <tjuola@xxxxxx> wrote:
>
> 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> 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/
>
>
>
> --
> Mailing list: https://launchpad.net/~openerp-connector-community
> Post to     : openerp-connector-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-connector-community
> More help   : https://help.launchpad.net/ListHelp
>
>
>

Follow ups

References