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
>