[BUG]- Odoo version 19 -OpenUpgrade module - psycopg2.errors.DatatypeMismatch: argument of AND must be type boolean, not type character varying
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 22/100
Research direction
The traceback points to delete_record_translations in openupgradelib/openupgrade.py around line 2865, where the SQL WHERE clause compares isc.table_name and imf.transl. The filing repo is OCA/reporting-engine, but the failing code lives in the openupgradelib dependency, so check that upstream first. Done means the query runs on PostgreSQL without a DatatypeMismatch on a v18 to v19 migration.
Written by the indexing model from the issue text.
Description
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:
- Create V18 database and migrate in to v19
- Dominant language
- HTML
- Stars
- 435
- Forks
- 929
- Avg merge
- 6d 18h
- Merged PRs (30d)
- 2
Getting set up
- No Dockerfile or Docker Compose file
- No pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from OCA/reporting-engine
-
Migration to version 20.0Possibly taken A pull request linked to this issue is open or already merged. Openhelp wanted no stale work in progress
Difficulty 2/5 1-3 hours Newbie friendliness 66/100
OCA/reporting-engine#1206 · 3 comments ·
Maintainers usually reply within 1 day
-
Properties Handling When ExportingPossibly taken A pull request linked to this issue is open or already merged. Openbug
Difficulty 2/5 Under an hour Newbie friendliness 85/100
OCA/reporting-engine#1190 ·
Maintainers usually reply within 1 day
-
bug
Difficulty 1/5 Under an hour Newbie friendliness 85/100
OCA/reporting-engine#1187 · 5 comments ·
Maintainers usually reply within 1 day
-
enhancement
Difficulty 3/5 1-2 days Newbie friendliness 65/100
OCA/reporting-engine#1197 · 2 comments ·
Maintainers usually reply within 1 day
-
Migration to version 19.0Possibly taken A pull request linked to this issue is open or already merged. Openhelp wanted no stale work in progress
Difficulty 4/5 3-5 days Newbie friendliness 30/100
OCA/reporting-engine#1070 · 12 comments ·
Maintainers usually reply within 1 day
All issues in OCA/reporting-engine
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
milind-soni/OpenMausBot#5829 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 80/100
finos/fluxnova-bpm-platform#387 ·
Maintainers usually reply within 4 days
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
OHDSI/Data2Evidence#3693 ·
Maintainers usually reply within 3 days
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
Project-N-E-K-O/N.E.K.O#3725 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
kubernetes-sigs/headlamp#8408 ·
Maintainers usually reply within 1 day