search

OCA / OpenUpgrade

Open source upgrade path for Odoo/OpenERP
https://oca.github.io/OpenUpgrade/
GNU Affero General Public License v3.0
742 stars 696 forks source link

Special Characters Migrating Odoo8.0 to Odoo9.0 using OpenUpgrade #2054

Closed swidmaier closed 4 years ago

swidmaier commented 5 years ago

Impacted versions: OpenUpgrade branch 9.0

Steps to reproduce: Submit special characters to project_task -> description i.e. German Umlaute, ü, ö, ä, or "degrees" °

Current behavior: OpenUpgrade: project: error in migration script project/migrations/9.0.1.1/post-migration.py: UnicodeDecodeError('ascii', "UPDATE project_task SET description = '

SomeDescriptionContainingSpecialCharacters

' WHERE id = XYZ", 99, 100, 'ordinal not in range(128)')

Suggested fix in openupgrade.py line 1123: Change full_query = cr._obj.query.decode() to full_query = cr._obj.query.decode('utf8', 'replace')

Video/Screenshot link (optional):

pedrobaeza commented 5 years ago

I have migrated several databases with this kind of characters and having no problem. Can you put the exact text you have problem? And also the full traceback?

pedrobaeza commented 4 years ago

No answer, so closing.