Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
1060 Prikazi

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
Opusti
Best Answer

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
Opusti
Related Posts Odgovori Prikazi Aktivnost
1
jul. 24
1316
1
nov. 24
671
1
nov. 24
1294
0
avg. 24
720
0
avg. 24
1259