Comment 1 for bug 1340742

What version of postgresql do you use?
Le 11 juil. 2014 15:25, "Corinne Cobbel" <email address hidden> a
écrit :

> Public bug reported:
>
> 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
>
> ** Affects: openerp-connector-magento
> Importance: Undecided
> Status: New
>
> --
> You received this bug notification because you are subscribed to OpenERP
> Project Group.
> https://bugs.launchpad.net/bugs/1340742
>
> Title:
> Error when updating connector module
>
> Status in OpenERP Connector - Magento:
> New
>
> 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
>