Comment 5 for bug 1340742

Is there a special sequence to install and\or upgrade the 3 conector modules ?
Our Odoo version is one year old, can it be an issue with this connectors version?
Thanks

> Le 2014-07-15 à 13:29, "Guewen Baconnier @ Camptocamp" <email address hidden> a écrit :
>
> I put the state to "Incomplete" because I can't find how to reproduce
> it.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1340742
>
> Title:
> Error when updating connector module
>
> Status in OpenERP Connector - Magento:
> Incomplete
>
> Bug description:
> Hello,
>
> Since we upgraded to the latest version of the connector (July 06) we
> have the following error when trying to update :
>
> 2014-07-11 12:49:29,526 8918 INFO dupray01 openerp.modules.migration: module connector: Running migration [>2.2.0] Convert jobs pickled func to bytea
> 2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp.sql_db: Programming error: function convert_to(bytea, unknown) does not exist
> HINT: No function matches the given name and argument types. You might need to add explicit type casts.
> , in query ALTER TABLE queue_job ALTER func TYPE bytea USING convert_to(func, 'LATIN1')
> 2014-07-11 12:49:29,527 8918 ERROR dupray01 openerp: Failed to initialize database `dupray01`.
> Traceback (most recent call last):
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/cli/server.py", line 98, in preload_registry
> db, registry = openerp.pooler.get_db_and_pool(dbname,update_module=update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/pooler.py", line 33, in get_db_and_pool
> registry = RegistryManager.get(db_name, force_demo, status, update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py", line 192, in get
> update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/registry.py", line 218, in new
> openerp.modules.load_modules(registry.db, force_demo, status, update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py", line 344, in load_modules
> processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules, update_module)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py", line 259, in load_marked_modules
> loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/loading.py", line 161, in load_module_graph
> migrations.migrate_module(package, 'pre')
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/modules/migration.py", line 186, in migrate_module
> mod.migrate(self.cr, pkg.installed_version)
> File "connector/migrations/2.2.0/pre-migration.py", line 8, in migrate
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/sql_db.py", line 161, in wrapper
> return f(self, *args, **kwargs)
> File "/usr/lib/python2.6/site-packages/openerp-7.0_20130314_002547-py2.6.egg/openerp/sql_db.py", line 226, in execute
> res = self._obj.execute(query, params)
> ProgrammingError: function convert_to(bytea, unknown) does not exist
> HINT: No function matches the given name and argument types. You might need to add explicit type casts.
>
> Can you help
> Thanks
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openerp-connector-magento/+bug/1340742/+subscriptions