Se rendre au contenu
Cette question a été signalée
upgrademigrateodoo17odoo16
1 Répondre
2793 Vues
Avatar
Vo Nguyen Phuc Ngan

I am trying to migrate Odoo 16 community to Odoo 17 community and I am having problem, even though Odoo16 database only includes default warehouse module I installed, no custom module.


  1. Config Run/Debug
-c
odoo.conf
--database=test16_17
--update
all
--stop-after-init


 2. odoo.conf file

[options]
addons_path = d:\study\python_code\odoo_17\server\odoo\addons,D:\Study\python_code\odoo_17\server\OpenUpgrade-17.0
server_wide_modules = base,web,openupgrade_framework
upgrade_path = D:\Study\python_code\odoo_17\server\OpenUpgrade-17.0\openupgrade_scripts\scripts\

3. Error

psycopg2.errors.UndefinedColumn: column res_company.alias_domain_id does not exist
LINE 1: SELECT "res_company"."id", "res_company"."alias_domain_id" F...


I searched and found that in the source code of Odoo16 there is no field "alias_domain_id" but in Odoo17 there is


Avatar
Ignorer
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Meilleure réponse

Hi,

Manually adding the missing column can fix the issue if the migration script for the alias_domain_id column hasn’t run. To do this, open your PostgreSQL database using the psql command line tool. After connecting to the right database, run this command to add the missing column:


Hope it helps


ALTER TABLE res_company ADD COLUMN alias_domain_id INTEGER;

Avatar
Ignorer
Publications associées Réponses Vues Activité
Odoo 16 Community to odoo 17 enterprise Migration
migration migrate odoo17 odoo16
Avatar
Avatar
1
juil. 24
3062
odoo 13 upgrade to odoo 17 Résolu
upgrade Odoo13.0 odoo17
Avatar
Avatar
1
nov. 24
1688
Migration odoo 16 enterprise to 17
migration odoo17 odoo16
Avatar
Avatar
1
nov. 24
2894
migration from odoo16 to 17
migration odoo17 odoo16
Avatar
0
août 24
1872
how to upgrade modules from terminal in oddoo16 and odoo17 using docker
odoo odoo17 odoo16
Avatar
0
août 24
2678