UnicodeDecodeError: 'ascii' codec can't decode byte

[Wynell Patricio]

File "bin/openerp-server.py", line 108, in <module>
    pooler.get_db_and_pool(db, update_module=tools.config['init'] or tools.config['update'])
File "/home/openerp/openerp-server-5.0.0-3/bin/pooler.py", line 40, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
File "/home/openerp/openerp-server-5.0.0-3/bin/addons/__init__.py", line 680, in load_modules
    modobj.update_list(cr, 1)
File "/home/openerp/openerp-server-5.0.0-3/bin/addons/base/module/module.py", line 314, in update_list
    'certificate': terp.get('certificate') or None,
File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line 2345, in write
    self.pool.get(object)._store_set_values(cr, user, ids, fields, context)
File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line 2516, in _store_set_values
    result = self._columns[val[0]].get(cr, self, ids, val, uid, context=context)
File "/home/openerp/openerp-server-5.0.0-3/bin/osv/fields.py", line 623, in get
    res = self._fnct(obj, cr, user, ids, name, self._arg, context)
File "/home/openerp/openerp-server-5.0.0-3/bin/addons/base/module/module.py", line 116, in _get_views
    mnames[m.name] = m.id
File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line 216, in __getattr__
    return self[name]
File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line 182, in __getitem__
    datas = self._table.read(self._cr, self._uid, ids, fffields, context=self._context, load="_classic_write")
File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line 1888, in read
    result = self._read_flat(cr, user, select, fields, context, load)
File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line 1943, in read_flat
    res.extend(cr.dictfetchall())
File "/user/lib/python2.5/site-packages/psycopg2/psycopg1.py", line 83, in dictfetchall
    rows = _2cursor.fetchall(self)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 25: ordinal not in range(128)

This occurred when i do a --update=all -d [databasename]
in 5.0.0-3 on an rc1 database, to convert to the stable version

[gpa(OpenERP) (gpa-openerp)]

Can you please provide me more information regarding this bug.
 if your code is updated, then now still does this error occur?

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello Wynell,

Please tell us the language you use for this.

We would like to request you to update the code and try for the same.

If still the error appears, notify us.

As of now, we do not get such an error.

Thanks.

[Wynell Patricio (nel-fs3)]

Hi Jay,

I was able to fix the problem by forcing postgresql in it's conf file
to UTF. I can't remember the complete process i went through but I
will get back to it as soon as i can. Although I do not entirely know
if this is an OpenERP problem anymore.

Quoting "Jay (Open ERP)" <email address hidden>:

> Hello Wynell,
>
> Please tell us the language you use for this.
>
> We would like to request you to update the code and try for the same.
>
> If still the error appears, notify us.
>
> As of now, we do not get such an error.
>
> Thanks.
>
> ** Changed in: openobject-addons
> Status: New => Invalid
>
> --
> UnicodeDecodeError: 'ascii' codec can't decode byte
> https://bugs.launchpad.net/bugs/345252
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in OpenObject Addons Modules: Invalid
>
> Bug description:
> File "bin/openerp-server.py", line 108, in <module>
> pooler.get_db_and_pool(db, update_module=tools.config['init'] or
> tools.config['update'])
> File "/home/openerp/openerp-server-5.0.0-3/bin/pooler.py", line 40,
> in get_db_and_pool
> addons.load_modules(db, force_demo, status, update_module)
> File "/home/openerp/openerp-server-5.0.0-3/bin/addons/__init__.py",
> line 680, in load_modules
> modobj.update_list(cr, 1)
> File
> "/home/openerp/openerp-server-5.0.0-3/bin/addons/base/module/module.py",
> line 314, in update_list
> 'certificate': terp.get('certificate') or None,
> File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line
> 2345, in write
> self.pool.get(object)._store_set_values(cr, user, ids, fields, context)
> File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line
> 2516, in _store_set_values
> result = self._columns[val[0]].get(cr, self, ids, val, uid,
> context=context)
> File "/home/openerp/openerp-server-5.0.0-3/bin/osv/fields.py", line
> 623, in get
> res = self._fnct(obj, cr, user, ids, name, self._arg, context)
> File
> "/home/openerp/openerp-server-5.0.0-3/bin/addons/base/module/module.py",
> line 116, in _get_views
> mnames[m.name] = m.id
> File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line
> 216, in __getattr__
> return self[name]
> File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line
> 182, in __getitem__
> datas = self._table.read(self._cr, self._uid, ids, fffields,
> context=self._context, load="_classic_write")
> File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line
> 1888, in read
> result = self._read_flat(cr, user, select, fields, context, load)
> File "/home/openerp/openerp-server-5.0.0-3/bin/osv/orm.py", line
> 1943, in read_flat
> res.extend(cr.dictfetchall())
> File "/user/lib/python2.5/site-packages/psycopg2/psycopg1.py", line
> 83, in dictfetchall
> rows = _2cursor.fetchall(self)
> UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position
> 25: ordinal not in range(128)
>
> This occurred when i do a --update=all -d [databasename]
> in 5.0.0-3 on an rc1 database, to convert to the stable version
>

--
Nel Patricio
F S 3 Consulting Inc.
http://www.fs3.ph