Error when updating connector module
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenERP Connector - Magento |
Incomplete
|
Undecided
|
Unassigned |
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.
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/
db, registry = openerp.
File "/usr/lib/
registry = RegistryManager
File "/usr/lib/
update_module)
File "/usr/lib/
openerp.
File "/usr/lib/
processed = load_marked_
File "/usr/lib/
loaded, processed = load_module_
File "/usr/lib/
migrations.
File "/usr/lib/
mod.
File "connector/
File "/usr/lib/
return f(self, *args, **kwargs)
File "/usr/lib/
res = self._obj.
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
What version of postgresql do you use?
Le 11 juil. 2014 15:25, "Corinne Cobbel" <email address hidden> a
écrit :
> Public bug reported: modules. migration: python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ cli/server. py", pooler. get_db_ and_pool( dbname, update_ module= update_ module) python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ pooler. py", .get(db_ name, force_demo, status, python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ modules/ registry. py", python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ modules/ registry. py", modules. load_modules( registry. db, force_demo, status, python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ modules/ loading. py", modules( cr, graph, states_to_load, force, python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ modules/ loading. py", graph(cr, graph, progressdict, loaded_ modules, perform_ checks= perform_ checks) python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ modules/ loading. py", migrate_ module( package, 'pre') python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ modules/ migration. py", self.cr, pkg.installed_ version) migrations/ 2.2.0/pre- migration. py", line 8, in migrate python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ sql_db. py", python2. 6/site- packages/ openerp- 7.0_20130314_ 002547- py2.6.egg/ openerp/ sql_db. py", execute( query, params)
>
> 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.
> 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/
> line 98, in preload_registry
> db, registry =
> openerp.
> File
> "/usr/lib/
> line 33, in get_db_and_pool
> registry = RegistryManager
> update_module)
> File
> "/usr/lib/
> line 192, in get
> update_module)
> File
> "/usr/lib/
> line 218, in new
> openerp.
> update_module)
> File
> "/usr/lib/
> line 344, in load_modules
> processed = load_marked_
> status, report, loaded_modules, update_module)
> File
> "/usr/lib/
> line 259, in load_marked_modules
> loaded, processed = load_module_
> report=report, skip_modules=
> File
> "/usr/lib/
> line 161, in load_module_graph
> migrations.
> File
> "/usr/lib/
> line 186, in migrate_module
> mod.migrate(
> File "connector/
> File
> "/usr/lib/
> line 161, in wrapper
> return f(self, *args, **kwargs)
> File
> "/usr/lib/
> line 226, in execute
> res = self._obj.
> ProgrammingError: function convert_to(bytea, unknown) does not exist
> HINT: No function matches the given name and argument...