Skip to content

[BUG]- Odoo version 19 -OpenUpgrade module - psycopg2.errors.DatatypeMismatch: argument of AND must be type boolean, not type character varying #1136

@aktiv-deep-rakholiya

Description

@aktiv-deep-rakholiya

Module

OpenUpgrade

Describe the bug

When i Migrated my v18 database in to V19 using openUpgrade moduel and normally run the scripts
getting error from delete_record_translations like below:

File "/home/odoo/.virtualenvs/odoo_venv/lib/python3.12/site-packages/openupgradelib/openupgrade.py", line 2865, in delete_record_translations
cr.execute(
File "/home/odoo/Workplace/odoo/19/odoo/odoo/sql_db.py", line 433, in execute
self._obj.execute(query, params)
psycopg2.errors.DatatypeMismatch: argument of AND must be type boolean, not type character varying
LINE 6: ... WHERE isc.table_name = 'mail_template' AND imf.transl.

To Reproduce

Affected versions: 19.0

Steps to reproduce the behavior:

  1. Create V18 database and migrate in to v19

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions