Skip to Content
Menú
This question has been flagged
1 Respondre
1191 Vistes

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
Descartar
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
Descartar
Related Posts Respostes Vistes Activitat
1
de jul. 24
1480
1
de nov. 24
738
1
de nov. 24
1433
0
d’ag. 24
910
0
d’ag. 24
1373